Hi Prophix Team,
I have in my Sales Cube a Time Dimension per day. I would like to create a Time Perspective Month to Date.
I tried with the formula below, but it didn’t work:
SUM(LastPeriods(1,[Time Sales Cube].[Default].CurrentMember), [Time Perspective_Finance].[Default].&[BASE])
Any suggestion?
Thanks,
Vincent.
Hi Vincent,
Since you are a CSP customer, I would recommend submitting a support ticket with our technical team - they’d be able to assist. I will also bump your question up to the home page tomorrow to see if anyone else in the community has any ideas
Can you try this,
(Ancestor([Time Sales Cube].Default.Currentmember, [Time Sales Cube].Default.[Month]), ([Time Perspective_Finance].[Default].&[Base]))
1 Like
I am not sure on how to do this, but am very interested
I am unsure of the time perspective formulas in prophix.
We also use a per day time dimension, haven’t had the need for Month to Date but I might try Ali’s formula when I do.
I’m unsure of this but interested to see what others say
I’m not sure either but very interested as well.
I found a way that works for me. I subtract to the YTD, the YTD of the previous month. Since my Time Dimension has days, Month is a Parent. Lag(1) to get the previous period.
[YTD]-SUM(
[Time Sales Cube].[Default].Parent.Lag(1),
[Time Perspective_Finance].[Default].&[YTD]
)
1 Like