Christian is telling you; - 1. Delete the document from MOS above or you could be in trouble with the boards 2. You will have to reinstall to fix it OR revert to back up - those are the options

No back up to revert to?

I do not think you can achieve what you want with out of the box functionality without building a separate prompt to act as the prompt for what operator you want to apply and then making the filters in each of the parts of your query massively more complex by having the equivalent of this ({PromptOperator} = "Equal To /…

Hi sweetie, word from one who has been there recently - do mark their help as helpful / answered and / or close your question if you ever want to ask another question again on these boards... If they have not answered your question or you do not understand their answer then do give them more detail, they can only do so…

If you need a fast fix then you could use the physical sql generated in opaque view or direct database request. For a longer term fix I would look at the fact to dimension levels set in the LTS

If you had the right answer with the region in can you make region hidden using the format properties to get the right result, or does that yield the wrong level of summarisation?

I'll try out your ideas and let you know, but it is no small box of wires, so I may be sometime...

Keep it physical when multiplying, sound advice!! ;-)

Sorry, I'm a bad girl... Your resident angel solved my problem, he was dead right, but I will follow the rules next time...

Very, very kind Martin, thank you Sadly, I am where I was, without OAC and so without Essbase reporting. Oracle, if you ever listen, this makes zero sense, both PBCS and Fusion are in the cloud, there should be a bridge built to allow OTBI reporting against PBCS!! Now I will go cry myself to sleep....

A PBCS reporting database. I had read that you could only access this with visual analyzer, not with OBIEE or OTBI, hence when you said 'visual analyzer license' I wondered if this would also provide the means to report against PBCS?

Also, on "visual analyzer license", if we purchased a visual analyzer license would that then also provide the ability to access a cloud based Planning database for reporting through OTBI?

Thanks for letting me know, I don't suppose you know if this is included in Fusion Financials - my question is OTBI related?

Yes, do you know if this also applies to OBIEE delivered through Fusion Financials?

Is there any other way to use prompts with filters, but selectively so some are not affected?

Thank you also!

Gosh, that was easy - very kind. Thanks.

Wow, 5 minute job instead of 5 x 20 x 10 minute job, thank you Robert Angel

Hi, try this on an ODI forum or on an Essbase forum, just not here!