Tip

SAP BW Planning Applications and the 3 C’s

To get a better understanding of what is going on in the business processes, the transaction systems, you need the appropriate data combined within a data warehouse. The amount of business intelligence you get from the reporting system is limited by well the DataSets are integrated. This needs to be viewed along the line of…   [read more…]

Cube (Inactive)

Data Staging Cubes Are a Bad Idea

A cube is designed for optimised reading of data, not writing. It is the right tool for the job of reporting. Data staging cube is the name given to a cube that is being used for a purpose other than what is optimally designed to do; where it is the wrong tool for the job….   [read more…]

Cube

A Datastore versus a Staging Cube

One of the data modeling constraints of a DataStore is the limitation of ‘How many characteristics you can put in the key field list?’. It is a design strategy that has been enforced from the database layer up to the application layer. The BW application is intentionally keeping the direct correlation between the object model…   [read more…]