BIA Accelerator and Multi cube Queries

[Former Member]

Hi guys,

Can we apply BIA indexing for Multi cube queries?..

I think multi cube is no way realted with BIA indexes, as no data is stored in them.

but i would like the expert opinion that whether BIA indexes improve the performance of the queries built on Multicubes and by indexing the cubes used in that multi cubes.

Thanks in advance.

Loki.

[Former Member · Accepted solution]

Build the indexes on the basic cube that is part of the multicube andte BIA will read.

Ravi Thothadri

[Former Member · Accepted solution]

Hi ,

I know query performace is incresed by BIA , but how come the load performace is increased using BIA , i guess to eliminate aggregates roll up, is there anything i am missing here, can someone clarify.

Thanks

Vj

[Former Member · Accepted solution]

In BIA you "aggregate" the whole InfoCube, where is with a classic aggregate you aggregate to a specific subset of data. The load performance is increased due to the technology used by mutiple blade servers and TREX coding. If you are loading mutiple aggregates for InfoCubes, BIA is therefore faster overall since your basically building aggregates against all subsets of data. (which is really the beauty of BIA) The real advantage is you also have many more CPU/Memory dedicated to saving this data to the BIA NFS. Utlimately this really helps the maintenance as opposed to aggregates since you don't have to roll-up several (and some cases hundreds or thousands) or aggregates per InfoCube.

Hope that helps.

[Former Member · Accepted solution]

Hi Mike,

Can you more specific about "<b>BIA you "aggregate" the whole InfoCube</b>",

My question is that can't we apply BIA indexing only to certain requets as we do for aggregates?If so can you mention the steps as well.

also can we maintain both Aggregates & BIA indexes for a cube simultaneously?

Thank you in advance.

Regds/Loki.

[Former Member · Accepted solution]

Hi Loki,

You cannot do selective requests aggregattion with BIA, it has to be full data in the infocube, you can still use aggregates with BIA but the query will first access Cache , then BIA and then it goes to Aggregates. so if you have BIA on the Cube then its of no use to maintain Aggregates.

Please correct me if i am wrong.

Thanks

Vj

[Former Member · Accepted solution]

Ok, so when you create an aggregate you are basically selecting a fraction of an InfoCube based on a certain set of variables (this is the importat part) and that aggregate is more or less a smaller InfoCube and a subset of that original InfoCube.

In BIA, in a way, we aggregate every variable possibility.

You can continue to maintain aggregates (roll-ups) in case BIA fails for some odd reason but if BIA is connected it will use them first.