Skip to Content
Former Member
Nov 12, 2010 at 01:04 AM

Why WebI cannot add key figures automatically(based on BW query)??


Hello Guys

I got a problem. When creating an WebI based on a BW query, when I drag and drop dimensions into the report, the key figures cannot add automatically, just list all the line items.

for example, I have 10 sales orders, and the customers are the same. if I add customer field and order value into a webi, it will list ten rows, instead of one row with aggregated order value. But you know, if it is in BW, there will be only one row.

However, if the WebI is based on BW Cube, WebI can add key figures automatically.

Can the WebI based on query behave the same?

Thanks a lot!

Best Regards