double aggregation in domain

0

Hi,

 
I'm sure someone had to deal with this case as it's very common business requirement. But I could not find any articles or answers. We have data in relational data source prepared at month level for each asset. On the asset dimension data needs to be summed up, but on the calendar dimension we need last value (can be average, if that's easier). It's easy to do that in Studio report, but we need to expose this data through Domain and Ad-Hoc designer. May someone has similar experience?
 
Year 2013   2013 Total Grand Total
Quarter 1  1 Total 2  2 Total    
Asset | Month 1 2 3   4 5 6      
43464 200 400 400 400 400 400 500 500 500 500
43471 57000 57000 57000 57000 51000 51000 57000 57000 57000 57000
Grand Total 57200 57400 57400 57400 51400 51400 57500 57500 57500 57500
 

 

terija129's picture
Joined: Feb 16 2011 - 12:12am
Last seen: 8 months 2 weeks ago

0 Answers:

No answers yet
Feedback