Sounds like your services need restarting.... but as Joel says we need to know more.

My turn to echo your sentiment...

Hi, no, nothing wrong, that is how it works. If your time hierarchy goes down to days then you could use days ago with a standardised number of days for a pseudo month or based on the number of days in the current month. Then I guess you might have a different issue, how many working / selling / etc days depending on what…

That is funny, I nearly came back to the board with an additional - or the data in your underlying tables is wrong.... Thanks for your thanks, sometimes you try heard and do not get repaid with courtesy, it is appreciated.

Sure, your model is wrong! Seriously, double check that all of your joins are valid and complete. Double check that the fact to dimension Logical Table Source contents are set at the correct level of detail. Double check your keys. The answer will be in one of those factors.

Hi Dennis, the problem comes in that OBIEE tries to aggregate on the highest level, and I have found that often with case statements this results in spurious results. Two suggestions; - Best - push your cash logic back into an rpd measure, make sure it is a physical calculation Might work - use the server complex aggregate…

Sounds good, but other than just using the off the shelf dashboard functionality, which you quite obviously do not want to do, then I fear my original answer stands, there is no magic bullet for this.

And your customisation does not cause any issues with the standard security model? i.e. What happens when I as a user do not have rights to access 'This is DB2'?

You can set up an action link on your 5 column, which navigates to the same report but with the detail columns added. You would put an 'is prompted' filter on the column you need to have corresponding to the 'master' report.

Yes, that is what I was trying for.... and failing obviously! 

You have master / detail and action link options amongst others, but you need to express your requirement a little clearer before we can help with better suggestions.

Don't believe you can do that without hacking the core product, which you don't want to do as that would invalidate your license agreement with Oracle. Your only option is manual / procedural. Though manual could be facilitated by having a standard text area which you tell all developers must be included in every dashboard…

This is also a useful A,B,C Srinivasan Software Solutions : ORACLE APEX INTEGRATION WITH OBIEE 11G

Not a document as such, but there is some nice blog content out there; - https://gerardnico.com/dat/obiee/obips/apex

Raise an Oracle Service Request (SR) via My Oracle Support describing what you describe above. Make it priority 1 - total loss of service. Provide liberal screenshots proving exactly what you said above.

On 'if the user did not select the prompt' - then both reports would be unfiltered, or filtered by your default selection if there is one. On where is the scope, you need to look in the dashboard page for the control that sets the scope of the prompt, it is done this way as you may use a prompt for multiple purposes /…

Not understanding your exact requirement, so I may be off beam here, if I am then kindly explain further and separate out your problem. Three options spring to mind; - Assuming the report that you want to drive the action link target report is filtered via a dashboard prompt then just have your target report also filtered…

Hi, I am not following why this is a problem? What you are describing is 'how it works'....

If cache does not clear your issue you might want to try making a trivial change, save, unmake a trivial change, save - i.e. regenerate the report on the current version. Btw - you also do not say what the error is that manifests?

For an example see => https://oraclebizint.wordpress.com/2007/12/05/oracle-bi-ee-101332-bins-and-groups/