Cost Center Accounting Dataflow for Actuals and Commitments

[Former Member]

Hello experts,

I have a requirement in which I need to model the CCA dataflow in BI.

I m using 0CO_OM_CCA_9 and 0CCA_OM_CCA_10 datasources for this. As far as what I could find out the data flow for 0CO_OM_CCA_9 is as follows,

0CO_OM_CCA_9 --> 0CCA_O09 --> 0CCA_C11

0CO_OM_CCA_10 --> 0CCA_O10

I was not able to find to which cube I should move the data from 0CCA_O10.

Should I create a custom cube for this?

Can anyone help me on this.

Thanks!

[Former Member]

Hi

There is no need to restrict the data as Actual and Commitment in the modeling side.

In the Reporting side (Bex Query Designer) we need to differentiate by restricting the Actual=10 and commitment =40.

Thanks,

Purushotham.

[Former Member]

Hi Neetha,

You can use same infoucbe for both the Datasources.

Thanks,

Kamal

[former_member186399]

Dear Neetha

You can move the 0CCA_O10 data to either 0CCA_C11 or you can even have a custom cube.

As the data differs only on Value type (Actual =10 & Commitment = 40 ) you can load it to 0CCA_C11.

Regards

Gajesh