帮助在时间轴上显示度量，而不执行求和操作。 [英] Help on showing a measure on a time-axis, without the sum action.

问题描述

嗨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： （不要求和，但按员工的日期显示最后一个条目）

< td> 100

姓名	就业
Hans	80
Fritz

数据透视表2 :(不要求和，但按员工当前日期维度显示最后一个条目）

< thead>

姓名	2月19日	3月19日
Hans	100	80
Fritz	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>

Name	Employment	Modified Date	Modified Time
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)

Name	Employment
Hans	80
Fritz	100

Pivot Table 2: (don’t sum, but show last entry by current date dimension per Employee)

Name	Feb 19	Mar 19
Hans	100	80
Fritz	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

这篇关于帮助在时间轴上显示度量，而不执行求和操作。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！