嗨togheter
现在我有了一个工具,我可以使用gui来设置大多数东西,*应该*不是那么难用。但对于BI世界的新手来说,这对我来说仍然太难了。 =)
现在我有了一张表:
< thbody>< / thbody>
Hans | 100 | 13.02.19 | 12:00:00 |
Hans | 80 | 15.03.19 | 14:00:00 |
Fritz | 100 | 14.02.19 | 13:00:00 |
我需要制作2个报告,一个显示当前值,另一个显示时间轴上的值。
数据透视表1: (不要求和,但按员工的日期显示最后一个条目)
80 |
数据透视表2 :(不要求和,但按员工当前日期维度显示最后一个条目)
100 | 80 |
100 | 100 |
现在我确实尝试设置措施"Empoyment"。到"SUM"和"最后一个孩子"但是,SUM,只是没有得到我需要的地方和"最后的孩子"。确实删除了整个数据透视表,所以在那里还没有名字了。
我也能做一些basix MDX,但我认为这对我来说很遥远。任何暗示都被暗示了!
解决方案
嗨screeneys,
我不知道你的是什么立方体结构,下面是我的设计:
我有日期维度,类别维度(名称)和事实维度,然后我使用下面的查询(这里我的日期是年)
WITH MEMBER [MEASURES]。[LAST DAY] AS (TAIL([Date]。[Calendar]年份。[日历年]。成员).item(0),[测量]。[互联网销售计数]) 选择[产品]。[类别]。[类别] 1,{ [MEASURES]。[最后一天]}来自[Analysis Services Tutorial]的0
对于数据透视2,我认为您可以使用以下查询
WITH MEMBER [MEASURES]。[nonull] as iif(([Date]。[Calendar Year]。 currentmember,[Measures]。[Internet Sales Count])= null,([Date]。[Calendar Year] .currentmember.prevmember,[Measures]。[Internet Sales Count]),([Date]。[Calendar Year]。 currentmember,[Measures]。[Internet Sales Count]))选择[Product]。[Category]。[Cat egory,([日期]。[日历年]。[日历年],[测量]。[无效])0来自[Analysis Services Tutorial]最好的问候, Zoe Zhi
Hi togheter
Now I got a tool where I can setup most things with a gui and it *should* be not that hard to use. But for a newbie in the BI-World it still is way too hard for me. =)
Now I got a table like:
<thbody></thbody>
Hans | 100 | 13.02.19 | 12:00:00 |
Hans | 80 | 15.03.19 | 14:00:00 |
Fritz | 100 | 14.02.19 | 13:00:00 |
And I need to make 2 repots, one showing just current values and one which showes values over a time-axis.
Pivot Table 1: (don’t sum, but show last entry by date per Employee)
80 |
100 |
Pivot Table 2: (don’t sum, but show last entry by current date dimension per Employee)
100 | 80 |
100 | 100 |
Now I did try to set the measure "Empoyment" to "SUM" and "Last Child" but SUM, just doesn't get where I need and "Last Child" did remove the whole pivot table, so there where not even anymore the Names left.
I'm also able to do some basix MDX, but i think this goes to far for me. Any hint apprieciated!
解决方案Hi screeneys,
I don't know what is your cube structure, below is my design:
I have date dimension, category dimension(name) and fact dimension, then I use query like below(here my date is year)
WITH MEMBER [MEASURES].[LAST DAY] AS (TAIL([Date].[Calendar Year].[Calendar Year].members).item(0),[Measures].[Internet Sales Count]) select [Product].[Category].[Category] on 1, {[MEASURES].[LAST DAY]} on 0 from [Analysis Services Tutorial]And for pivot 2, I think you could use below query
WITH MEMBER [MEASURES].[nonull] as iif (([Date].[Calendar Year].currentmember,[Measures].[Internet Sales Count])=null,([Date].[Calendar Year].currentmember.prevmember,[Measures].[Internet Sales Count]),([Date].[Calendar Year].currentmember,[Measures].[Internet Sales Count])) select [Product].[Category].[Category] on 1, ([Date].[Calendar Year].[Calendar Year],[MEASURES].[nonull]) on 0 from [Analysis Services Tutorial] Best Regards, Zoe Zhi更多推荐
帮助在时间轴上显示度量,而不执行求和操作。
发布评论