on 01-09-2006 11:31 AM
We have data sources 0co_om_cca_9 and 0co_om_cca_1 for infocube 0cca_c11. Plan is in 0co_om_cca_1 and actual is in 0co_om_cca_9 with delta. Plan (0co_om_cca_1 )has no delta and I loaded with full update and have 2484 records. Actual (0co_om_cca_9) have 6867 records.
If we attach both datasource( 0co_om_cca_1 directly and 0co_om_cca_9 through ODS) to infocube.
Can anybody tell me difference between them ..and it is necessary to have 0co_om_cca1 in infocube.
thankx in adv...
rgds,
San!
Hi All,
I am new to the SAP environment and need some help.
I need to add some Key Figures from 0CO_OM_CCA_1 to an InfoCube, however I am unable to find it in my DataSource.
Can anybody help?
thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Welcome to SDN
Well 0co_om_cca_9 is the line item level datasource for actual postings in CCA, hence it would contain more information as compared to the actual posting records fetched through 0co_om_cca_1. Hence the no. of records being more for the line item level datasource. You would need to get data through 0co_om_cca_1 as Plan data can be extracted through this datasource, for plan actual comparison reports.
From a design perspective would suggest taking the plan data from 0co_om_cca_1 (filter based on the characteristic Value type) through an ODS to an Infocube.
This ODS would help in passing only the changed records to the Infocube.
At the same time get Actual line items data through another ODS into the Infocube. This ODS would help in case you need to refer to detail actual line item data for analysis purpose.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is my business need!
i have one infocube(*_11)
in this infocube data is coming from datasource 0co_om_cca_1 and *9.
I have created ods for *9 and not for _1.
Now i am loading data in infocube
which is showing Number of entries:3277
but i have 2484 n 6878 number of entries in *1 and *9.
the problem is this dat Infocube is showing less number of entries
i checked out from : *9 :783
*1 :2484.
i even checked out whether data is compressing! but it is not compressed also.
So, can any body tell me wat to do.
Thankx in adv.
rgds,
San!
I think You will find, that a better design is to have plan data in one cube and actual data in another. Combining different level granularity data in the same psysical cube is, in my opinion, inoptimal and not very transparent. I would keep seperate flows and combine data dynamically in a multiprovider. Actually, I think SAP has this scenario as an example of best practice use of multiproviders.
Hi,
0CO_OM_CCA_9 contains actual data on a document level. *_1 contains particularly actual and plan data aggregated on a fiscal period basis.
The main problem with your requirement is a different time chars set: calendar for *9 and fiscal for *1.
BTW, as I wrote *1 may contain both actual and plan data.
If you, anyway, want to use both datasources, you need to calculate either calendar or fiscal time chars in transfer/update rules based on fiscal or calendar incoming chars, i.e. translate one of the time chars set into another one (that you choose for reporting purposes).
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.