cancel
Showing results for 
Search instead for 
Did you mean: 

How to debug a report in webi

Former Member
0 Kudos

Hi Every One,

1) How to debug (debuging steps )in a report in boxir2 webi based report.can any body help me out .

2)How we do the performance and tuning in the report level.

3)Aggregate awareness is possible to apply in report level or in universe level.If possible where we can find that option in webi..

Please help me out

Thanks in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

1. Depends on what you would like to debug - Always remember that Data issues - look into generated SQL and compare with report output ..the values would be the same or at higher level based on output context.

2. There is not much to do in terms of improving performance in rendering a report. You should ideally concentrate on universe and underlying db performance for query retrieval.

3. Aggregate awareness is applied at the Universe level. Please refer to the universe designer guide for more details.

Regards

Former Member
0 Kudos

I AM POSTING ABT DEBUG MY REPORT Having data empno deptname tans_amt trans_date are in the report generating les number of rows when i check the same query run on sql cmmd give more number of records

In this situation how can i debug

Former Member
0 Kudos

you may have enabled the Option Distinct in Universe parameters.

1. Universe Parameters > Parameter Tab > DISTINCT_VALUES = DISTINCT

2. Webi Report Query Properties check the retrieve duplicate values option.