WhereScape RED MSAS's Tabular Mode functionality is enabled for SQL Server, Oracle and Teradata repositories, available only for Dimension, Fact and EDW3NF objects. To use this RED functionality, users need to ensure they have a Microsoft Analysis Services Server running in Tabular mode available.
The following sections provide an overview of the Tabular functionality in RED, detailing the following:
- Ensuring the installation of a Microsoft Analysis Services Server is running in Tabular mode
- The creation of a new Tabular connection with associated tabular targets
- Setup of an MSAS connection string in the DataWarehouse connection
- Creating Fact, Dimension or EDW3NF tables by Dragging and Dropping, then choosing a Tabular Target Location.
- Querying the results via Excel