BIA to improve performance for BPS Applications

[former_member203538]

Hi All,

Is it possible to improve performance of BPS applications using BIA. Currently we are running applications on BI-BPS which because of huge range of period are having a performance issue.

Would request to please share whether in this read and write option of BPS would BIA be helpful and to what extent can the performance be increased?

Request an early reply as system is in really bad shape and users are grappling with poor performance?

Rgds,

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

If the performance issue you are facing is while running the query on real-time (transactional) infocube being used in BPS, then BIA can help. The closed requests from real-time cube can be indexed in BIA. At the query runtime, analytic engine reads data from database for open request and from BIA for closed and indexed requests. It combines this data with the plan buffer cache and produce the result.

Hence if you are facing issue with query response time, BIA will defenitely help.

Regards,

Praveen

[former_member203538 · Accepted solution]

Thanks Praveen for your Reply.

My basic requirement is how BIA will speed up the analysis when the data is being written in the cube.

What you have described is data read process whereby BIA based on Confirmed request and also for requests in Progress will fetch the same and show correct results. I am aware of this process.

What happens when you have input the data into the application and want to see the results on a shorter time scale?

Additionally we are using IP and not BPS. I am sorry for this correction. Old timers tend to forego their habits hard

Rgds,

[Vitaliy-R · Accepted solution]

Hi Rajeev,

I am sorry to disappoint you, but BIA will not help with writing to the real-time InfoCubes, because this happens only on app./DB servers side without any participation of BIA.

Good idea though to look at strength of BIA architecture and to think how other BI functions could benefit from it.

Regards,

-Vitaliy