Define prompts on BEx query in universe

[Former Member]

Universe is based on BEx query.

I have three objects: Calendar Day (Start Date and End Date) as Prompt, Plant and Material.
Following are the prompts:

Enter Calendar Start Date:
Enter Calendar End Date:

Enter Plant:

Enter Material:

Now, lets select Start Date as 01/12/2013 and End date as 16/12/2013.

Select Plant As Tremely Inc.

Depending on the above two values, how do I define Material so that it is filtered and it should show the Material values which correspond to the Tremely Plant and Start Date and End Date .

Thanks,

Antara Das

[Former Member]

Hi Bhargav,

Thanks for the reply.

I tried the statements in the Where clause by creating a new Material-Prompt object but while creating the Webi report I get error "Error while refreshing the document" error message.

Please let me know if you have any idea about the error message.

Thanks,

Antara Das

[former_member189638]

Any specific reasons why you are looking to do this at Universe end??

You can try this at the BEx end with a Customer Exit variable for Material and writing the cmod code in i_Step =2.

Please search the BEx forum and you will get the threads with such queries already answered.

[Former Member]

I was actually trying to implement this at the universe level. But am not finding any ways to do so Anyways seems like will have to implement this at the BEx query level. Thanks for the reply Rakesh.

[Former Member]

Hi Antara Das,

Please try this once may be useful to you.

Create a Material Promt in the universe level. Then you can run the report

<FILTER KEY="[0_Material].[LEVEL01]">

<CONDITION OPERATOR CONDITION="Equal">

<CONSTANT CAPTION="@Prompt('L01Material','A','Material\L01Material',mono,constrained)"/>

</CONDITION>

</FILTER>

Regards,

G