Skip to Content

Cannot use rank in Web Intelligence query

Jan 20, 2017 at 09:39 AM


avatar image
Former Member

Hello all.

I have got some reports over a BO universe over a relational database. My actual connection name and views owner name (in .dfx) is OWNER but in any previous moment it was OWNER_2.

When I try to build a query with a rank in Web Intelligence and only if I use a dimension in the field "Ranked by" the SQL builder makes a concatenation of the column view with the incorrect owner like OWNER_2.DIMENSION so the query cannot run due to an error.

I can't find in which part ot the .dfx or .blx is written OWNER_2 to build the query this way. Is there a way to find and change this old hardcoded owner?

Thanks in advance,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers