How to maintain same order of "Reselect Items to Show" between multiple environment

Hi Expert,

Please provide me with some advice and help my model building.

The situation is....

1. In Development environment, Production Data List (Custom Week, such as 2021 W01) as dimension is selected and rearranged by "Reselect Items to Show" on a dashboard.
2. This setting is imported to Production environment via ALM, then I found the order is different from what I rearranged in the Dev environment.

Is there any setting method that enables Selected item order always same as Dev environment?

Regards,
Inoue

Accepted answers

All comments

prabhu

Hi @Tsuyoshi_Inoue,

The Purpose of Production List is - The end users can able to use the list only is production Model.

1. When you mark a list as production in dev model, and after performing ALM sync you will only see the structure(subset and Properties ) of a list in prod model, you won't see the list items in Prod model.

2. If a list is a non production list, then the order what you have mentioned while doing "Re Select items to show" won't get changed, because for a non production list both structure and list items get sync to prod model.

3. So, for a production list, you have to do "Re-select items to show" in prod model.

Read this article to learn about the production list

Production list : https://help.anaplan.com/anapedia/Content/ALM/Model_Data/Production_Lists.html

Tsuyoshi_Inoue

Hi Prabhu,

thanks for your kind comment,

I tried "Reselect items to show"...but where is "Save as Master View"?

Tsuyoshi_Inoue

Hi Prabhu,

This is additional information. but PRD environment is marked as "Offline".

thanks.

Regards,

Inoue

prabhu

Hi @Tsuyoshi_Inoue,

I am sorry, Yes we can't publish our new saved view in a dashboard in a Production Model.

Instead you can create a new module in dev environment, only for filtering or selecting purpose.

Create a new module with your production list as dimension and a line item - filter(Boolean Format)

Apply this Filter in your existing module which has production list as dimension.

then create a revision tag and do sync.

So instead of creating a saved view, you can use this filter for selecting purpose .

Boolean occupies less space (1 Byte per cell)

prabhu

Hi @Tsuyoshi_Inoue,

I have an another approach

In Dev environment.

In our existing Module (production list as dimension) create a line item - sort (number format)

Click the sort icon, which is next to Filter icon and select sort the values from lowest to highest.

Click Filter icon and set a condition = sort line item is not equal to 0.

Create a saved view by hiding the sort line item.

Verify that both sort and filter are enabled in your saved view.

Publish the saved view in your dashboard.

Do the sync to Prod model.

In prod model

Open the module and enter the values for sort line item, the order in which you want to see.

refresh the dashboard

Hope this helps.

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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.
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…