I need to generate a sales report - Acutal/ Plan. The actual Version data is coming from Actaul Cube and Plan version from plan cube. We have a multi provider on the top of the actual & plan cubes and build the report on the multiprovider.
What is the requirment for ACUTAL cube when I build it so I can generate a report displaying 'actual data' and plan data? I think that the ACTUAL cube has to contain the same the numbers fo CHARs and KFs as PLANNING cube, right? Currently the Actual and Plan CUBEs don't have the same CHARs and KFs. When I run the report, the actul and plan data are in the seperate line items. Please correct me if I am wrong. Thank you.