Problem with PS GUID in BW. New PS cubes. Attributes of 0project

[Former Member]

Hi,

I am trying to implement BW PS with the new cubes (for example 0PS_C041). In help.sap.com, we can see that the documentation says that with this cubes you only need to insert in the cubes:

0PSGUID, GUID of a PS Object

0PS_OBJ, PS Object Type

and right now is not neccesary to insert infoobjects as 0PROJECT, 0NETWORK, 0ACTIVITY, as they are navigational attributes of 0PSGUID.

My problem is that I need other attributes of 0PROJECT as navigational in my PS new cubes (for example 0PROJECT__0CO_AREA in my 0PS_C041 cube). But how can i insert navigational attributes of 0PROJECT if this field is not in the cube?

As fas as I see, the solution can not be to insert 0PROJECT in my cube, because in this case I can have duplications if someone changes the PSPID in R3. That is the reason why SAP has decided to change old cubes by new ones.

[dennis_scoville4 · Accepted solution]

If you make 0PROJECT a Navigational Attribute in the 0PS_C041, you'll be able to get to the attributes of 0PROJECT in the query, but that's about it. Otherwise, you may want to implement the 0PS_C04 InfoCube.