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,
Witalij Rudnicki replied
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.