Hi, if your result is null, and this does not cause your default member to be selected then you can use the IfNull function in your case statement to handle it.

You beat me to the post on this one...

Hi, no - I am fairly sure this is long gone, but you can still download Oracle Virtual Box and the associated OBIEE VM for this. OBIEE Samples

Sorry, I may be misunderstanding you. Are you saying that if the dashboard filter selection is 'All Values' then the entire filter is removed from the analysis when it runs? I have not seen this before, are you certain that that is the case? What I was suggesting was that your default (value in the second {} ) would be…

You can use your default value in the afore mentioned case logic then. This has changed from other versions.

1. You need to ascertain the explicit value that is being passed for 'All Values', as I said it generates a strange but consistent string combination which you need to use in place of 'All Column Values', as previously advised this can be found by running the analysis and then viewing the physical sql generated via the log…

"CC - Business Unit"."Business Unit - OpCo" IN case when @{PV_SELECTEDOPCO} = 'WhateverTheCombinationIsForAllValues' then "CC - Business Unit"."Business Unit - OpCo" else @{PV_SELECTEDOPCO}['@']{A} end

All Column values is another factor, from memory this returns some strange collection of characters, the only way I have found to make that work is by using a case or similar logic switch to substitute the combination of characters with the obiee column you are filtering (i.e. it will always equal itself!) I don't have…

Mmm - think this might be '@' doing, try losing the speech marks around '@ ...... A}' and see what happens...

Your speech marks are incorrect, they need to not be in the second set of parenthesis, but instead thus; - '@{YourPrompt}{YourDefault}'

Hi, Yes, based on dashboard prompt scope. On your multiple text values in a presentation variable see => https://www.obieetips.com/2014/05/obiee-11g-using-multiple-value-for.html Hope this helps?

Kindly also note that without using alternative means (presentation variables for filters, GO URL etc) the source and target must be in the same subject area or the standard filtered drill will not work.

Hi, the link is a little old, if you have 12c (you don't say) you might find it easier; - https://gerardnico.com/dat/obiee/obips/go_url It is heavier syntax, but much more powerful in terms of what you can achieve with it. Typically drill down behaviour just uses the current row of data to filter the target report, if you…

You might want to have a look into Go URL functionality, or clarify further your requirement further with more detail if I am not understanding your requirement correctly. You might also want to rename your user id, the long timers on the board are suspicious of those who do not rename their accounts as being time wasters…

On your dashboard prompt you make the prompt populate a presentation variable; MyMonthPrompt; for example On the target analysis you reference the presentation variable in the filter; - Is Equal To / Is In '{MyMonthPrompt}{Jan-18}' In my example the value in the second {} is the default value if nothing is passed. If this…

Hi, not one to discourage, but this doesn't seem like a like with like comparison. Technology aside, you have lengthy experience with Power BI and associated database and now you intend with no prior experience of Oracle equivalents to attempt to build an Oracle solution whilst on the beginner slopes of the learning curve…

Hi Mike, sorry, think I was misreading your requirement, it is before my first coffee too.... If you have developer access to the rpd then you can set up a lookup table, I think this is more what you wanted; - https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-lookup-tables-sparse-and-dense-lookups/

You might find a workaround by; - creating an analysis which returns just the key values you want to filter based on; save as Analysis 'A' creating another analysis and there using the filter based on the value on another analyses to use the values returned in 'A' to filter the corresponding area in your subject area. Not…

Thanks for letting me and the wider world know, and thanks for the thanks, appreciated!

Have you tried restarting the services?