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!