CREATE SECOND TIER TABLES
Produce aggregates, linked dimensions, snowflakes, roll-ups, cubes and export sets after the base data warehouse schema is finalized and agreed.
WhereScape RED manages the complex process of producing second-tier data warehouse tables rollups and aggregates, views, join indexes, analysis services cubes, client tool metadata tables and export data sets for SAPs BW and other target data marts as an integral part of the WhereScape RED Data Warehouse Life Cycle (DWLC) management process.
Yes, WhereScape RED metadata structures are stored in the RED Repository™ as database columns and are accessible to client tools. WhereScape RED incorporates additional support for MicroStrategy products.
WhereScape RED creates cubes for Microsoft Analysis Services automatically, and can create the export set (load files) for an MDDBMS or ROLAP environment for which the load requirements are documented by the vendor.