Skip to Content
0
Former Member
Dec 05, 2011 at 02:38 PM

QAAWS Issue

31 Views

Hi

We are facing an issue with the aggregation of data in QAAWS. The Xcelsius dashboard is built using QAAWS and everything was fine till we introduced a filter in QAAWS.

As per the requirement we needed a Project type(display attribute of Project) filter in the QAAWS, when that is implemented the data started deaggregating

Before O/P

Fiscal Year Amount

001/2011 20

002/2011 50

Current O/P (With filter)

Fiscal Year Amount

001/2011 5

001/2011 10

001/2011 5

002/2011 20

002/2011 30

We tried different options of aggregating the data at the universe level for the measure using Sum function instead of data base delegated -


no luck

-Tried to use Sum(Measure) in the Select -


didn't allow to use as the universe is based on Bex query

Waiting for any other suggestions/options available. Please do the needful.

Regards

PP