Skip to Content
0
Former Member
Feb 03, 2011 at 01:11 AM

Invalid mdx question

29 Views

Hi experts,

I've built a dashboard that uses QAAWS against a BEx query. The user selects a parameter from a dropdown list and this is passed to the query. The dropdown is populated via another BEx query. Certain selections cause the error below but others work fine..

A database error occured. The database error text is: The MDX query SELECT { [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1N6LMLMAQHVEHK2ZSLZC3A], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1N6LMLMC9V42075V0QU4MU], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1N6LMLMDT8CPIU8Q8VOX6E], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1RGK09V98NHYRCDSG9Z852], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1RGK09VAS0QM9ZGNOEU0OM], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1RGK09VCBDZ9SMJIWJOT86], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1RGK09VD32LLJY2YIM47HY], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1RGK09VDUR7XB9ME4OJLRQ], [D9E1N6LMLM9YT92Q8JK6JJXTI].[D9E1RGK09VEMFU92L5TQQZ01I] } ON COLUMNS , NON EMPTY { [D9EXRDLJHLX0KVD68TZRK6KFQ].[D9EXVHBZ2PH1IWV1APPDCBNQU], [D9EXRDLJHLX0KVD68TZRK6KFQ].[D9EXUY6POKB6YZZPNWJYWP4VQ], [D9EXRDLJHLX0KVD68TZRK6KFQ].[D9EXUY6POK8VX50FPA94PEY2E], [D9EXRDLJHLX0KVD68TZRK6KFQ].[D9EXUY6POK7CJWCX27DWKK5IU], [D9EXRDLJHLX0KVD68TZRK6KFQ].[D9EXUY6POK6KVA15QNYAI4R92] } DIMENSION PROPERTIES MEMBER_CAPTION ON ROWS FROM [Z_M25/Z_M25_Q023] SAP VARIABLES [!V000002] INCLUDING 58DFDF3E4D542B47B8128DD98EFB7B6C failed to execute with the error Invalid MDX command with DFDF3E4D542B47B8128DD98EFB7B6C.

Does this mean that the value of the prompt "DFDF3E4D542B47B8128DD98EFB7B6C" is invalid? If I run the query in Analyzer and paste this value in the query executes successfully.....

Thanks