Skip to Content
0
Former Member
Oct 22, 2008 at 03:27 AM

SAP BW Universe OLAP @prompt LOV using object reference not working

14 Views

I have tried to follow Didier MAZOUÉ's "[OLAP universes best practices|https://boc.sdn.sap.com/node/20081]" document to create calculated measure in a OLAP universe built on top of a BW cube directly. The objective is to get the revenue figure from the same period of the previous year. I wanted to be able to have a LOV to specify a period when the object is used in a webi report.

When I hard coded the LOV as a data set as displayed in the following example ( {'[CD2007009]','[CD2007010]'} ) The prompt worked as expected.

(PARALLELPERIOD(.[LEVEL01],1,[0FISCPER].@Prompt('Period?',A,{'[CD2007009]','[CD2007010]'},mono,free)),[Measures].[0G_AERLOS])</EXPRESSION>

When I build my expression using an object referece as ( 'TimeFiscal year period' ), I was given an error msg saying "invaid prompt definition". I verified my spellings and syntax and they were correct based on the examples provided by the best practice document.

(PARALLELPERIOD(.[LEVEL01],1,[0FISCPER].@Prompt('Period?',A,'TimeFiscal year period',mono,free)),[Measures].[0G_AERLOS])</EXPRESSION>

Is there anything obvious that I missed. Or there are some extra configuration I have to do on SAP BW or Universe side?