Referencing values across Versions

Hi Team,

We upload our full SF account list to our Customer Account list at the start of the planning cycle and I wish to delete out accounts which do not have revenue in any versions once the Plan has been completed

I'm created a module dimensionalised by Customer Account & Versions which returns a Boolean if the Customer Account has revenue in that Version but I need to create a single Boolean which determines whether the Customer Account has revenue across any of the versions (without creating a formula which directly references the Versions which I want to avoid because we may add versions in the future & I would then need to manually adjust this formula)

Any ideas?

Thanks

Accepted answers

All comments

Misbah

@MarkTurkenburg

Assuming this is your requirement - In this case Only A4 is expected to be deleted

Since you can't check (Any) Summary level of Native Versions it is difficult to achieve this. You could easily achieve this thru Fake Versions but not with Native Versions.

I guess the only solution is to check it with formula for each version

Tiffany.Rice

@MarkTurkenburg

May not be the most optimal but perhaps you could create a secondary list (Accounts with Revenue) based on a saved view where the Boolean is true within your module dimensioned by Customer Account & Versions. You will then create a module dimensioned by Customer Account alone, if a matching item exists within the secondary list then set Boolean line item to False. You would then configure a delete by selection action based that line item.

MarkTurkenburg_*8288

Hi @Tiffany.Rice

Thanks for the reply but I can't quite see how this would assist in determining whether an account has revenue in ANY version. The 'Accounts with Revenue' list you mention is that Revenue in any Version?

Thanks

Mark

MarkTurkenburg_*8288

Thanks @Misbah

In your example all items except A1 to A3 would be deleted

It's unlikely that we will use the Native Version dimension in the future to do Scenario analysis (this is the situation where there would be revenue across Versions) but it was just a fail-safe so that no Accounts with data was deleted when cleaning up the list.

I'll create an Admin note to adjust the calculation if more than 1 Version is live at the time before the Delete Action is run

Thanks for your help

Mark

Tiffany.Rice

Yes, you would be creating a list of accounts with value in any scenario or conversely without a value if those are the ones you are looking to delete. Mirroring Misbah's example below are some additional details.

Module 1:

Create saved view of Accounts/Versions without revenue i.e. to be deleted.

Accounts with Versions Module.PNG

New List - Accounts to Delete:

Import saved view from above module. By default if each account is referenced more than once (i.e. in multiple scenarios) it will be ignored and only the first occurrence is imported. Assign a default value of 1, this will be used in the next step.

Accounts to Delete List.PNG

Create Account Deletion Module:

Cross reference Accounts to Delete list to normal list of Customer Accounts. Create delete by selection process.

Accounts to Delete Module.PNG

MarkTurkenburg_*8288

Thanks @Tiffany.Rice

I guess my query is how to obtain the Boolean results in the 1st Module in your example through a formula which does not directly reference Versions using SELECT etc?

I can create a formula which references the Versions directly but then you have to remember to adjust the formula when a Version has been added before running the Delete Action. I was hoping to be able to skip this step so I could run the Delete Action at the end of the planning cycle without it

Thanks

Mark

Tiffany.Rice

@MarkTurkenburg
Touche, I guess it doesn't work when you try to go straight the end results (that's what I get for changing my example midstream). So I am back to my original hypothesis. Create a list of Accounts where there is a value then in you accounts to delete module, delete only Customer accounts that do no existing in the Accounts with Revenue list i.e. value = 0. Same concept just slightly different execution.

daniel_harman

Creating a line item Any To Delete of the same dimensionality, with formula PREVIOUSVERSION(Any To Delete) OR To Delete, would give you the list of items to delete when you look at the value of the last version. Alternately can do this with NEXTVERSION, and look at value of the first. If you could guarantee that your first or last version didn't change then you could use that.

If you are not currently using 'CurrentVersion' then you could use current version to flag which is first or last - though obviously that has it's own risks (requires updating, could be that a requirement for CurrentVersion is introduced in the future).

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…