BIA residual Benefits to Master Data and Flexible MD ?

[Former Member]

Dear BIA Colleagues:

I understand that BIA can only be built on top of InfoProviders at this time but that those BIA indexes include master data. Question about benefits of BIA for Master data:

1/ Flexible MD in a MultiProvider

We have a Multiprovider with 6 base cubes plus one flexible master data object (0COORDER) .

Is there a method to set up BIA indexes on that large master data table for performance optimization of the multiprovider (beyond having the COORDER Master data index within each cube's index)?

2/ BIA and flexible master data queries e.g. 0COORDERWill queries on a flexible master data object be faster with BIA compared to before BIA (if that master data is part of a BIA indexed Cube) e.g. is there a residual advantage of BIA on master data e.g. navigtional attributes?

3/ BIA benefit to master data in non BIA indexed cubes

Say we have two cubes A and B who share common master data and only cube A has a BIA index, will queries on Cube B see a BIA benefit for master data objects that are included within the BIA index of Cube A?

Thank you for shedding some light on this one,

Catherine

[Vitaliy-R · Accepted solution]

Hi Catherine

Re 1: InfoObject-as-InfoProvider will still be read from the database. I remember Mark Bernard from SAP RIG mentioned once that it will be optimized in the future, but not in existing release.

Re 2: Same as 1.

Re 3: Cube B will not benefit from BIA-indexed MD, because it is single statement that joins transactional and master data.

Regards,

-Vitaliy