Data Cubes
This applies to: Managed Dashboards, Managed Reports
A data cube is a reusable multidimensional model of your data that consists of measures, hierarchies, and metadata such as formatting. Data cubes work primarily with non-OLAP sources such as relational databases, letting you view your data as a cube without having to use an OLAP system like analysis services. Use the information pulled together in these data cubes to build our your dashboards and reports.
-
Use data cubes to integrate data from different sources, transform the data, and produce a reusable data model with optional data storage capabilities.
-
Set up an ETL process when editing a data cube by choosing from our wide range of transforms and connecting them together to perform tasks such as data cleansing and combining data.
-
The MDX Select transform lets you use an OLAP data source as input for selecting a tabular set of data to join with other data.
-
Performance can be improved by using the optional storage types: warehouse to store the cube's output in Symphony, or in-memory for faster analytics.
-
There is always a cube behind a visualization and its metric set, so a data cube may be auto-generated by Symphonyif you drag data directly from a data source so that you can start to work with it immediately.
-
Once you create a new data cube, you can set up an ETL process consisting of transforms, use transforms to join database tables, and link the output columns of a data cube to existing hierarchies.
You need to be a user with a Developer seat to create or edit a data cube.
Use the data cube work area to create your data cube structures visually. Add structures, create joins, and define your ETL process.
For more information about Data Cubes and data cube options, see: