How to debug the Webi Report which is developed on BEx or InfoProvider Universe

[Former Member]

Hi Experts,

I am new to WebI report. We are doing BEx to WebI migration.

I created the two new webi report on BEx Universe one and other one on InfoCube Universe.

1. Now I want to know how to debug both records are giving correct no of records? and if any issue come.. how to debug the WebI report.

2. How to find the performance issues in WebI report and What are the diff methods to fix the Perfomance issues.

Please help me its very urgent for me ..

Thanks

Raj

[Former Member]

Hi Raj,

1)you need to run the same mdx query at the BW end directly and need to compare with webi results to make sure that you are getting the correct data and number of records.

2)The performance issues at universe level we can improve by configuring the connection parameters in universes connection(array bind size and array fetch size)

Hope this info will help you.

Thanks,
Pramod.

[Former Member]

Hi Raj,

1)you need to run the same mdx query at the BW end directly and need to compare with webi results to make sure that you are getting the correct data and number of records.

2)The performance issues at universe level we can improve by configuring the connection parameters in universes connection(array bind size and array fetch size)

Hope this info will help you.

Thanks,
Pramod.