File Library

Where Is My Input Data? How to Find and Convert Input Data into Level 0 Data
Topic: Business Intelligence Files
Owner: Philip Hulsebosch
Date: 2014-11-26
Subtopic: Technical Journal

By Philip Hulsebosch, Trexco and Bodo Abenhardt, Vodafone Germany

If you want to convert an existing Block Storage (BSO) database into Aggregate Storage (ASO), you may find out some of the data in this BSO database has not been loaded at leaf level for all dimensions. You must load data at leaf level in ASO, so you need to have this data. Finding this upper-level entry data in a fully aggregated cube is difficult. This data is aggregated in the dimensions and likely cannot be found manually by drilldown. It will require a technical approach.

This article will present you the method to find upper-level input data in a large BSO database and export it to be loaded at Level 0 in an ASO database. It will describe the steps required and the calculation logic applied to BSO.

Download File View File   Where is my input data.pdf

Become a member of ODTUG to gain access to more than 2,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database