About ankulkarni

ankulkarni

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

ankulkarni

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

ankulkarni

The issue was with one of the dimension which i corrected and was able to solve. Thanks Einas!

ankulkarni

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

ankulkarni

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

ankulkarni

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.

ankulkarni

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

ankulkarni

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

ankulkarni

You are right! Thank you so much Einas. It worked

ankulkarni

Hi Einas, I have not changed the csv format and tried selecting dates instead of period per below. but, getting an error per below

ankulkarni

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

ankulkarni

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 %)

ankulkarni

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

About ankulkarni

Re: EMP02 Module_ Level 1

EMP02 Module_ Level 1

Re: Correct mapping guide

Level 1 - Expense by Role

Re: L1MB Part 8: Data Import for REV02

Re: Correct mapping guide

Correct mapping guide

Formula error while pulling data from one module t...

Re: DATA02_LEVEL 1 model import issue

Re: DATA02_LEVEL 1 model import issue

DATA02_LEVEL 1 model import issue

level 1 Formula given in the activities is givin...

LEVEL 1 -Part 08 activity- Add Formulas to Line It...

Re: EMP02 Module_ Level 1

Re: Level 1 - Expense by Role

Re: Correct mapping guide

Re: Correct mapping guide

Re: Correct mapping guide