假设我有一个叫做图书馆图书的维度和一个叫做过期天数的事实。如何编写mdx表达式来返回每个num天数的过期天数的图书数量?换句话说:
Days Overdue | Num books
1 | 3498
2 | 237
3 | 57
在SQL中,答案很简单:
select days_late,count(*) from days_overdue_fact group by days_late
在mdx中,我尝试过这样做:
with member [Measures].[Overdue Count] as 'count([Bo