Active Version

Hello Community!! I have created a Custom Version list (v1, v2 and v3). I have a module with Accounts list and Versions list applied and a Active boolean line item which have few Accounts as true in V1 and few other Accounts as true in V2 and like vise for v3. We have another line item which is All Active which should show as TRUE in V1 for all the Accounts which are set to TRUE in v1,v2 and v3 in Active line item. But I don't want to use Select for this. Any recommendations. Thanks is advance.

Accepted answers

All comments

anirudh

Hi,

Assuming the All Active line item is not dimensioned by Version:
1. Set the summary of the Active line item to ANY (in the blueprint view)
2. Make sure there is a top level in your custom version list (Ex: All versions)
3. Just refer the Active line item in the All Active Line item

Let me know if this works

Regards,
Anirudh

Misbah

@ShekharGite

1. Create a dimensionless module and insert as many line items as versions

2. Format the line item to Custom Versions and Select versions.

3. Use LOOKUP on these line items.

This should work but it needs maintenance. See if @anirudh solution work for you. I think it will if you have Top Level for custom versions.

Misbah

ShekharGite

Thank you @anirudh and @Misbah . I already tried these two solutions but ANY will need a top level item and the Lookup will require maintenance. The reason for not using SELECT was to avoid maintenance.

ShekharGite

Also I want to keep All Active line item as dimension ed by Version as I want to change it dynamically from the dashboard.

anirudh

Any reason you want to avoid top level?

The only other way I can think of is to import the checkbox from all three versions into the All Active line item. Create saved views for each version and filter to only the checked members and import each saved view into the line item

But then the data is not live and users might have to click some kind of submit or update button

Regards,
Anirudh

ShekharGite

I am okay with having the Top level item but let me explain the whole scenario : I will be selecting a Active Version from dashboard and suppose I have selected v1 then The All active line item should have all the Accounts as TRUE in the v1 version only based on my selection on the dashboard. So the ANY will not work from me as it has to be dynamic and not only the Top level item. I hope I made some sense.

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385