WEBi on top of BEx. How to force BEx-side Data Aggregation?

[mcubilloso]

Hi,

we have several WEBi reports on top of BEx Queries.

This reports has data tables to show data using only a few characteristic (aggregation), and leaving all others as available objects, for users to build their own reports and ad-hoc analysis.

We checked the Data Set in the Data section on WEB Intelligence Modify mode, and we can see it is not aggregated.

How do we force data aggregation to occur on BEx side? aggregation should be as indicated in the used objects in the Data Table within the WEBi report, and not on all available objects.

Platform: BO4 and BW7.3
Connection: BICS

- WEBi documents has "Use Query drill" propety checked ON.
- BEx query has characteristics as Free characteristics
- BEx query has filters as BEx variables

thanks for the help.

Mauricio Cubillos

[mcubilloso · Accepted solution]

All,

thanks for your responses.

I found an excellent document here:

https://cw.sdn.sap.com/cw/message/91056#91056

the option I was looking for was "Query stripping". Once I checked on both at Query level and Document Level, I got what I wanted: the data set is as aggregated as the data table within the report indicates.

And,  as expected, the response time was excellent!

[former_member189638]

What happens when you run the query on BEx. You already see it aggregated then the same should happen in WebI too.....If it is not happening then the measure used in BEx might be a smart measure (calculated key figure or restricted key figure)

Trying creating a variable measure in WebI like SUM([Measure]) and use it in your report.

[mcubilloso]

Rakesh,

thanks for yor reply.

the BEx Query has all characteristics as Free characteristic, so when I excecute it in BW (tCode RSRT), I see only one line.

The data set in BO has 100K lines. wich is all the records in cube.

The data table with in the report shows 7 lines (disaggregated by Unit of Measure).

what I would like to see is the data set with 7 lines.

regards,

Mauricio

[Former Member]

Hi

Are you using Dimension object or Hiearchy object in Webi Query design along with measure object

Thx

bose