lookup for getting measure slice in oracle rpas

Hi everybody,

I need to take a measure slice. For example, if I have a measure "Sales" with intersection "day,item" and a scalar measure "Item To Choose" which contains a position name in "item" dimension, I want to make the following:

1) Specify an item in the "Item To Choose" measure

2) Get "Sales" time series for a specific item and put the result in the measure "Fixed Sales" with "day" intersection

If the item specified could be always the same, I would use the flookup function in such manner:

FixedSales = flookup(Sales, [prod].[item].[item1])

where item1 is the position name of the necessary item.