Planned cost(0CCA_C11_RK001) invisible in Cost & Allocation Cube:CO-OM-CCA

[Former Member]

Hi,

I have a problem when i'm trying to do a query on this cube. The column where the planned cost should appear is always empty.

I've checked if the data was uploaded, and it would seem that is was: the load of 0CO_OM_CCA_1 is green. And this data is available and viewable in the ERP.

I don't know what i'm doing wrong. Do you guyshave any idea on why the data is not visible?

Thanks a lot in advance.

Best regards.

[dennis_scoville4 · Accepted solution]

Restricted Key Figure 0CCA_C11_RK001 restricts rows to where the Value Type (0VTYPE) is 20. The first step that I would take is to validate, in tcode LISTCUBE, that the 0CCA_C11 InfoCube has records, for the Fiscal Year/Period you're trying to query against, where the 0VTYPE is 20.

If it's there, then debug the query in RSRT to determine why this data isn't being rendered in the query. If it's not there, then you need to take a look at your code populating the InfoCube, since you've already confirmed that the data was extracted in the 0CO_OM_CCA_1 DataSource.

Edited by: Dennis Scoville on Aug 24, 2009 11:22 AM

[Former Member · Accepted solution]

Thank you very much.

I've used tcode LISTCUBE and checked the data; i saw that it was in the cube.

I wanted to try debbuging, but i must admit that when i saw the code, i decided to redo my query from scratch and it worked.

Thanks a lot for your help!