Understand why a formula in the List Property is not working?

Hello, I have a list property that has a formula in it that was working and pulling data correctly. But today, it is not pulling data and I am not able to identify the root cause.

Here is the screen shot of the list property formula:

Here is the module where the formula is pulling the data from:

Your help in guiding me in the right direction is appreciated.Thanks.

Accepted answers

VIGNESH.M

Hi,

It's not like, the data won't be pulled if version dimensions is used in module.

We have 2 option to get the data,

#1. Use select function to get the data.

Employee Info Properties.Role[SELECT: VERSIONS.Actual] or

#2. Set Current Version

The data will come based on the current version we set in the versions setting.

I have set current version of the model is "Actual Version"

In Module, I have used versions and Employee Dimension and line item as 'Role'.

As mentioned above the current version(Actual) data being pulled from the module.

Regards,

Vignesh M

All comments

rob_marshall

@svbhagat ,

What is Hourly Employees by Roles Assumption dimensionalized by? It can only have one list (dimension) in the Applies To and no Time Scale or Version.

Rob

svbhagat

Hello Rob,

Thanks for the response back. The Hourly Employees by Roles Assumptions Module is only dimensionalized by the List - Employees By Role. The Time Scale is Not Applicable and Versions is All. Here is a screen shot. These settings have not been changed. Therefore, I'm puzzled as even with these settings the module was pulling the property from the list correctly before.

kavinkumar

HI @svbhagat,

Version is also one of the dimensions in your module hence your formula in property is not working. Anaplan is not able to recognize which version should it take hence it is blank. If you want to take particular version then include Select function [ex,Select:Version.Actual ] in your existing formula.

I hope this helps.

Kavin.

DavidSmith

@svbhagat

Also, if you are referencing a module with Versions to a module without, the default will pull from the Current Version. That is probably why you are not seeing anything (if you haven't got that set)

You can use this instead of SELECT, if you need it to change dynamically as you change the Current Version setting in the Versions tab

David

svbhagat

I just want to make sure I understand. Going back to my original question.

I have a formula in my List Property to pull a line item from this module. Is the List property setup correctly?

Are we saying that as long as the module has all versions pulling, the line item from the module will not get pulled into my List property?

Thanks

VIGNESH.M

Hi,

It's not like, the data won't be pulled if version dimensions is used in module.

We have 2 option to get the data,

#1. Use select function to get the data.

Employee Info Properties.Role[SELECT: VERSIONS.Actual] or

#2. Set Current Version

The data will come based on the current version we set in the versions setting.

I have set current version of the model is "Actual Version"

In Module, I have used versions and Employee Dimension and line item as 'Role'.

As mentioned above the current version(Actual) data being pulled from the module.

Regards,

Vignesh M

svbhagat

Thank you. This clarification helped me resolve the issue. I changed the current version setting and that has updated the information. I will also look into using the SELECT formula for future.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…