BIA

[Former Member]

Hi All,

I have a doubt in BIA.

Once the hardware is installed and indices is generated for the dimentions of the infocubes in BIA, how the daily/weekly/monthly transcation data gets updated in BIA.

1) Does the query reads the data from BIA bypassing the BW server ??

2) If yes how the scheduled data gets updated in BIA system. Do we have to create a job to read the data from BW to BIA.

3) I know BIA does not support DSO. What about multiprovider ?? Does it use the same idex as the base infocube of the multiproviders.

Kindly throw some light on this.

Point will be awarded for sure.

Bill

[Vitaliy-R]

Hi. It seems more like questions, then doubts

To answer them:

1) Queries do not by-pass BW server, but they by-pass InfoCube data base tables. OLAP engine on BI server direct data selection to BIA i/o SQL to DB.

2) The job that moves delta loads from BI into BIA are your roll-up processes, that you might use already today with aggregates. Frequency - prefferebly after every IC load.

3) MultiProvider is just a JOIN of data from underlying part providers (InfoProviders like InfoCubes, DSOs, InfoObjects). If part provider is InfoCube indexed in BIA, then for this part provider data will be read from BIA.

Hope this answers your questions.

Regards,

-Vitaliy

[Vitaliy-R]

Sorry, clear mistake from my side. Point 3: MultiProvider does UNION, not JOIN, as I mentioned.

Mea culpa.

-Vitaliy