Fairly certain you don't recall incorrectly, I too have battle scars from trying to get this to work, and agree totally an SR is the best way to go.

To expand on 'how' in the business model layer you would expand the LTS source folder and drag the outer limb of the star onto the already modelled inner dimension. This will combine the two tables via a join showing one LTS and you can then change the nature of the join if you wish. This means your snowflake is flattened…

Agreed, data fudges are just nasty, but being able to segment your revenue into homogeneous groups - not a bad idea.

Taking the bins thought further you could even divide the revenue by total revenue and have a smaller than 80% filter or selector, that would remove the ice berg from a graph with ice cubes, and would work forever....

Or use "bins" to group revenue ranges into A, B , C , D, E (or even yes / no) groups and that put your dashboard prompt group filter on that

No, he cannot do that, that is a serious breach of Oracle's terms and conditions, you need a customer support id to access that document.

Did you find your answer? If so would you mind closing the question and marking correct / helpful as appropriate. If not do you still need any help?

Sure, for the dimensions / fact(s) in the analysis can you make screenshots of; - business model relationship, dimension hierarchies with keys visible and content level settings on logical table sources If the physical layer is more complex than Fact -> dim1 (join via FK) Fact -> dim2 (join via FK) for the physical layer…

Hi, you can have timed agents that run based on a condition being true, so you could have your dashboard prompt set a presentation variable and the presentation variable be used in an analysis which is used as the basis for evaluating if the agent should run which sends the report. So yes doable. Btw - do give yourself a…

Hi ForSly, re: DDL - it is not this I need to see, it is the rpd modelling, if you only have 'front end' access to OBIA then I am fairly sure i cannot help you, except to advise the massively sub-optimal workaround of writing a direct database request to get your result. And seriously, I have implemented OBIA previously…

Hi, I know you did not like my advice before, but we have a phrase in Yorkshire; "You cannot make a silk purse out of a sows ear". In this context, you will not get good results out of a faulty data model. You have bigger issues than this one query, which if you never resolve you will always be stuck with the same problem,…

See also - > OBIEE 11g Hide/Show Sections based on Dashboard Prompt ~ Oracle Bi Solutions

No, sorry, I do not know of a means of synchronizing your column selectors too. On the presentation variable idea it is; - 1. Section visible or not based on an analysis 2. Variable drives visibility by defaulting to value that would always yield no rows via a filter on the analysis in question 3. On selection of a…

Hi, truly not grubbing for points, just trying to get you to close this, you need to click on 'Assumed Answered' to close (Answered does it also (but not helpful which is what you did) - but as I said I am truly not out for points, just trying to get you to close the question so others don't waste their valuable time…

Hi again Lianne, the other thing that you could try is making your report invisible based on another report not returning data. Use a filter with a presentation variable with a default which will never return data, like Month = @{MyPresentationVariable}{NoMonth} Then have your presentation variable setting to another value…

Btw - do give yourself a user friendly display name, long time users are more likely to engage with you than if you just leave it as the default.

There proposed solution is that you replicate your entire page but with the additional analysis, then set it all as hidden. So your action link takes you to what looks identical to the current page but with the additional section visible. Make sense?

One way is detailed here -> https://it.toolbox.com/question/display-page-in-obiee-answers-092911

Thanks - as a minimum could you kindly close your question - and mark correct / helpful if you feel it might help others.

Is your set up multi language, could the below apply? OBIEE 12c : Error: "The system is unable to read the Write Back Template 'writeback'. Please contact your system administrator" when using WriteBack (Doc ID 2307381.1)…