September 7, 2015 at 4:55 am
Hello, please I have a measure that i can compute through calculated member, or by using a tuple, the issue I am having is that when I use(slice) a dimension on rows, the result I get is different for both of them, can anyone please give a clue, the queries are below. thanks
select
(TAIL(nonempty([Boardingdate].[Month Short Name].[Month Short Name],[Measures].[Amount]),1).ITEM(0),[Measures].[Amount]) on 0
,{[DaysFromBoarding].[DFB].&[0]:[DaysFromBoarding].[DFB].&[60]} ON 1
from
[Strategy_Performance_Dashboard]
**This query above gives the correct result
----------------------------------------------------------------------
with
member
[measures].m9
as
(TAIL(nonempty([Boardingdate].[Month Short Name].[Month Short Name],[Measures].[Amount]),1).ITEM(0),[Measures].[Amount])
select
measures.m9 on 0
,{[DaysFromBoarding].[DFB].&[0]:[DaysFromBoarding].[DFB].&[60]} ON 1
from
[Strategy_Performance_Dashboard]
September 7, 2015 at 5:22 am
September 7, 2015 at 7:01 am
Thats not the issue, but i can spot what is happening , but i cant fix it,
the situation is that
DFB JAN FEB MAR APR
0 4
1 5 6
2 7 8
3 9
Lets say this is the matrix table, and as you can see March is the last non empty month in general, so what i am trying to return is a calculated measure that the DFB will be able to slice through for the months so from that i can do other calculations. on the result
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply