cancel
Showing results for 
Search instead for 
Did you mean: 

Uni on Bex-Query: filter on Structure - Without Keyfigures as column: error

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

mailed it

good luck with it

Former Member
0 Kudos

how then??

point me to the instruction because i cant see and 'attach here' button or line

Former Member
0 Kudos

Ups. I suggested that you know, how :). Can you send doc via e-mail?

Former Member
0 Kudos

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??

Former Member
0 Kudos

Thanks for reply.

Yes. You can attach doc.

Former Member
0 Kudos

see my second comment.

simple if you know it

Former Member
0 Kudos

Hello, I.Heijnen.

Can you explain in details, what does it mean "Create a caption dimension for your keyfigures"?

It would be better if you'll show screenshots.

Former Member
0 Kudos

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>