Irina
5 months agoContributor
Stage data
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 n...
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.