OLAP Universe filter

[Former Member]

Hi All,

I am creating a OLAP universe on top of the SAP source.

In the universe, I created a filter, where in i am restricting the Product ID object with the extracted value(of number type) being passed from the Prompt as below.

<FILTER EXPRESSION="IIF ( [ZBOPROD].currentmember.properties("[2ZBOPROD]") = LEFT("@Prompt('Enter Product ID','N',,Mono,Constrained)",4) ,1,0)">

<CONDITION OPERATORCONDITION="Equal">

<CONSTANT CAPTION="1" />

</CONDITION>

</FILTER>

[ZBOPROD] object in the source contains the Product Ids: 1111 (in this format).

Where as from the Product ID prompt, i will be getting the 6 digits product id : 111122 (in this format).

So i wanted to extract the first 4 digits of the prompt value passed and compare it with the [ZBOPROD] object.

But in the universe, this expression can't be parsed saying Invalid definition.

Can anybody help me in resolving the issue.

Also, please suggest me any other approach to achieve this.

Thanks in advance,

Leela

[Former Member]

Can anyone help me on this..I believe there is a solution for this issue. Please help me with this.

Thanks & Regards,

Leela

[Former Member]

Hi Leela,

As per your posted synatx has some spl mistakes,

Try below syntax.

<FILTER EXPRESSION="IF ( ZBOPROD.currentmember.properties("2ZBOPROD") = LEFT("@Prompt('Enter Product ID','N',,Mono,Constrained)",4) ,1,0)">

<CONDITION OPERATORCONDITION="Equal">

<CONSTANT CAPTION="1" />

</CONDITION>

</FILTER>