Category Archives: Universe Design

Migrating BusinessObjects Query as a Web Service

Posted on June 25, 2011 by Ron Keler

BusinessObjects Query as a Web Service started a few years ago as a lab project. It quickly gained traction and with the release of XI 3.x was integrated into the main product tree. This feature offers BusinessObjects metadata (universe) and … Continue reading →

Posted in Universe Design, Web Intelligence, Xcelsius | Tagged QaaWS migration, Query as a Web Service migration | 2 Comments

Why Data Modeling Fall Sideways?

Posted on March 31, 2011 by Ron Keler

One of the most surprising aspects I have come to expect during the years of data integration and warehousing consulting is how little data modeling is actually being practiced in this field. While it is hard to find a database … Continue reading →

Posted in BI At Large, Data Warehousing, Universe Design | Tagged BI SDLC, Data modeling, data warehousing | Comments Off

The dilemma of the expanding and shrinking universe

Posted on March 24, 2011 by Ron Keler

One of the most fundamental questions you will need to answer as you begin designing your meta data strategy can be borrowed from astrophysics. In much the same way that our cosmos adhere to great expending forces that stem from … Continue reading →

Posted in BI At Large, Universe Design | Tagged mega universe, Metadata, mini universe, semantic layer, Universe | Comments Off

Handle semi aggregate measures in universes

Posted on January 25, 2011 by Ron Keler

While relatively simple data marts can be designed as true simple stars, more often than we like, our reporting data models contains snowflakes. Whatever you want to call these entities, they represent one basic problem for your reporting tools: Cartesian products. … Continue reading →

Posted in Universe Design | Tagged BusinessObjects, Context, Data mart, Data warehouse, Dimension, Measure, Semi Aggregate, Snowflake, Star Schema, Universe, Webi | Comments Off