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.
The ODTUG Board of Directors is responsible for guiding the organization. With thoughtful leadership and strong community connections, the board ensures that ODTUG provides a meaningful member experie...
Congratulations to the 2021 ODTUG Officers Congratulations to the newly elected officers of the ODTUG Board of Directors! One of the things that sets ODTUG apart is the dedication of our volunteers a...
2601 Iron Gate Drive, Suite 101
Wilmington, NC 28412