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