on 03-31-2011 3:48 PM
Hi All,
I have a 'Without Key Figure structure' as a column called Version in which (amoung others) the values 'Actual' and 'Last Year' .
Thus
Version
- Actual
- Last Year
Now i want to create a filter in my universe which pre-selects Actual.
When I use the tool for that this is my standard definition of the filter:
<FILTER KEY="@Select(Version\Version)">
<CONDITION OPERATORCONDITION="Equal">
<CONSTANT VALUE="Actual"/>
</CONDITION>
</FILTER>
However it results in error: 'A database error occured. The database error text is: (CS) "Error on BindCol". (WIS 10901)'
Meaning(i guess) that somehow i'm not getting the correct selection-command to the database,
When i use the version-dimension itself in the reports as part of the query filter it works fine and LOV displays both versions for selection.
We are using XI3.1 fp3.1; BW 701-sp5 on oracle 11
I've look through the forum, but couldnt find an answer.
If there is point me into that direction and i'll close this one
Any other information on how filters etc should be specified in an Universe on a BW query is also greatly appreciated.
I already have found some info but any information is welcome.
Your help is greatly appreciated.
mailed it
good luck with it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
how then??
point me to the instruction because i cant see and 'attach here' button or line
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sergey,
I dont know the complete technics why this works but if you look at the filter-formula itself it has <CONSTANT CAPTION=...> as condition.
But on the first creation of a universe a caption wasnt standard created as a detail, so i added and used that.
[xxxx].[CAPTION]
Can I attach a doc??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
see my second comment.
simple if you know it
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found my answer.
Create a caption dimension for your keyfigures and filter on thath
Dimension:
[xxkeycharacteristicxx].[caption]
Filter:
<FILTER KEY="@Select(Key Figures\Key Figures Caption For predefined filters)"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION="VERSIONS like Actual"></CONSTANT></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 |
---|---|
83 | |
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.