Skip to Content
0
Former Member
Apr 23, 2010 at 11:18 AM

LOV Filtering on OLAP universe

95 Views

Hi

i have a BOXI 3.1 SP2 FP2.6 universe on top of a bex query (BW BI 7 SP5)

my bex query contains a variable 'ready for input' which give me a prompt condition on BO universe.

My BO condition has the default LOV <Variable name> which gives me 2 hidden objects <Variable name> and <Variable name>Base.

this hidden object displays a list of values on prompt in my report. i want to filter the list of values on 2 single values (from the whole list).

I know i can define the 2 single values directly in my prompt by filling the 'value ' and 'key'. But my 'value ' are static.

I'd rather to limit the list of the LOV directly on the hidden objects <Variable name> or <Variable name>Base of the universe on the 2 key of my requested items

is it possible ?

thanks in advance,

Rgds,