将订单项目从每小时到每天进行分组
我想将这些订单项目的价格总结在一起，以便为合同的每个订单。
我想减少每小时的粒度，从而减少我们传递给事实表，然后再将SSAS多数的行计数。
IE合同A可以有许多订购，请考虑可以有许多订单项目的订单线1。 我不得不筛选订单项，但它们只是顺序ID号。
问题在于，我必须从每小时到每天的粒度，但仍然可以使用户可以访问订单项级别
I would like to SUM the price of these Order Items together for each Order for a Contract.
I want to reduce my granularity from hourly to daily and so reduce the row count that we pass to the fact table and then the SSAS cube.
i.e. Contract A which can have many Orderlines, consider Orderline 1 which can have many Order Items.
I have had to screen the Order Items, but they are just sequential id numbers.
The problem is that I have to roll this up to a daily granularity from hourly, but still be able to give users on the cube access to the Order Item level
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以将
sum用作窗口函数。这将有效地将相同的总和写入每个订单项目的多行；就像价格一样。例如
you can use
SUMas a window function. this will effectively write the same sum to multiple rows for each order-item; just like theprice.for example