I think he knows this, but what he wants is that if you change either value then the other prompt goes back to its unselected state, as cf your male / female example you could; - Select Gender Male Select Actor Tom Cruise Go back to Gender select and select Female Leaving Tom Cruise Female.

This is not difficult, you just create a new table in the physical layer but change the source to SQL and write / copy your code in...

'Excel rules supreme'. Yes, and Trump is the democratically elected President of America. Just because it is popular does not make it right ;-)

Only with javascript.

Hi Christian, this might just be me but data in spreadsheets is rarely rigorous. I would trust BI more based on well defined data feeds going through sound API and then being restructured by well designed and implemented ETL processes. What non-IT professionals see as a 'fast win' should usually be put against a wall and…

Thanks, mine might have been a more extreme example as data was coming from HPCM...

Hi Ebin, I know you came here for help, but would you mind answering a question, if you compare a like for like query when using Smart View with the performance that you get running the same query through OBIEE to Essbase what kind of performance do you experience? The reason I ask is that a number of years back I was on a…

Hi Sandesh, my points are; - Creating your measure which just gives 1 for shipped late, 0 otherwise (simplified) as a PHYSICAL calculation will force OBIEE to do the logic FIRST and aggregate second. This is one of the crucial factors. Create your measure which counts pinning it at the total level on the dimension…

I find % calculations, divisors and case logic etc are 'tricky' when done in the front end, but something that often helps is to change the setting to server complex aggregate, forcing the solution to calculate it in the 'backend' not on the client. My preference though is to create measures in the rpd for these kind of…

The number of times I have seen content level unset on production systems I am not sure that there are even that many that understand the simple concept of LTS, much less the underlying complexities that it allows.

Okay - touché - maybe it is a triad of most important - but I would see keys / content levels as part of the same fundamental issue...

You are in the right place in the business model. What I am trying to tell you is that you can take your base measure, create a copy, and drag it to associate it with a specific hierarchical level in the dimension hierarchy. So, for your value that has duplicate IDs, create a dimension hierarchy that includes that in one…

Hi Christian, I have been on projects where basic OBIEE functionality was never used and it always leaves me with a bad feeling as you are leaving the client with something that they might struggle to support and Oracle will not support. Are there any ways to 'lobby' Oracle for new functionality, other than 'raise an…

Hi Mark, Thank you - I have a thick head myself some days, so I try to be understanding when the penny does not fall for others.... On the join my preference would be using a single key for the join, sure you need the dates to generate the new key, but the join itself will work fastest just based on fk = pk and doing this…

One more thing to add, the key issue is what is it that changes that triggers the new record, once you have this you have the logic of whether in the ETL there is something to add this month (and end date original) or not.

Sure - What I am saying is that at the point in time that you get a new member, or for the first period you populate then the member will have a parent a start date (or period), an end date (or period) (which may start life null or far future) and a surrogate key. This will remain the same until the member changes…

If you want history to move to the new structure then you just need an ETL that populates the hierarchy 'as is now' and FK joins from the members in question to the hierarchy. If you want to see everything 'as was' alongside 'as it is now' then you need slow changing dimension functionality as indicated. This means that…

Not sure if we are talking about Essbase or relational, presuming the latter. Copy your existing Fact measure in the rpd. Paste the copy onto the appropriate level of the hierarchy. Set the aggregation rule. Rename as appropriate.

If your security is in AD then your auditors should be auditing AD, but you can get info out of the tracking tables if that is configured, though this will be restricted to active users only.

I stand by my original answer, provided you have decent dimension hierarchies then you can use them to say that another fact only relates to it at total level, or by a specific key level. You do this by going into the LTS and making sure that the dimension and fact have the correct settings. If you have ever seen OBIA then…