cancel
Showing results for 
Search instead for 
Did you mean: 

MDX Prompt syntax with <= for a SAP BW based universe

Former Member
0 Kudos

Hi all,

I have to modify a the following prompt syntax. I want to replace "Equal" with an expression vor "<=". I couldn't finde the right expression. Does someone has a glue how to do this?

Regards

Matthias


<FILTER KEY="[0CALMONTH].[LEVEL01].[NAME]">
<CONDITION OPERATORCONDITION="Equal">
<CONSTANT CAPTION="@Prompt('Monatssequenz: Bitte Auswahl treffen','A','D01 Zeit\Monatssequenz',mono,constrained)"/>
</CONDITION>
</FILTER>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

thanx for the advises.

The syntax does not work.

In the Universe I get an error message that the OPERATORCONDITION ist not correct.

In WebI I get the following Error Massage

Query 1 - DebiTEX Monat

A database error occured. The database error text is: Die angegebene XML ist ungültig. OPERATORCONDITION. (WIS 10901).

I'm working with the following dokumentations

xi-1_sap_olap_universes_en

OLAP universes best practices 2009.pdf

Are ther any other helpful documentations?

I'm going to ask our administrator to activate the webi trace

All the best,

Matthias

Former Member
0 Kudos

Hi,

Can you provide the filter syntax you wrote?

Didier

Former Member
0 Kudos

I trieded


<FILTER KEY="[0CALMONTH].[LEVEL01].[NAME]">
<CONDITION OPERATORCONDITION="Less than or Equal to">
<CONSTANT CAPTION="@Prompt('Monatssequenz: Bitte Auswahl treffen','A','D01 Zeit\Monatssequenz',mono,constrained)"/>
</CONDITION>
</FILTER>

and


<FILTER KEY="[0CALMONTH].[LEVEL01].[NAME]">
<CONDITION OPERATORCONDITION="Less than or equal to">
<CONSTANT CAPTION="@Prompt('Monatssequenz: Bitte Auswahl treffen','A','D01 Zeit\Monatssequenz',mono,constrained)"/>
</CONDITION>
</FILTER>

Former Member
0 Kudos

Hi,

Your filter isyntax is incorrect: I listed on the thread the supported oprators and you didn't used a correct one!!

Didier

Former Member
0 Kudos

now it's working. I used the syntax postet in one of the threads.

Thanx a lot

Matthias

Former Member
0 Kudos

To be fair, he used the syntax as provided by the XI 3.1 Universe designer help guide "To create pre-defined conditions in an OLAP universe".

So maybe you could be a little more sparing with your exclamation marks and perhaps work to get the documentation fixed. (!!)

Former Member
0 Kudos

Hi,

Thanks Katharine for the information.

I am not in charge of the documentation. I am the Solution Manager and try to do my best to help people working with universes on OLAP sources.

I will inform documentation guys about this issue.

Didier

Answers (3)

Answers (3)

Former Member
0 Kudos

I used the syntax in a predefined universe Filter. Does there exist a ohter place where I can define a Filter with XML code?

Former Member
0 Kudos

Hi,

According to designer help guide. You can use the following:


<FILTER KEY="[0CALMONTH].[LEVEL01].[NAME]">
<CONDITION OPERATORCONDITION="Less than or Equal to">
<CONSTANT CAPTION="@Prompt('Monatssequenz: Bitte Auswahl treffen','A','D01 Zeit\Monatssequenz',mono,constrained)"/>
</CONDITION>
</FILTER>

But I guess there should not be any space in between the operator text as in "InList" operator.

Edited by: rohit12 on Dec 11, 2009 6:51 AM

Edited by: rohit12 on Dec 11, 2009 6:55 AM

Former Member
0 Kudos

Hi,

Here are the list of supported operators:

<li>Equal

<li>NotEqual

<li>Greater

<li>GreaterOrEqual

<li>Less

<li>LessOrEqual

<li>Between

<li>NotBetween

<li>InList

<li>NotInList

<li>Like

<li>NotLike

I recommend to read the following document that gives you a lot of MDX and filters samples an recommendations

Moreover I also recommend to activate WebI traces to see how filters are generated when you define filters in the query panel.

Regards,

Didier

Former Member
0 Kudos

Hi,

You can use the following:


<FILTER KEY="[0CALMONTH].[LEVEL01].[NAME]">
<CONDITION OPERATORCONDITION="Less than or equal to">
<CONSTANT CAPTION="@Prompt('Monatssequenz: Bitte Auswahl treffen','A','D01 Zeit\Monatssequenz',mono,constrained)"/>
</CONDITION>
</FILTER>