0COOM_C01 - ASAP

[Former Member]

Hello,

In my project, they already have the 0COOM_C01 costs & allocations infocube. It has 3 separate update rules 0CO_OM_CCA_1, 0CO_OM_OPA_1 & 0CO_OM_WBS_1. When an info package is run for each of these update rules , it loads the corresponding data.

For one my reporting , I need Cost Center, Partner Object, Partner Type, Order Type, WBS element and the the amount restricted by a few cost elements.

I have all the fields needed for my report in the cube. But the data for all these fields are not there in a single record.

1. Is there any way i can use this cube for my report ?

2. Please let me know if i need to create a new update rule / info pkg to get the data in a single record ?

Please advise..this is pretty urgent....

[former_member188975 · Accepted solution]

Hi,

The OLAP engine does a good job when taking care of aggregation in Bex reports. If you have all the InfoObjects in the cube I think you should first try creating a query and looking at the results to see if they match what you have in mind.

Hope this helps...

[Former Member · Accepted solution]

Thanks for the info. I did a query and did not get the values for the Cost center and Orders. It had values only for the WBS elements.

Then I founf that only info pkg for the WBS was run in the recent past. The last time the other 2 info pkgs ran were in 2003. Would this be a problem..

How can i fix it..?

Also Where can i find the source(R3 vaues ) for the info sources used for this cube...

Thanks

[former_member188975 · Accepted solution]

Hi,

I would recommend trying to execute another data load, so that the data is more up-to-date. Check out these links for datasource fields info:

http://help.sap.com/saphelp_nw04/helpdata/en/ae/8876724e671341a91ff3ba711bacd0/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/3c/848fc1effdcc4c9869e7c1a55a8baf/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/28/92a0311a36a640a48820ec3bbf4d90/content.htm

Hope this helps...

[Former Member · Accepted solution]

Thanks a lot..its very helpful. Is there a data soruce which extracts data from COEP table ...

COSP & COSS gives summar level data . we want the line item level data from COEP..

[former_member188975 · Accepted solution]

Hi,

See following link:

http://help.sap.com/saphelp_nw04/helpdata/en/8f/d93c00e39d5b4fb6eaa3bf16e6fb09/content.htm

Hope this helps...

[Former Member · Accepted solution]

Thanks a lot.

Can you please explain with example how a navigation attributes works...

[former_member188975 · Accepted solution]

Hi,

Please look at this post:

Hope this helps...