Symptom
Need to create a custom dimensions(object) by concatenating the key and the description attribute of dimensions generated from BW.
Definition used at Universe level: <EXPRESSION>@Select(Vendor\L01 Vendor Country Key)||@Select (Vendor\L01 Vendor Country Name)</EXPRESSION>.
Error at Webi level is:
A database error occured. The database error text is: The MDX query WITH MEMBER
[Measures].[356CE123-FD23-45EF-A1,22,BE,CE,C6,1B,A4,6B]
AS'
[0VENDOR].[LEVEL01].[[20COUNTRY]].[VALUE]][[0VENDOR].[LEVEL01].[[10COUNTRY]].[VALUE]' SELECT {[Measures].[356CE123-FD23-45EF-A1,22,BE,CE,C6,1B,A4,6B]} ON COLUMNS FROM [$0PUR_C01] failed to excute with the error invalid MDX command with [20COUNTRY].(WS10901)
Read more...
Environment
-
Business Objects Enterprise 3.1 SP2
-
SAP Integration kit SP2
-
SAP BW 7.x
Product
Keywords
KBA , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.