Doubt in 0CCA_C11 with 0QUANTITY

[Former Member]

Hi,

working with BI 7.0.

I am Using 0CCA_C11 Costs and Allocations cube.

data sources are

0CO_OM_CCA_1 and 0CO_OM_CCA_9.

after scheduling , I am getting all Data <b>Except 0QUANTITY Field Records</b>.

only 0QUANTITY Data is not comming All other Data is comming correct.

I checked in RSA3 for Consumption Quantity Field ie SMEG

For the Data souce 0CO_OM_CCA_9, Records are available.

but for the Data source 0CO_OM_CCA_1 No Records are available.

<b>Following is the Quantity Rule in Transformation</b>

For the Data sources 0CO_OM_CCA_1 & 0CO_OM_CCA_9

Target Info Object is 0QUANTITY

Target Unit 0UNIT

Source Unit MEINH

Source Fields of Rule

MEINH --- Unit of Measure

SMEG -

---

Consumption Qty

Target Fields of Rule

OQUANTITY --- Quantiry

0UNIT --- Unit of Measure

Please Help me to find the solution.

Thanks

prasanna

[Former Member]

Are you aware of the fact that:

0CO_OM_CCA_9 is Actual Costs - Line Items (Delta)

and

0CO_OM_CCA_1 Cost Centers: Costs and Allocations (all costs actual, plan, and commitments)?

So if your setup is correct (to avoid duplicate data) you should be loading plan only with 0co_om_cca_1 and maybe no planning occurs for quantities, actuals should come from 0co_om_cca_9 in delta and commitments should come up in delta from their own datasource 0CO_OM_CCA_10, this should also lead to faster data loads

[Former Member]

Hi Pabloj Thank you for the Responce, can you please go for in detail.

I notice another point here,

<b>in R/3 Consuption Quantity Field is SMEG QUAN length is 15</b>,

<b>But in BI 0QUANTITY field is QUAN length 9</b>

I am mapping 0QUANTITY to Consuption Quantity SMEG Field,

may be that's why the Data is not comming.(for the difference of the length)

<b>But how to create QUANTITY Field with length 15,</b>

<b>If I try to create a Quantity Field in BI then It takes default length 9.</b>

Can you please help me to solve this Problem.

Thanks

Prasanna