Hi Dimitris, what I am suggesting is that you use your {PresentationVariableName} in the filter itself, using some sql to parse out the values first. You may have to use 'Is Protected' to prevent the default prompt behaviour from causing your error above.

Sorry, think I may have given you an old solution that is not applicable to your version, and I don't have a local on premise OBIEE to experiment on.

There is also a weird string generated for the 'All Values' value, so you can also emulate that logic with a simple case statement....

Hi, I am sure I have done similar, yes. Just 'catch' the variable in a filter, against, a dimension text field to see what it passes (look in the log or examine the where clause in the SQL evaluated when it gives you no results), chances are you can use a simple piece of substr instr type nested logic to pull the part of…

Did you restart your services after the change?

But if you are willing to get intrusive see; - OBIEE: Data Labels on top of pie chart

Not using standard functionality, no.

I have to agree on this one. OAC is OBIEE "lite", most of the OBIEE content but with less rpd... Why does it get to be the only one out of the OBIEE 'family' that gets to connect to PBCS?? In the absence of a decent workaround are Oracle hoping this will leverage OAC sales? And no - I don't call export the data and…

Hi, even with databases 'external tables' are not a panacea for all ills. You still get rejected records. It will not perform as well as a true database table. There will be database functionality that you cannot use with an external table. Best, as @Gianni Ceresa rightly says is to load it.

OTBI? Not had the pleasure recently, but this would seem to say yes; - http://www.ateam-oracle.com/extracting-data-from-oracle-analytics-cloud-using-soap/

This => https://www.rittmanmead.com/blog/2016/06/obiee-12c-extended-subject-areas-xsa-data-set-service/ ???

Hi, are the dashboard prompts saved under the same folder structure as the rest of the dashboard, if not have you checked down the hierarchy of folders that the dashboard prompt is in that there is nothing that would prevent your BI Consumer user from seeing it?

Hi, I would check if the numbers come out correctly when presented in a table view, if they don't then I would suggest that you have a problem with your model and would suggest that the Logical Table Source content levels need reviewing between your measure and the time dimension.

Btw, on a simpler basis have you tried starting with the objects bigger but allowing 'can shrink'? - I am a big believer in keeping it as simple as it possibly can be, and for me your requirement is over engineered. The point of BI is the INFORMATION, the 'cosmetics' of the dashboard appearance very much secondary.

Look on this page for resizing, the example cited is old but the principal does not change; - Oracle Business Intelligence Developer Blog

Thanks again!

That looks hot off the presses! Is there a way to subscribe to new documents relating to a product that you are using, or were you just searching 'My Oracle Support'?

You would have to create two versions of the reports. One with the larger scale to fill the dashboard, the others at the smaller scale to display when the others are selected. Not good for maintenance but would give the effect you are seeking. Alternatively you might want to look into javascript to achieve your ends.

Hi, you must have One Total Level and One Detail level and whatever in between. If you remove one alternative path from top to bottom provided what you leave is still complete then your hierarchy will still be good. You could move your none needed hierarchy members into their equivalent tier on the hierarchy that will…

Hi, I have not tried it, but see => Oracle Business Intelligence: Setting up iBot to save report to a folder You might also find this useful, as it sounds like your requirement is somewhere between the two => https://it.toolbox.com/question/how-do-i-place-todays-date-in-an-ibot-email-subject-line-062907