Populating a Universe Parameter using Prompt of an OLAP Universe

[Former Member]

Hi,

I have an OLAP Universe based on BEx Query, which brings Key Date value as Universe Parameter. Is there a way how to populate the Parameter using a Filter or a Prompt?

I have tried something like this:

<FILTER KEY="[key_date_parameter_value]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME="01.01.2010"/></CONDITION></FILTER>

Any help would be appreciated.

Thanks and regards,

Peter

[Former Member]

Hi,

I think you are trying to create a pompt that will accept the input from the user. Please try this

<FILTER KEY="key_date_parameter_value"><CONDITION OPERATORCONDITION="Equal">

<CONSTANT TECH_NAME="@Prompt('Enter Date','A','Class Name\Date object Name,mono,constrained)"/> </CONDITION></FILTER>

Regards,

Rohit

[Former Member]

Hi,

Why do you need this?

If the BEx query contains a keydate variable then the universe will contian this variable as a universe parameter.

So you will be prompted to select a keydate when using this universe in the WebI query panel.

Regards,

Didier

[Former Member]

Hi,

With Web Intelligence this is not a problem because the key date is prompted correctly but when implementing a Query as a Web Service for Xcelsius, the error message "Prompts are not resolved" appears.

The original Universe parameter/QaaWS problem is described in this thread:

Regards,

Peter

Edited by: Peter Tasala on Apr 15, 2010 2:42 PM