Home > Resources > Product Walk through
Previous Next
Click here to view full screenshot

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.

Ask us a question
Copyright ©  WHERESCAPE Inc. 2007
Terms Of Use Sitemap
US: 770-579-3606 | Asia/Pacific: +64-9-358-5678 | UK: +44-8700 138-080 |  Ireland: +353-86-825-8157

FAQ ANSWERS - Can I create metadata structures accessible by any client tool?

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.

FAQ ANSWERS - Can I create cubes for MDDBMS and ROLAP environments automatically?

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.

FAQ ANSWERS - Can I export WhereScape RED-managed data sets to SAP BW?

Yes.

FAQ ANSWERS - Can I use WhereScape RED to manage a set of distributed data marts?

Yes. WhereScape RED can produce an arbitrarily large set of distributed data marts automatically.

FAQ ANSWERS - Can I go back and revise first tier tables after I've started building second-tier tables?

Yes.

?ASK US A QUESTION

Ask us any question about WhereScape RED and we will get back to you within 24 hours.