- Community
- :
- About CommunityMember128917
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About CommunityMember128917
since
01-21-2020
Friday
CommunityMember
Occasional Contributor
29
Posts
1
Kudos
0
Solutions
Activity Feed for CommunityMember128917
- Posted Re: Filter Crash in Production on Anaplan Platform. 05-20-2020 04:18 AM
- Posted Re: Filter Crash in Production on Anaplan Platform. 05-20-2020 03:47 AM
- Posted Re: Filter Crash in Production on Anaplan Platform. 05-20-2020 03:30 AM
- Posted Filter Crash in Production on Anaplan Platform. 05-20-2020 02:24 AM
- Posted Re: Select all the line items matching the text on Anaplan Platform. 05-13-2020 08:05 AM
- Posted Re: Select all the line items matching the text on Anaplan Platform. 05-13-2020 06:57 AM
- Posted Select all the line items matching the text on Anaplan Platform. 05-13-2020 06:30 AM
- Posted Sum values based on period on Anaplan Platform. 05-06-2020 11:22 AM
- Kudoed Re: Convert Text date Range to period for sandeep_bk. 05-04-2020 11:22 PM
- Kudoed Re: Convert Text date Range to period for Jared Dolich. 05-04-2020 11:22 PM
- Kudoed Re: Convert Text date Range to period for Misbah. 05-04-2020 11:21 PM
- Posted Convert Text date Range to period on Anaplan Platform. 05-04-2020 09:47 AM
- Got a Kudo for Re: Data Import. 04-30-2020 07:49 AM
- Posted Re: Data Import on Anaplan Platform. 04-30-2020 07:07 AM
- Posted Re: Data Import on Anaplan Platform. 04-30-2020 05:19 AM
- Posted Data Import on Anaplan Platform. 04-30-2020 04:55 AM
- Posted Re: Filter in Saved View on Anaplan Platform. 04-29-2020 04:55 AM
- Posted Filter in Saved View on Anaplan Platform. 04-29-2020 04:29 AM
- Kudoed Re: Export from a Saved View for Misbah. 04-20-2020 12:53 AM
- Posted Re: Export from a Saved View on Anaplan Platform. 04-19-2020 08:40 AM
05-20-2020
04:18 AM
@nathan_rudman Created a new Time Module and used the line items from that modules as a filter and post that this issue got fixed. Thank you 🙂
... View more
05-20-2020
03:47 AM
The list is present in Production model. That is the dimension of the module where that filter needs to be applied. Also the Boolean line item is returning the true when the condition is true but not getting picked in the saved view.
... View more
05-20-2020
03:30 AM
Hi@nathan_rudman , I have a Selection Module without any dimensions where the end user will add the month he wish to view the data for and export from Anaplan. That line item in selection module is used as a filter in my spoke modules to display the data. Below Boolean formula is created in module to filter data: Selection Module.Month = ITEM(Time) and then that filter is used in the saved view Do I need to change any logic ?
... View more
05-20-2020
02:24 AM
Hi, I have created a Time filter for a Dashboard and Export view in Dev Model. But when i push that to Production every time the Filter gets crashed in the Saved view, so i am not able to get the desired layout in the Dashboard and Export File. Can you let me know where am i going wrong. Attaching the screenshot from Dev model which says the layout i want in Production and the Layout gets disturbed in Production where the saved view in not keeping the filter. Thanks.
... View more
Labels:
05-13-2020
08:05 AM
@MaartenGijbels this didn't worked. Applied the logic in TEST 6. The result is zero, since the name formula converted gave output as #number of the display. In the screenshot Capture 2. Test 6 line item should have 1 as output (i can have boolean line item as well, if the result is correct) Also, added screenshot Capture 3 to see different logic that can be applied. But I am not able to get the desired result. Thanks.
... View more
05-13-2020
06:57 AM
Hi @MaartenGijbels Thanks for the reply. I can convert it to Name(), but how would i create a logic of comparison of text fields? (where the display name of numbered list is a Text formatted) I need to create a logic where i need to search for all those items matching the text display of numbered list. Lookup will work on the list formatted line. Thanks.
... View more
05-13-2020
06:30 AM
Hi, The module is Numbered List as a dimension. Requirement: to flag all the members matching the text member of the dimension. Attached the screenshot for reference. Dimension is numbered list with the property as a text (display name) TEST 2 : selection through some formula flag. Requirement is I need a boolean to flag all the member of the list which are identical to the TEST 2. eg. in TEST 2 we have a member U000025. so i need boolean flag for all the members matching U000025. what should be the work around for this? Thanks.
... View more
Labels:
05-06-2020
11:22 AM
Hi, Need a help to build a formula, have attached a screenshot for reference. Formula Needs to be build in Revenue Seasonality which need to take the values from Revenue Column and doing the sum of Periods. For Example: Period 1 amounts: 112+ 95. Needs to be clubbed as 207 and shown in Revenue Seasonality against all the Period 1. Similar goes for rest of the periods. Thanks.
... View more
Labels:
05-04-2020
09:47 AM
Hi, I need to covert the text field range to a period number, what should be the formula for that? I am getting the text range input as: JAN 2019 - DEC 2019 (in a single text cell) I need an output as period number. 1 for Jan 2019 in one line item and in the second line item 12 for Dec 2019. Thanks for the help 🙂
... View more
Labels:
04-30-2020
07:07 AM
1 Kudo
Yes, correct headers should remain intact. Even I can add separator in others after discussing with client if he foresee any separator that can be a part. Thanks for checking.
... View more
04-30-2020
05:19 AM
@sandeep_bk thanks Sandeep. If during the initial creation of the action if we select all the separators and save the process even if the file is not using all the separators in the load. That will be saved in history, and even if next load is with different separator it will get loaded since that was already selected during the creation, correct?
... View more
04-30-2020
04:55 AM
Hi, I need a clarity on data import through integration. For the first time load the load was set and configured in the Integration process, but what if next time the data load comes in with a different delimiter or separators. Will the Integration load auto detects the load and adjust the import or will it give a error. Thanks.
... View more
Labels:
04-29-2020
04:55 AM
Ideally in my last notice, there was no change made to any dimension of the module, even then the saved view filter got crashed.
... View more
04-29-2020
04:29 AM
Hi, I have seen instances where the filters applied in saved views gets crashed, either as we proceed with the development or while ALM (the production marks the filter as crashed while the Dev Model still have the filter intact, then we have to remove and reapply the same filter and move back to Prod, and then it works). Can you let me know what are the reasons for getting a filter crash, as the complete functionality or the view gets disturbed. Thanks.
... View more
04-19-2020
08:40 AM
I might need to add a refresh button as well to get the below table updated and then process the export action. But the solution helps, will check if have two buttons help, one to refresh and other to export.
... View more
04-17-2020
05:30 AM
@Misbah But in that case I need to publish that line item from Module A to the dashboard for the User to select. While there is another table already present in the dashboard which is with Time dimension and user looks to the data in that table and then exports. In your approach the user will first select the Time from dimension and then over look the data and then select the time again in that line item and then exports. Which will be a length process for user to do multiple selections.
... View more
04-17-2020
03:25 AM
Hi, I am trying to create a process for export on a dashboard, facing few challenges in the data. 1. I created a saved view in a module where time is a dimension (time in Months) 2. Build an export action to run the export where Time is a selector and saved that export action and created a process from that and published to the dashboard 3. End user will be extracting Monthly data from that dashboard through the process. User will select the month from the selector on dashboard and accordingly the data will be refreshed, and if all looks good, user will run the process and have the data in excel. Challenge: When I created the export action from the saved view, lets say the time was selected as Jan'19. and completed other part of creating the process and publishing it to the dashboard. Now if I go to the dashboard and select March'19 and click the process the file again gets export for the month of Jan'19 and not for March'19. while the saved view is in sync and displays March'19. Where do I miss that the action gets in sync with saved view and should give the data per the month selected by the user. Thanks.
... View more
Labels:
04-17-2020
02:21 AM
Yes we moved with the same approach. Did a hot fix and added the data again. Thanks for the help.
... View more
04-15-2020
11:14 PM
Thanks Jason.
... View more
04-15-2020
11:12 PM
It's true. It will be highly risky.
... View more
04-15-2020
08:41 AM
Thanks Kavin, Community Members can you confirm is you foresee any issue in this approach or if we can take it as an accepted solution to fix the Production Model.
... View more
04-15-2020
06:56 AM
Thanks Kavin, I believe this could be a better approach, until and unless the Sync don't break. Have you ever tried this approach where you change the Production to standard and revert the model beyond the last revision and then reverted back the model to current state and move the model to Production and still the sync remains intact?
... View more
04-15-2020
06:28 AM
yes. Thanks.
... View more
04-15-2020
04:54 AM
Thanks @Misbah Actually a line item was initially a User Input which was pushed as a formula in sync, which triggered the data loss for the line item. To fix that we pushed back the production model to some restore ID (there was a data loss doing this), and then the production and development model ALM got break and then to fix that we had to create a fresh Dev model from the Production and redo the development. Yes, the data loss was there. But is it if we take the production model back in history through Restore ID instead of Revert to Last revision the ALM breaks?
... View more
04-15-2020
02:55 AM
Hi, When we make a Production move and down the line 2 weeks, we get to know the production moved with an error, and there is lot of data added by the client in this time, what would be the best possible ways to fix the issue? 1. Move the production back to the last revision, fix the Dev and do a sync again? but then there will be lot of data loss. 2. Is it recommended to move your production model back in history through restore ID? Or it should always be to the last revision tag. Is there any disadvantage to restore it to some restore ID, does the Dev and Prod sync gets break doing this? Thanks.
... View more
Labels:
04-09-2020
08:01 AM
Thanks Shahbaz for the reply that was useful. But was looking out for some different type of information. Thanks for the video link.
... View more
04-09-2020
07:23 AM
Hello, I wish to create a dashboard where I could show the user - the roles of all the users and if they wish to change the user role they can update it from the dashboard, how can we do that? (I need an understanding how to display the user role of users on the dashboard) As deleting a user from a dashboard is not feasible so changing the role to No access might help with Model Security. Thanks.
... View more
Labels:
04-08-2020
01:27 AM
Hi, I have a formula applied to a line item which is not giving out the correct result, and if I drill down the formula, the pop-up screen is not considering he other modules for calculation which are there in the formula. Can you help where is the lag in the formula. Have attached a screenshot for reference. Thanks.
... View more
Labels:
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 04-30-2020 07:07 AM |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 04-30-2020 07:07 AM |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 | |||
| 1 | |||
| 8 | |||
| 1 | |||
| 1 |