Martin I tested with several reports using the same Fact Table, all of them fail , when the Fact Table is last in the From definition, I am not saying that the error is caused for moving the Table, but there is a BUG in the database probably, with some other conditions, and when moving the table, it worked for me. However…

This was just an error posting the question It should say .... FTable 1 T41570, View2 T41683 where ( T41412.ID_TIPO_EVENTO = T41570.ID_TIP_EVENTO.....

You are right! Thanks

I am using 11.1.1.7

Hello Gianni I am using 11.1.1.7.150120, and it works when i revisit the report Thanks Camilo

Thanks Gianni I have being testing and seems to be a problem with my Network configutation, I revirewed the Development View of the Browser and it shows errors (only the first time for certain criteria) ajax.js:1 Failed to load https://www.gstatic.com/charts/loader.js: Response to preflight request doesn't pass access…

Finally I did it creating a new Fact Table based on a Select which contains de Join. Not an elegant soluciotn but it works and runs fast Thanks

Thanks For your answers, I am performing some tests The tables are joined by conformed dimensions, however it does not resove the problem , i wil explain below 1.- When i just use fields from the 2 fact tables in the report , one of the values is NULL 2.- When i added a column of a conformed dimension (i used year ) into…

It is not a Server Copmplex Aggregate , only a Count (Distinct()) in the RPD, and Default(Sum) in the Presentation Server

Yes, It is required, that is the data that teh report needs to display

Hello Joel I have tested this using another fact column, which does not use REPORT_AGGREGATE, and it worked , apparently there is an issue with hit cache with REPORT_AGGREGATTE and filters If the query does not have Report_agregates it works even when the query is a subset of the cached query if the report has…

Removed all the filters of the firest query and yet the second query (filtered) does not hit the cache Query Cached: SELECT s_0, s_1, s_2, s_3, s_4 FROM ( SELECT 0 s_0, DM.T1.F1 s_1, DM.T2.F2 s_2, DM.T3.F3 s_3, REPORT_AGGREGATE(DM.T3.F3 BY ) s_4 FROM DM ) djm ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST FETCH FIRST 65001…

This is what my last answer should say just campared the cached query and the new query executed and the only difference is the promped value (which is included in both cases in the select statement ), I still don't understand why it does not work. It does work when the select matches exactly the cached query Cached Query…

I just campared the cached query and the new query executed and the only difference is the promped value (which is included in both cases in the select statement ), I still don't understand why it does not work. It does work when the select matches exactly the cached query Cached Query SELECT a , b , c FROM ( SELECT…

Joel Thas is exactly what I am trying to do, the cache is populated correctly, without filtering by prompts, but the query cached is not used Camilo

Hello Robert One clarification, the cache is being populated, but ot used Camilo

Insetad of "However, should not this work with OBIEE 75 bits if it is Win 64 , and the OBIEE installed in the server is 64 bits too?" It should say "However, should not this work with OBIEE 64 bits if it is Win 64 , and the OBIEE installed in the server is 64 bits too?"

Hello Handat Thanks for your answer, I have Windows 7 , 64 bits Also , when I install OBIEE Desktop 32 bits (in this Win 64 ) the Admin Tool opens, but it can't connect to the Server when try to open the RPD in online mode , I'll check if that is a different isssue However, should not this work with OBIEE 75 bits if it is…