I need to create the report with COPA cube and BCS cube and do some analysis.
The keyfigures are different.
COPA uses keyfigures to report all account data. Whereas BCS uses the Item which are characters.
Copa cube used fiscalyear/period.Which is not the same with BCS cube which uses fiscal year , period individually.
Will the multiprovider will work in such a case? I need to compare the data from COPA cube and BCS cube and find out the difference between them.