- Community
- :
- About ankulkarni
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 ankulkarni
since
05-14-2020
Friday
ankulkarni
Contributor
Activity Feed for ankulkarni
- Kudoed Re: Level 2 Sprint 2 Model Calendar question, data not showing for kevin.cho. Tuesday
- Posted Sprint 1 : Import flat list for country on Anaplan Platform. 11-04-2020 03:20 PM
- Posted Re: EMP02 Module_ Level 1 on Anaplan Platform. 07-16-2020 12:28 PM
- Kudoed Re: EMP02 Module_ Level 1 for fuvasm. 07-16-2020 12:27 PM
- Posted EMP02 Module_ Level 1 on Anaplan Platform. 07-15-2020 06:27 PM
- Kudoed Re: Level 1 - Expense by Role for fuvasm. 07-15-2020 10:23 AM
- Posted Re: Correct mapping guide on Anaplan Platform. 07-14-2020 06:17 PM
- Posted Level 1 - Expense by Role on Anaplan Platform. 07-14-2020 06:16 PM
- Kudoed Re: Correct mapping guide for einas.ibrahim. 07-14-2020 06:16 PM
- Posted Re: L1MB Part 8: Data Import for REV02 on Anaplan Platform. 07-14-2020 01:50 PM
- Kudoed Re: Correct mapping guide for Jitendra.Vishnolia. 07-14-2020 11:56 AM
- Kudoed Re: Correct mapping guide for fuvasm. 07-14-2020 11:56 AM
- Kudoed Re: Correct mapping guide for einas.ibrahim. 07-14-2020 11:56 AM
- Posted Re: Correct mapping guide on Anaplan Platform. 07-14-2020 11:55 AM
- Posted Correct mapping guide on Anaplan Platform. 07-13-2020 05:14 PM
- Posted Formula error while pulling data from one module to another on Anaplan Platform. 07-13-2020 04:58 PM
- Posted Re: DATA02_LEVEL 1 model import issue on Anaplan Platform. 07-13-2020 03:08 PM
- Kudoed Re: DATA02_LEVEL 1 model import issue for einas.ibrahim. 07-13-2020 03:07 PM
- Posted Re: DATA02_LEVEL 1 model import issue on Anaplan Platform. 07-13-2020 01:46 PM
- Posted DATA02_LEVEL 1 model import issue on Anaplan Platform. 07-13-2020 01:26 PM
14
Posts
0
Kudos
0
Solutions
11-04-2020
03:20 PM
Hello, The csv file contains country name, code and parent, but needs to be imported as a flat list. A) There is no way we can leave the fields blank while importing as it is throwing errors B) Can i make changes in the source file itself to just get the countries? We do not want the parental hierarchy c) I have just mapped parent to country name ( import completed, but with errors) Is this the right way? Kindly advice, Best Regards Ankur Kulkarni
... View more
Labels:
07-16-2020
12:28 PM
I just tried by re importing the data and it worked, even though for one answer i cannot make edits. Thank you for giving me the perspective
... View more
07-15-2020
06:27 PM
Data was successfully imported, mapped and formulation was correct as well in EMP02 module W.r.t EMP03 and SYS08 however, the value for Dec 2020 is not the right answer. Now I am confused as in what exactly went wrong. Can somebody please guide? Thanks
... View more
07-14-2020
06:17 PM
The issue was with one of the dimension which i corrected and was able to solve. Thanks Einas!
... View more
07-14-2020
06:16 PM
I need to set Employee drivers by Role, so i created a list and imported roles data into it. 1) what should be my parent hierarchy in this case - All roles? or All departments? since i had initially created Employee hierarchy with E1 departments - (All Departments being at the top level) then #E2 Employees with E1 department as parent hierarchy. 2) What is a remove time dimension? do I have to delete the time dimension or is this something else, need clarification Thanks
... View more
Labels:
07-14-2020
01:50 PM
IMPORTING STEP 1 STEP 2- I already tried using Date: YYYYMMDD ; FIxed position YYYMMDD and then chose match name. step 3 STEP 4 STEP5 FINAL OUTPUT Can somebody explain the correct way
... View more
07-14-2020
11:55 AM
Data is present in all the hierarchy and I was able to apply the formula too Problem statement:- I did pull data ( volume) from DATAO2 into REV02 module and referencing REV02 module I need to find volume for cities w.r.t product In this case I want to check FY19 total CHOCOLATES consumed in Japan and I can even filter cities and products but the volume remains unchanged. E.g if you see first cell for Jan 19 the volume is 706,982 which is constant for every item.
... View more
07-13-2020
05:14 PM
Hi, I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's. I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks STEP 1 STEP 2 STEP 3 ERROR HIERARCHY Thanks
... View more
Labels:
07-13-2020
04:58 PM
Hello, My goal is to get the 'total volume' of product being used for certain year by different cities. Below are the two data set which have been successfully mapped into Anaplan I want to pull data from DATA02 into REV02 to achieve my goal. SOURCE DATA02- (data SKU Volumes) TARGET: REV02- (data Volume Inputs) I tried using LOOKUP function but somehow unable to use it. What is the right way to map data so that my goal is achieved? Thanks
... View more
Labels:
07-13-2020
01:46 PM
Hi Einas, I have not changed the csv format and tried selecting dates instead of period per below. but, getting an error per below
... View more
07-13-2020
01:26 PM
Hello Community, I am trying to import SKU.Volumes data into the DATA02 module However, I am facing issues while importing. Below is the step 1 STEP 2 STEP 3 STEP 4 STEP 5 FINAL OUTPUT Can someone please guide me? Thank you in advance
... View more
Labels:
07-08-2020
07:27 PM
level 1 Formula given in the activities is giving an error for 'REVENUE' and 'Cost of Sales' Line items. Open the REV03 Margin Calculation module. Toggle to blueprint view to enter the following formulas for each line item: Line Item Formula Revenue 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %) Cost of Sales 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) Sales Price Growth % IF 'SYS00 Time Settings'.Forecast period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Sales Price %) ELSE 0 Cost Price Growth % IF 'SYS00 Time Settings'.Forecast period? THEN YEARVALUE('REV05 Price Growth Rates Staging'.Cost Price %) ELSE 0 Current formula:- Revenue'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price * (1 + Sales Price Growth %) Correct Formula:- Revenue'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Sales Price * (1 + Sales Price Growth %) Current Formula:- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %) Correct Formula:- 'REV02 Volume Inputs'.Volume * 'REV01 Price Book'.Unit Costs * (1 + Cost Price Growth %)
... View more
See more ideas labeled with:
07-08-2020
05:29 PM
The formula for Line item Revenue and Cost of Sales line items is not working and giving an error as below. This is from LEVEL 1 -Part 08 activity- Add Formulas to Line Items in REV03 Margin Calculation. Kindly help ERROR: The formula for 'REV03 Margin Calculation'.Cost of Sales is invalid ;REV02 Volume Inputs'.Volumes is not a recognized line item or list member line item- Revenue Formula - 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Sales Price Line Item- Cost of Sales Formula- 'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Costs
... View more
Labels:
Kudos given to
| User | Count |
|---|---|
| 1 | |
| 3 | |
| 3 | |
| 1 | |
| 1 |
Posts I kudoed
| Subject | Kudos | Author | Latest Post |
|---|---|---|---|
| 1 | |||
| 1 | |||
| 1 | |||
| 1 | |||
| 1 |