SAP Knowledge Base Article - Preview

1393975 - How do I concatenate characteristic values into a new Object in the Universe Designer XI3.1

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

SAP BusinessObjects Enterprise XI 3.1

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.