PCA dilemma: multi cube?
I have 2 cubes: 0PCA_C01 (updated with extractor 0EC_PCA_1) & 0PCA_C03 (updated with extractor 0EC_PCA_3). In the first one I get both plan and actual PCA records (summaries) and in the latter I get only the actuals (line items).
I need to be able to report on 0MATL_GROUP (attribute on 0MATERIAL) wheras I need to see all postings, both actuals and plan, on 0MATERIAL. Unfortunately, in 0PCA_C01, I only have "representative material" (which in R/3 is only used for plan postings), so I don't get all the info I need this way. I have to combine it with the info in 0PCA_C03, because in this one there are the real postings per material.
So I have one cube with plan values on representative material (0REP_MATL) and one cube including the actual values per material (0MATERIAL).
I need to be able to report on 0MATERIAL__0MATL_GROUP so I need to get the values from both cubes into 0MATERIAL. Do you agree?
Could I use a multi provider to solve this?
Thanks in advance!