Check if there's a value in any version

klameer · 2023-11-09T16:17:31+00:00

There was an error rendering this rich post.

I'm trying to build a filter that will only show list items that have values in them regardless of the version.

Is there an elegant way of checking for a non-zero value in any version?

The two ways I know of doing this is to create line items for each version using [SELECT: Versions.version] and adding them up.

Or using NEXTVERSION() nested.

This works ok until you have many versions in the model and the maintenance becomes a pain.

Are there any other ways of doing this?

Accepted answers

anirudh

I would never recommend this except as a last resort, but you can drop in a 4th dimension in Rows and even more although I've never tried that out

Do note that Anaplan really dislikes nested dimensions and views open up very slowly

Drop in your extra dimension in the rightmost corner of the last dimension and it should pivot successfully

All comments

anirudh

Version is a discrete dimension in Anaplan similar to Time. Other lists work contiguously. So I believe the best way to filter for non zeroes is to SELECT out each version as you noted. Or to pivot the versions into page selectors and set the filter to Current Page which should work well with the filter line item also having the version dimension

klameer

Thanks for your response.

Problem is that you can't pivot with more than three dimensions. This is the problem I'm facing.

anirudh

I would never recommend this except as a last resort, but you can drop in a 4th dimension in Rows and even more although I've never tried that out

Do note that Anaplan really dislikes nested dimensions and views open up very slowly

Drop in your extra dimension in the rightmost corner of the last dimension and it should pivot successfully

klameer

Hey, thanks Anirudh. This is a game changer for me. I didn't know you could do this.

It is a last resort and users would not normally be loading this view, it was only created for actions.

Really appreciate your help with this.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…