- Community
- :
- About andis
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 review, and contribute to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About andis
since
07-17-2020
04-05-2022
andis
Contributor
Activity Feed for andis
- Posted max date on Anaplan Platform. 12-22-2021 01:25 AM
- Posted Re: blocking user activities on Anaplan Platform. 12-21-2021 09:32 AM
- Posted Re: blocking user activities on Anaplan Platform. 12-21-2021 07:38 AM
- Posted Re: blocking user activities on Anaplan Platform. 12-19-2021 08:05 PM
- Posted blocking user activities on Anaplan Platform. 12-17-2021 05:18 PM
- Got a Kudo for Re: Level 3 sprint 1. 08-16-2021 07:22 AM
- Got a Kudo for Re: Level 3 sprint 1. 08-16-2021 07:22 AM
- Posted Summarize Boolean on Anaplan Platform. 03-11-2021 09:19 AM
- Posted Re: Level 3 sprint 1 on Academy & Training. 03-11-2021 08:53 AM
- Posted Re: Level 3 sprint 1 on Academy & Training. 03-11-2021 08:17 AM
- Posted Re: Level 3 sprint 1 on Academy & Training. 03-11-2021 07:31 AM
- Got a Kudo for Level 3 sprint 1. 03-11-2021 07:02 AM
- Posted Level 3 sprint 1 on Academy & Training. 03-11-2021 12:26 AM
- Posted Re: calculation on Anaplan Platform. 02-24-2021 08:02 AM
- Posted Re: calculation on Anaplan Platform. 02-23-2021 07:02 PM
- Posted calculation on Anaplan Platform. 02-23-2021 07:51 AM
- Got a Kudo for Re: Data Load from SAP BW to Anaplan using API. 07-21-2020 05:30 AM
- Posted Re: Data Load from SAP BW to Anaplan using API on Anaplan Platform. 07-17-2020 07:59 AM
14
Posts
8
Kudos
0
Solutions
12-22-2021
01:25 AM
Hi Anaplan expert, The module below has a numbered list and some line items. The formula on the Max Date field is Date[MAX: Date]. I didn't get any results. Could you please tell me how the formula to get the max date from the Date field is? Regards,
... View more
Labels:
- Labels:
-
Calculation Functions
12-21-2021
09:32 AM
@ChrisAHeathcote Hi Chris, My goal is to create a button on the dashboard for specific users so that they can do data locking/data unlocking. I don't think users will access the User menu. Do you mind giving other advice? Thank you for your advice. Regards, Andi
... View more
12-21-2021
07:38 AM
@ChrisAHeathcote I'm interested in your first option, implementing user access by roles. When I opened the Roles->Modules menu, I didn't see the Import button. Could you please give an example of this option? Regards, Andi
... View more
12-19-2021
08:05 PM
Hi Anaplan experts, Could I know any clue to help me, please? Regards,
... View more
12-17-2021
05:18 PM
Hi Anaplan community, I'm trying to manage data locking by changing users access. Unfortunately, I have 79 lists as Selective Access lists to support some business units/companies in a model; it makes a complex security matrix. When I try to export a user access table and then import it into a module, I face technical issues for users that can access multiple-member lists. The module will transform users who get write access to change it to read access so that they can't enter data in some modules. On the other hand, I have tons of modules in a model, so I can't use DCA in tons of modules. If I implement Valid From/Valid To on versions, it will produce a storage issue. Anyway, is there a good solution to manage data locking in this situation? Regards, Andi
... View more
Labels:
- Labels:
-
Administration and Security
03-11-2021
09:19 AM
Hi there, Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the expected result when I was implementing ANY & TIMESUM functions. Please advise me. Thanks,
... View more
Labels:
- Labels:
-
Calculation Functions
03-11-2021
08:53 AM
1 Kudo
@JaredDolich When I checked the below report VS Anaplan's screenshot, I saw something wrong in Brazil data below. And my stretch goal is below: Brazil data is 1 in Anaplan's screenshot. Did you get the same result in your level 3 checking report? Regards,
... View more
03-11-2021
08:17 AM
1 Kudo
@JaredDolich I assigned Product Family list and Country list in the TAR01 Detailed Sales Targets module to link the TAR10 module without the SYS03 module. What do you think?. Thanks,
... View more
03-11-2021
07:31 AM
@JaredDolich I didn't see the TAR10 The Actual Sales module in the Level 3 model start. How to download this module? Regards,
... View more
03-11-2021
12:26 AM
5 Kudos
Hi Experts, A couple of weeks ago, I imported data into the below module. Then, I summarized the above data into the below module. I have no clue to get data PY Country and Product Family Sales in the below module. Please advise me. Regards,
... View more
Labels:
- Labels:
-
Level 3 Model Builder
02-24-2021
08:02 AM
Hi Alex, I appreciate your information. I will try your suggestion later. Meanwhile, I've changed my configurations: 1. Added New list (numbered list type) with some properties. The content is the same as Source Module 2 above. 2. Put the SUM function in the target module. My SUM function: Source module 1.Amounts [SUM: Product>Groups#.Group 2, SUM: Product>Groups#.Group 9] Error message: The dimension of mapping used for aggregation doesn't match any dimension of the source. Questions: 1. Could you see something wrong? 2. I've created the new list above to replace Source Module 2. Which one is a good solution (PLANS)? 3. You may give other thought. Regards, Andi
... View more
02-23-2021
07:02 PM
Hi Alex, FIRSTNONBLANK function is to skip empty cells and then take the next cell. In my case, the source module 2 always has a certain code because Group 1..Group 9 are lists. If you don't mind, I want to listen to Anaplan best practices for my business case above. Regards,
... View more
02-23-2021
07:51 AM
Hi experts, I have three modules below: I wanted to get a subtotal of product1 based on the selected GRP2 & GRP9 product groups in the target module. I tried to use LOOKUP, SUM, and SELECT, I received an error. Please advise me on this case. Regards,
... View more
Labels:
- Labels:
-
Calculation Functions
-
Modeling
07-17-2020
07:59 AM
1 Kudo
Hi Nathan, Could I get Anaplan documents that explain the data load? Thanks.
... View more
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 03-11-2021 08:53 AM | |
| 1 | 03-11-2021 08:17 AM | |
| 5 | 03-11-2021 12:26 AM | |
| 1 | 07-17-2020 07:59 AM |
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 5 | 4360 | |
| 1 | 3225 | |
| 1 | 3233 | |
| 1 | 2771 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 1 | 03-11-2021 08:53 AM | |
| 1 | 03-11-2021 08:17 AM | |
| 5 | 03-11-2021 12:26 AM | |
| 1 | 07-17-2020 07:59 AM |
