7
Vote

Support OData Groupping Aggregates Rollup

description

Want support as Aggregates and Groupping on Exposed OData REST Services...

Some links describing the needed:
Sample:
~Sales?$select=Customer/Country,Customer/Name,
Product/ProductGroup/Name,
Product/Name,Amount
&$expand=Customer,Product,Product/ProductGroup
&$aggregate=Amount
&$rollup=(Customer/Country,Customer/Name),
(Product/ProductGroup/Name,Product/Name)
In observation to: http://aspnet.uservoice.com/forums/147201-asp-net-web-api/suggestions/4178164-support-odata-groupping-agregates-rollup

comments

nlips wrote Jan 6 at 9:59 PM

Now you can use AdaptiveLINQ (www.adaptivelinq.com) and build analytical query by simply using the standard $select operator.
Sample :
"sales per customer" :
myAnalysisService.svc/Sales?$select=Customer, Sales
"sales per customer and product category" :
myAnalysisService.svc/Sales?$select=Customer, ProductCategory, Sales
Dimensions and measures are defined "server side". Read my OData page OData page to learn more.