I am a newbie to OLAP Universes.
We are using SAP BW infocube as an underlying universe for BO reporting.
I need to create a simple object which should prompt the user to select several values or select ALL
For Example:
Enter Product:
Distinct Product values are: P1,P2,P3
In case the user wants to select all of them, then how is that supposed to be written in XML tags in SAP universe
Any help on this shall be appreciated.
shilps (BOB member since 2005-06-28)
I got the solution for this but works partially.
I have done all possible trial and error thingies and am now struggling to understand how to achieve this condition.
In a normal Universe, this is a very simple condition like:
Writing in the where clause of the object as
Product.Prod_nm=@prompt('SELECT Product or ‘ALL’,‘A’,{‘ALL’,‘P1’,‘P2’,‘P3’},mono, constrained)
OR
‘ALL’=@prompt('SELECT Product or ‘ALL’,‘A’,{‘ALL’,‘P1’,‘P2’,‘P3’},mono, constrained)
This works fine for a universe but since the OLAP (SAP BW based) Universe requires the MDX or XML tagged syntax, i am unable to code in that part
Until now, this is what i have achieved, which works fine 
but the second part where I am supposed to write the OR part and the condition for ALL - doesn’t seem to work. 
Can somebody help how the operator condition needs to be written.
shilps (BOB member since 2005-06-28)
Make it as an optional prompt is SAP BW. Prompts defined in BW are taken care by BO
Regards,
Pracheer
pracheer 
(BOB member since 2007-02-06)
Hi, were you able to figure this out? what is the best way to do “All” on the OLAP universe?
kaavalan (BOB member since 2008-12-16)
I’m not going to say that it’s not possible to implemement this in Designer level, but there is a option available in WebIntelligence called ‘Optional prompt’ which act as a ‘All’ value. If you want to see ‘All’ among other values, then I would forward this request to developers who are responsible for OLAP stuff
Antremons (BOB member since 2006-03-21)