Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BIA residual Benefits to Master Data and Flexible MD ?

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

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question