Time Perspective Month To Date

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 :slightly_smiling_face:

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