Just one dashboard prompt which populates the DatePresentationVariable variable in my example. The others can be session variables which store the values of the start and end year of your data set.. I just wanted to avoid hard coding the start and end year values

Hi @1092369 So you'll need a presentation variable to hold your start year (@{StartYear}{2010}) and the 2nd to pick year selected by user from your dashboard prompt (@{DatePresentationVariable}{2015}). the 3rd will hold the end year (@{EndYear}{2017}) In the first report which should display from start to user selected…

That was going to be my next suggestion - to remove the REPORT_AGGREGATE. If the Aggregation Rule of a measure is set to Server Complex Aggregate then OBIEE will do a REPORT_AGGREGATE. Is this required on your report by the way?

Try caching the query without a filter and order by: 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

the runcat.cmd/sh does open the catalog manager but it can also be opened on the command line try: ./runcat.sh -help runcat.cmd -help

Not sure of a web API but you can use the runcat.cmd/runcat.sh catalog manager command line utility to do this. Check section 16.4.1: https://docs.oracle.com/middleware/1221/biee/BIESG/prescatadmin.htm#BIESG2905

Try this: https://docs.oracle.com/middleware/12213/lcm/BIEIG/GUID-D5AFD830-8A7D-42CC-8C22-CE68C452CF4A.htm#INSOA369

Can you login as any of the missing users? Have you maybe got a filter set on the WebLogic User page:

OK @Christian Berg Didn't realise that the OP had multiple threads.

It would be useful if you could provide a screenshot showing what your issue is.

Can you run the Catalog Validation.@FTisiot wrote an article describing the Catalog Validation process. Try this then check your Agents afterwards.

What is your OS? What version of OBIEE are you using?

Open your Pivot Table properties and select Null values settings as appropriate

Not sure why you don't have the HTML option in the Data Format dropdown. I don't have 11g handy to verify (screenshot below is from 12c). Try selecting Custom and then add the @[html]@H format mask. Also look at this

Does the user have the "Save Content with HTML Markup" privilege?

As mentioned before, remove all of the the WHERE clause from the cached query. This is what you should be seeding: SELECT a , b , c FROM ( SELECT "xx"."xx"."Gls Nacionality" s_4, ..... FROM "Proyecto X"

How about helping us to help you by providing all the necessary information like the OBIEE version as this has some bearing on the solution that can be provided.

Hi @Camilo Flores Extract the Logical SQL from the advanced tab of your report and copy and just remove the filters (from the logical SQL) and then use this to seed your report to cache.

The other way round definitely but not sure you can "downgrade" catalog objects.

1st question, do you have a custom skin/style? If so, have you tried without the custom skin/style and do you still get the same error?