on 09-13-2011 12:12 PM
Hi.
We have a serious problem, after we applied BW support packages (7.0110) all our infoobjects that are created as text only, no master data, are only displaying the text. The objects key is empty. Do anybody have a solution for this?
Koos.
Hi.
We have found a work around for the problerm for know and here it is:
5.1.3 Optimizing detail object syntaxFor queries on BI universes that include only the key and medium name detail objects of adimension, it is possible to modify the generated syntax of the objects to improve queryperformance, due to some internal details of the OLAP BAPI interface.To modify the syntax:
1.Open the universe in Designer.
2.Double click the key detail object you want to modify.
3.In the Select text box on the "Definition" tab of the "Edit Properties" dialog box, changethe syntax to refer to the NAME attribute of the SAP characteristic.For example, for the objectL01 Customer Key , change the generated select syntax:[Z_CUSTOM].[LEVEL01].[[2Z_CUSTOM]].[Value] to refer to the NAME attribute:[Z_CUSTOM].[LEVEL01].[NAME]4.ClickOKto save the changes.5.Follow the same steps for the name object. Change the syntax to refer to theDESCRIPTION attribute of the SAP characteristic.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
H have generated a trace and tested the MDX query in MDXTEST, there I do get the key values but not in the WebI report with the same MDX query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.