Oracle database supports OLAP, but if you want the best look into Essbase.

Hi again, see => https://gerardnico.com/wiki/dat/obiee/obis/measure_nested_aggregate In particular -> Complex Nested Aggregate : Aggregate of a conditional aggregate Thoughts; - Do you have any access to the ETL to add a new measure to achieve what you need? Have you tried including ALL columns involved and adding an…

Btw, the case statement was your addition, I actually meant to put this in columns and then reference one column in the condition of the other column, and make sure you include your fields that must be unique as a combination. p.s. Sounds like you need a surrogate key on the data to reflect the slowing changing data…

Make sure you have server complex aggregate on this, a lot of the time the result of case statements fails because OBIEE tries to evaluate AFTER aggregation

Sorry, the -2 is just to indicate it is the second column, don't minus two! And you still need the other columns that are unique in the answers report.

A simple way in answers would be to put a min function on Position Description, and a max function on Position Description - 2 columns and then a third column with a case statement saying if column 1 <> column 2 then 'Duplicate' else 'Ok' - stick a filter on that and job done.

Sure. Assign your received date value to a presentation variable. Use the received date variable on a dummy field populated with todays date +1, with the condition < Use the presentation value as the value, and make its default date '01-JAN-2449' {ReceivedDate}{01-Jan-2449} - note the edit meant to include the word…

The only other workaround I can think of on this one would be to turn it into a UNION ALL query, where the second half of the query has no output when the first half has output, and vica versa. This would make the report harder to maintain and would mean that it took longer to run. It is a nasty way to achieve your ends.…

Hi, in answers one of the options is the No Result view, you can change this to 'dummy' your heading list or whitespace. Note also you can use the report as the basis for the report being run, and then nothing would be sent.

Something to try is can you view data through the physical table(s) that you have used in the subject area with the connection pool they have been created under. Table does not exist implies that either your physical table is misnamed, or your connection pool does not have rights to view it.

Hi, you will always see the logical subject area addressed in OBIEE, you need to look into the log files to see the underlying physical table names addressed.

Sounds like a pivot table - but - a fuller description of what you are trying to achieve would help?

In conjunction with Asim's comments note you can also filter the table in the physical layer, or create an opaque view as he alludes. This is only if the condition always applies, otherwise you need to add additional variable based logic to achieve this, in a similar fashion, though not in the same place, you would use to…

Sorry, misread your original my case statement was presuming you wanted your action links in an answers presentation... As it is my learned college is correct with the conditional links, all you need to do is create X number of answers analytics, where X = the total number of links and X1 only returns rows when you want…

Other way up for your logic, take your existing link, put it through a case statement to generate all the variations you need, job done....

This is not a problem with level based hierarchy, I have implemented similar with similar data 'challenges'. Note, parent / child is more restrictive than level based. Note, level based is generally okay as long as you have more members going down the hierarchy at each level. Hope that clarifies?

See also => Clear Dashboard prompts when user navigates away from the dashboard And generally; - https://www.google.co.uk/search?source=hp&q=obiee+javascript+reset+dashboard+prompt&oq=obiee+javascript+reset+dash&gs_l=…

See this for similar requirement; - https://www.jamescoyle.net/how-to/1907-javascript-to-refresh-all-obiee-dashboard-analysis It is not a massive change on the above to address your parameters - good luck!

As previously stated only by writing your own javascript on the page in question to achieve this.

I agree no magic bullets, but; - Have you looked into caching strategies, particularly that preseed cache for most used reports? Do you run standard reports on a timed basis out of hours? Do you write your reports to ensure underlying indexes can be used? Do you have pre-aggregated content for reports that aggregate a lot…