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,

Anaplan_69482.PNG

Accepted answers

nathan_rudman

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

All comments

nathan_rudman

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

antti.kerola@elisa.fi

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.

nathan_rudman

my answer was cut, take a look now

MaartenGijbels

You could reference the current period something similar to here:

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,

rob_marshall

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

antti.kerola@elisa.fi

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

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Postman/Anaplan - message "404, Not found"
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…