Dynamic Cubes from Multiple Cubes
Is it possible to build a dynamic cube from multiple cubes? For instance, could I build a dynamic cube that had income statement level data from our month end close cube and summarized headcount data from People Planning? To my mind this is where the power of Dynamic Cubes would really shine.
If you create a Workspace Dynamic Data Service file, it provides commented out code of writing a number of records to a Dynamic Cube Data Unit. The Tech Ref guide walks through all the details of Dynamic Dimensions and Dynamic Cubes. You can source the data that you want to put into your Dynamic Cube from anywhere. As an example, I'm ingesting transactional logs into a Dynamic Cube. In your case, if you want to be combining data from multiple cubes or other sources, you will need to write your own code to figure out how to combine the data as you desire, then write the combined data to each Dynamic Cube Data Unit.
You attach your Dynamic Data Service file to the Workspace's Service Factory, and then attach that to your Dynamic Cube.
