Hi all,
We have Excel file that we upload into Cube (some tabs from this Excel file). This file also contains additional tabs that we want to upload into stage only and create cube views based on numbers on these additional tabs.
Could you please advise where I can find instructions how to create, upload, perform mappings (if necessary), aggregate stage data and create cube views based on stage data.
If you want data just in stage you create maps that set the target to (Bypass).
If you want to aggregate stage data there are a number of options. Have a look at derivative transformation rules.
Cube Views are for Cube data not stage. Without a bit more information on what you are trying to do it is difficult to give a precise answer. We have dashboards that display a Cube View at the top and a SQL Table Editor component at the bottom which displays supporting Stage data. The key is that the current cell selected on the Cube View drives the SQL query for the Stage data. Search for 'Navigation Links' to get more info on how to do that.
Dear Marcus, thank you! Indeed cube view means that data is taken from the cube. Stage data is not loaded into the cube.
