BIA performance on cubes with Navigational Attributes for reporting

[Former Member]

HI,

Does anyone know if BIA improves performance on Reports using Navigational Attributes?

THanks.

[Former Member · Accepted solution]

Clyde, how are you sir? I was curious on this too - so I took a look into it. Seems that the as long as the attributes are marked navigational they come along into the BIA indexes. See excerpt and link below.

[http://help.sap.com/saphelp_nw70ehp1/helpdata/en/43/bcf9bfdd052ec5e10000000a11466f/content.htm|http://help.sap.com/saphelp_nw70ehp1/helpdata/en/43/bcf9bfdd052ec5e10000000a11466f/content.htm]

Step 1: Creating a BI accelerator index

When you execute this step, the system creates the indexes for the tables of the InfoCube star schema on the BI accelerator server, as long as they have not already been created by other BI accelerator indexes. These tables consist of the fact and dimension tables of the InfoCube as well as the master data tables that contain the required SIDs, the S, X, and Y tables of the InfoObjects

X = time independent navigational attributes and Y = time dependent navigational attributes, so it looks like these are stored too.

Hope this helps!

Justin

[Former Member · Accepted solution]

You are correct. It works perfectly with Nav Attr. It is no longer a reporting performance issue with BIA.

Thank you.

[Vitaliy-R]

Yes, it does. And that's why it is so good as aggregates replacement. Actually BWA is indexing only those master data attributes from X- and Y- tables, that are used by BWA-indexed InfoCubes.

Regards,

-Vitaliy

[Former Member]

BIA is an awesome appliance. Solves Nav Attr performance issue for reporting.

Thank you.