About kunal_311

kunal_311

I was trying to import data from country CSV to a country flat list. but since the format of the source file was such that parent needs to be entered while importing or else it is throwing error. Due to which imported data comes as hierarchy and not as flat list. Please help with this.

kunal_311

Hi Team, I am stuck in page selection part on part 12, I have 2 doubts on that: 1) On Page Add Location and Product Page Selectors to Dashboard it was not shown as in how to execute page selection in DB. 2) I found a discrepancy in the modules shown as an example in Page Add Location and Product Page Selectors to Dashboard of the DB My DB is as below: 1) I followed all the steps which include only REV02 Volumes module and REV03 margin module, where it seems the problem is with pivot setting, but I set the pivot setting as suggested by the steps in the course. So I think I need to amend on that? 2) The course DB is showing sales price and cost price which was in REV01 Price book module but in DB section it was nowhere mentioned to published the REV01 module as well. Am I missing on something? please help me with this.

kunal_311

I applied filter on forecast periods. But how to delete the line items and dimensions and set them as n/a in the module view? As i am not able to delete it.

kunal_311

Hi team, while importing my CSV file of DATA 01 actual and budgeted, , mapping for the forecast is not available as shown in the attached picture. But then how come forecast is also throwing the same result as actuals, is it by default set to actual data?

kunal_311

Hi Team, I have done as instructed in the training and imported the data from a csv file to the module. All data gets imported but there is no mapping for the "Total" column in Source to target mapping, which seems to throw result as zero. PFA pictures for more clarity. Do I need to use a formula in total column or I am missing something?

kunal_311

Hi Team, Can we edit the name of the module once it is created? eg module name entered is - REV01 Price book module edit version of module - REV01 Price Book If yes, then how to go about it?

kunal_311

While formating the line item in REV02 volume inputs module how to set as default, is it means whatever setting was there for setting by default should go by that? But then the OK tab is disabled if I go by that understanding and not change any information in the formatting tab. 1) 2) Create REV01 Price Book Module - formatting Line Item Format Unit Sales Price USD Currency, 2 decimals Unit Costs USD Currency, 2 decimals Margin % Percentage,2 Decimals How to choose % for a line item formatting?

kunal_311

Thank you for such a detailed explanation. All points understood. Regarding Active? =you are correct, it is used as a filter to filter out among all the employees who are active, throwing result TRUE & FALSE in source file but in my target file in course, it did not mentioned anywhere that active? is one of the line item we need to add. If i want to add it then how to go about it?

kunal_311

I am confused with the mapping part of the source to target as well. As is where to map Active? Employees = Code? ( Because it is numbered list) Dept Code = Department? Country Code = Country? Active? =? How to make sure data we are mapping is correct?

kunal_311

Hi Sorna Raja Prabhu, Can you help me with as in why in target code and department are disabled for mapping?

kunal_311

Hi filip.sypniewski , I am confused with the mapping part of the source to target as well. As is where to map Active? Employees = Name? Dept Code = Department? Country Code = Country? How to make sure data we are mapping is correct?

kunal_311

Okay sorna, Column 2: Code - #E2 Numbered list Column headers : - SYS08 Employees details

kunal_311

Hi filip.sypniewski , I opted for NA as my time scale but I suppose I need to do it for all the line items under that list. Is my understanding correct?

kunal_311

Hi Team, I am trying to Import data into SYS08 Employee Details as part of my Level 1 model builder training program, but while importing i am confused as in what to fill in the time dimension. 1) Since they are flat modules so time dimension should not come, so is that my mistake? do i need to remove time dimension from my numbered list? If yes then how to do it?

kunal_311

Level 1 model builder training module - Creating a line subset section. Before jumping to the next session the training module sats subset #E2 Employees need to be created and to be shown as the above image. I have created the subset but in my lists & rollups section subset is not showing up. Am I doing something wrong ?please help on this My Launchpad image:

kunal_311

Hi Anirudh, I had made 9 system modules a few of them but most of them I can't find it, I posted this module for a reference if I can get an away as in how to search or where to look for formulas. Just to give another example: I was able to decode the code formula only:

kunal_311

New to anaplan platform, i want to insert the formula in my system module and i know we can search it in anaplan anapedia under all functions tab to see which function to apply. But it's not easy to search for a particular line item. Eg i want to insert formula for years only? boolean formatted line item, so how to find out which formula needs to be inserted?

kunal_311

1) I have created a system module but while creating the line items created are in rows, but I want them in columns. how to proceed to this.

kunal_311

Hi Kanishq17, Just to understand this more, since all system modules are flat modules few of them can have time/version as a dimension eg - Time System module contains Time as a dimension. Product Details module contain products line item as a dimension and not time. is this understanding correct?

kunal_311

Hi filip.sypniewski, Appreciate for quick response. 1) It means i need to create the SYS06 Product Details system module again before importing any data inside it. 2) understood the solution. Please acknowledge if my understanding is correct.

kunal_311

1) Mapping Tab: I am confused as to what to insert in the time tab as in the course structure it was clearly given whether we want to import it as an actual or forecast data. But here whether to choose fixed time or Ask each time import is run? 2) Line Item tab: How to go back and check the target items having product family contains family code as that of the source file?

About kunal_311

Importing file into flat lists

PageAdd Location and Product Page Selectors to Das...

Create Saved Views for EMP02 module

Level 1 model building part 11: DATA 01 P&L actua...

Level 1 model building Part 10: OTH01 Non employee...

editing module name

LEVEL 1 MODEL BUILDING: REVENUE & MARGIN

Re: Importing into SYS08 system module

Importing into SYS08 system module

Re: Importing into system module

Re: Importing into system module

Re: Importing into system module

Re: Importing into system module

Importing into system module

Creating line item subset

Re: Inserting a formula

Inserting a formula

System module

Re: Import Data into SYS06 Product Details

Re: Import Data into SYS06 Product Details

Import Data into SYS06 Product Details

Re: Importing into system module

Re: Inserting a formula

Re: Importing into system module

Re: Inserting a formula

Re: Importing into system module

Re: Inserting a formula