SSAS - 创建仅计算最新事件的度量
我是 SSAS 新手，不知道如何大量自定义度量。 我的事实表存储每个更改（例如创建新页面或删除页面等事件）。 默认度量将返回所有更改的计数，但我还需要一个度量 将显示系统中的页面数（事件引用的页面）。它应该只计算每个不同页面的一个事件，但使用截至用作过滤器的日期的系统最新状态。 例如：某人在周一创建了 5 个页面，然后在周二删除了 2 个页面并在周五添加了 1 个页面。 这是 8 个事件，但只有 6 个唯一页面，因此如果筛选星期二，该度量应显示 5 页；如果筛选星期五，则该度量应显示 6 页。它应该只计算该页面的最后一个事件（而不是使用该页面的第一个事件，因为这可能会影响其他维度）。 我该怎么做呢？
I'm new to SSAS and I'm not sure how to heavily customize a measure.
My fact table stores every change (events like created new page or deleted page).
The default measure will return a count of all changes but I also need a measure that
will display the number of pages (to which the events refer) in the system. It should only count one event for every distinct page but using the latest status of the system as of the date being used as a filter.
For example: Somebody creates 5 pages on Monday and then deletes 2 pages on Tuesday and adds 1 page on Friday.
That's 8 events but only 6 unique pages so the measure should display 5 pages if filtered for Tuesday and 6 pages if filtered for Friday. It should only count the events that are the last one for that page (As opposed to using the first event for that page as this could affect other dimensions).
How would I go about doing this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您已经有一个 Event_Count 度量，现在需要创建一个 Page_Count 度量。此 Page_Count 度量将具有 Last_Change_Type 维度和 Time 维度。通过 Last_Change_Type 维度对 Page_Count 度量进行切片将得到您想要的结果。
要为 Page_Count 事实创建视图，您只需按 Page_Id 对 Event_Count 事实表进行分组，并获取所有维度的 MAX(Event_Date) 信息。
如果没有架构视图，这一切都非常概念化，但您的测量听起来并不复杂，它只是不在“事件”粒度，而是在“页面”粒度。
You already have an Event_Count Measure, and you now need to create a Page_Count measure. This Page_Count measure will have a Last_Change_Type dimension and a Time dimension. Slicing the Page_Count measure by the Last_Change_Type dimension will give you what you're after.
To create a view for your Page_Count fact, you could just group your Event_Count fact table by the Page_Id and get the MAX(Event_Date) info for all the dimensions.
This is all very conceptual without a view of your schema, but your measure doesn't sound complex, it is just not at the "Event" granularity, it is at the "Page" granularity.