on 04-06-2012 12:19 PM
Hi,
I have an universe based on a BEx query. I want to add a rank measure.
My measure expression is:
{<EXPRESSION>Rank([0MATERIAL].[LEVEL01], Order([0MATERIAL].[LEVEL01], [Measures].[744AADNOFADBE3JP736AHGJU3]), BDESC))</EXPRESSION>}
First a warning comes up as:
The XML for this expression is correct, however the MDX expression is not parsed in this process. (UNV 00050).
When I use it in Web Intelligence, the error is:
Database error: The supplied XML is not valid. {<EXPRESSION>Rank([0MATERIAL].[LEVEL01], Order([0MATERIAL].[LEVEL01], [Measures].[744AADNOFADBE3JP736AHGJU3]), BDESC))</EXPRESSION>}. (IES 10901) (WIS 10901)
Any suggestions?
Hi,
there's a good guide here: http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c820620...
.. and has a couple of samples for Rank on measure / Rank members
Regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.