WhereSpace RED - dev environment to build DW

WhereScape RED is an Integrated Development Environment for building, enhancing and prototyping data warehouses. It uses a database (DB2, Oracle, SQL Server or Teradata) for processing rather than a proprietary ETL engine.

WhereScape RED and Microsoft Analysis Services

Microsoft Analysis Services are a powerful way to display multidimensional data.  Many WhereScape RED customers use Analysis Services as part of their data warehouse solution, even some that do not have Microsoft SQL Server as their primary database.

With WhereScape RED you can design and build Analysis Services cubes using the same drag and drop interface that built the rest of your data warehouse.  Metadata is stored about them so they bare included in the generated documentation and they can be scheduled and managed through WhereScape RED.

The benefits are simple – no need to learn another tool, end to end metadata from your source system through to the cube layer (and, where supported, the client tool as well), integrated workflow and scheduling for the data warehouse and the cubes, automatically maintained lineage information and documentation from source system extract through to the data warehouse and the cubes.  And best of all the cubes WhereScape RED creates are identical to those you would build manually.