Aggregating the data in Qaaws(query as a web service)

[Former Member]

Hi,

We are planning to develope a Business analytical solution. For this we're using sql as the database. In the database we have data on a daily basis for 2 years. with a unique data key for each day.In the tables we have a coloumn for total revenue for each day.

So can anyone tell me is it possible to aggregate the data on a monthly basis (may be based on DATE KEY) on Qaaws(query as a web service ) level so that we can run a single Query to have the monthly data aggregated for each month?

Is it possible to form a GROUP BY clause in Qaaws? Because then we're planning to put this data into Xcelsius.

Thanks and regards,

Abhishek Pal Chaudhuri

[Former Member · Accepted solution]

QaaWS are built over universes. Create a month value based on your datekey - int(datekey/100) for example if you have datekey as yyyymmdd

Edited by: Me map on Jul 4, 2011 3:06 PM