EPM Report to pull data from two different cubes having different members
Summary: We have two different cubes, PLAN cube and OEP_FS cube, one handles allocation process by capturing allocation assumption (number) for specific account as shown in screenshot 1, allocation codes by individual Line Items and distribution periods in screenshot 2 and OEP_FS to plan financial numbers that will have budget numbers along with the allocated numbers pushed from allocation cube. Both the cubes have different dimensions partially. We have a requirement that should bring the allocation codes, distribution period along with the sum of allocated numbers and allocation assumption number.
Expectation: The number that we have in the allocation cube should match with the OEP_FS data.
1