Skip to Content
0
Former Member
Apr 15, 2010 at 11:11 PM

QAAWS Aggregate Problem

19 Views

Hello everybody, i'm hoping someone can help me with my problem.

I'm trying to generate a web service using the qaaws XI (Query as a Web Service) tool connecting to a BO universe.

I add two objects for being retrieved from universe. One dimension (Territory) and one measure (Revenue).

The measure is defined as Sum in the universe.

I also add a filter over a field on a dimension table.

When I see the results of that query, the tool is performing an aggregation over the filter dimension and it is showing repeated territories.

If I use the Web Intelligence tool and create the same query the results are OK and not aggregated.

Is this a normal behavior?

Thanks in advance.

<div class="ugdv_contextMenu" id="ugdv_myMenu" style="display: none; "><ul id="ugdv_contextMenu"><li id="ugdv_menuItem_google_docs">Open in Google Docs Viewer</li><li id="ugdv_menuItem_new_tab">Open link in new tab</li><li id="ugdv_menuItem_new_window">Open link in new window</li><li id="ugdv_menuItem_download_file">Download file</li><li id="ugdv_menuItem_copy">Copy link address</li></ul></div><div id="jqContextMenu" style="display: none; position: absolute; z-index: 9999; "></div><div style="background-color: rgb(0, 0, 0); position: absolute; opacity: 0.2; z-index: 9998; display: none; "></div>

Edited by: facundo_erreguerena on Apr 16, 2010 1:51 AM