How I can made logic against time dimension?

Highlighted

How I can made logic against time dimension?

Hi,

 

I would like to understand how I can make a logic against Anaplan Time dimension list. 

 

Target:

To make function for "Test" line item which tap True (to Test line item) for all periods where "Actual" current period is equal or smaller.

 

Cheers,

A   

 

 

6 REPLIES 6
Highlighted
Community Boss

Re: How I can made logic against time dimension?

Hi,

 

It depends on where you store "actual period".

 

If you store it into the Time tab then you can use the formula:

CURRENTPERIODSTART()

So to do what you want you could do:

IF START() <= CURRENTPERIODSTART() THEN TRUE ELSE FALSE

 

Actually to do extactly what you want, you'd better use CURRENTPERIODEND():

IF START() <= CURRENTPERIODEND() THEN TRUE ELSE FALSE

 

This formulas should be in your module called Time Filters. I advise that you take a look at the anaplan app where there is a lot of examples like that:

https://community.anaplan.com/t5/learning/Time-Filters/ba-p/28086

 

 

 


Nathan Rudman, Anaplan Model Builder
Highlighted

Re: How I can made logic against time dimension?

If I want to put TRUE flag for all of those periods which earlier or same period than the current period (this is coming from time settings). This is my challenge. 

Highlighted
Community Boss

Re: How I can made logic against time dimension?

my answer was cut, take a look now

Nathan Rudman, Anaplan Model Builder
Highlighted
Certified Master Anaplanner

RE: How I can made logic against time dimension?

You could reference the current period something similar to here:

 

MaartenGijbels_0-1588836681010.png

 

 

But it depends on what you want to achieve.

 

This allows you to identify future (or past) months. In essence every past month should have actuals (switchover)

 

All the best,

Highlighted
Master Anaplanner/Community Boss

Re: RE: How I can made logic against time dimension?

antti.kerola@elisa.fi ,

 

For all time logic, keep the logic in a SYS Time module (only dimensionalized by Time) and then have your other modules reference this logic.  We see this all the time where people put if item(time) <=currentperiodstart() then .... in modules that are dimensioned by multiple which can lead to performance issues (logic being kicked off when it really doesn't need to).  @MaartenGijbels  has done this absolutely correct.

 

Rob

Highlighted

Re: RE: How I can made logic against time dimension?

Thanks, Rob for your insight. I will definitely concern about this.