Skip to Content
0
Jul 02, 2008 at 08:30 PM

BIA Dummy Cube to load master data

49 Views

Hi everyone,

We've initiated a project to implement BIA and the racks will arrive in the next few weeks. Something I've heard discussed, but not found documented, is that some companies built a "dummy cube" consisting of all the master data involved in the cubes to be loaded to BIA. Apparently, this is to avoid the potential for locking the master data indexes as multiple cubes are indexed in parallel. Having the master data indexed in advance of indexing several cubes in parallel is apparently much faster, too.

See "Competing Processes During Indexing"

[Activating and Filling SAP NetWeaver BI Accelerator Indexes|http://help.sap.com/saphelp_nw2004s/helpdata/en/43/5391420f87a970e10000000a155106/content.htm]

My questions are: Is this master data "dummy cube" approach documented somewhere? Is this only for the initial build, or is this used for ongoing index rebuilds such that new master data objects are consistently added to the dummy cube? Is this the right approach to avoid master data index locking job delays/restarts, or is there a better/standard approach to index all master data prior to indexing the cubes?

Thanks for any insight!

Doug Maltby