on 12-10-2009 3:33 PM
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>
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
I used the syntax in a predefined universe Filter. Does there exist a ohter place where I can define a Filter with XML code?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.