About vivekpratap2015

vivekpratap2015

Hello All, Very sadly I wanted to inform you that I devoted too much time and energy in learning anaplan level -2, but unfortunately, anaplan academy is not awarding my certification, as even though i have completed all the exams of Sprint 1/2/3 and conclusion, the conclusion exam is not showing as completed, due to this anaplan academy tool issue , the academy is not ready to issue the certificate to me. I think I have wasted my time and energy in the learning anaplan. Sorry to say this time, because of anaplan academy I need to stop my learning with anaplan and need to shift focus to some other technology. Nevertheless, thanks anaplan and community members for your kind support. Thanks Vivek

vivekpratap2015

Hi All, Can anybody suggest about the delay regrading receiving the certification from anaplan academy . I requested 3 days back ,but till now no response from anaplan academy regarding certificate . Let me know if any body has gone through the same instance. Thanks Vivek Singh

vivekpratap2015

Hello All, just wanted to ask about the experience regarding the module design phase like we usually adopt, first we all have look on the UX experience, then the functions like calculation etc and at last about list, modules etc .. If somebody has a different view please share, as in my organization things do get changed more often, also i have seen there was one question in level2 sprint 2 , which i was not able to correct too. In case if somebody has any answer about that question please try to explain and i would like to request everybody to express their view/ express how they start the design process. Thanks Vivek

vivekpratap2015

@Misbah Hi , Below is the screens shot , can you please locate where exactly you are suggesting for change :-

vivekpratap2015

@Misbah Hey its Month only :-

vivekpratap2015

HI @sunilramakumar Can you please explain the way to solve the date format issue , as even i am stuck at this point.

vivekpratap2015

Thanks @JaredDolich But I used CLT+F to find the missed view , its sorted now . Thanks alot

vivekpratap2015

Hi All, I am trying to import the below CSV file to module, but unable to get the correct time mapping detail, any help will be appreciated . CSV File :- Mapping Column view :- Time Dimension mapping view :- The problem is I am not getting the month neither under "Pattern and Separators" nor Fixed Position patterns. I think i need to do some changes with these mapping options rather than changing any date format in CSV file. Also the customized mapping is restricted under this import. Module View :-

vivekpratap2015

Hi All, I have created the module SYS12 SKU Data and Saved view as "Build SKU" and "Import SKU Details". but while importing the Build SKU saved view in new list P3 SKU I am not able to find the saved view for selection , below is the screenshot for the same. Let me know if in case I am missing any thing ?

vivekpratap2015

Hi All, Can you please help me to understand visually what is the difference between system module and saved view as per below instructions :- SYS05 Saved View :- Let me know please if i am doing any mistake ? as in furher topics if i am importing these saved viewes I am not getting any data populated in lists.

vivekpratap2015

@nb Thanks for below explanation , I have created the subset as per shown below ,can you pls help how can i get the subset included in the saved view activity. Also i think the options for location subset(3) should be different but not exactly same as of original location column(2).

vivekpratap2015

Hi All, Can anybody suggest to me what I do to include subset line items in the saved view for SYS07 Location details :- I know how to create the subset line items, but can't figure out what to do with subset line items? which module i can refer having number as format etc ?? so request you to please help me to complete this activity. SYS 07 Location details :-

vivekpratap2015

Hi All, I have created the list subset as below , but I am unable to select the desired line item of a referred module in List Subset :- List subset :- Referred Module :- Thanks Vivek

vivekpratap2015

Hi All, Can you please share the link or path to download the certificate, as I have completed the level 1 certification course. I have checked my learning, but couldn't find any certification or any survey link etc .. Thanks Vivek

vivekpratap2015

HI , @Akhtar.shahbaz Its employee list only , below is the screenshot

vivekpratap2015

Hi @Akhtar.shahbaz Module EMP03 Data is uploaded by text file , so whatever the data is there in text file is replication the same in module EMP03. below is the e.g. screenshot The issue is even though formula mapping is done ideally i should get the data in EMP02, but unfortunately the data is not appearing in EMP02 for phone, car and medical. Below is the screenshot of EMP02 in Grid View, in which I have considered a different department, but none of the data is appearing.

vivekpratap2015

Hi All, Even teh same issue I am facing please help me out to solve this issue I am attaching the doc which has all details.

vivekpratap2015

Hi All, i am facing the issue in referring the data using the lookup function, I have described the issue in the attachment, if any body can help me with this it would be great. Thanks Vivek

vivekpratap2015

Hi All, I have reference the data using the formula but still the data is not coming, can any body guide me what is the issue and how i can resolve it? Below is the screen shot of Module EMP 02 in Grid view :- in Blue print view Please note :- same formula is referred in car cost , phone cost and medical cost. Below is the EMP03 Module which I referred Please help me what is error i am comitting because of that data is not getting mapped correctly

vivekpratap2015

Sure , Below is the screen shot:-

vivekpratap2015

Hi , I have shared the blue print view for reference . I have done import using grid view . And yes mapping by code only . Pls share if you have any other thoughts

vivekpratap2015

Hi All, I am trying to import the text file(attached) in module SYS08 (below screenshot), even though I have tried to get the data in CSV format and do the same, but still, the data like employee name are appearing in the blueprint view. Can some please suggest how to resolve the issue? SYS08 Module (BluePrint View)

vivekpratap2015

I have tried again to reload the text file /also open the text file in CSV format in the module but the line items still appearing in the blueprint view . Can you suggest how can i resolve this problem

vivekpratap2015

Thanks a lot 🙂

vivekpratap2015

Hello Connections , Can anybody help me for the below query :- I need to update the formulas for the bonus and benefits lines in Module EMP02, using a combination of data from the module EMP03 and module SYS08. When I use the below formula :- IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role, LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0 I am getting the error as Data type mismatch . Can anybody suggest with the correct reference formula? Below is the screen shot for all the modules:- EMP03 ( Grid View) EMP 03 (BluePrint) SYS 08 Blue Print View SYS08 (Grid View) EMP02 (Grid View) EMP02 (Blue Print View)

vivekpratap2015

Thanks for help , yes i figure it out

vivekpratap2015 · ‎12-22-2020

Question:- Level-1 Model Activity -2 I am trying to import and map the SKU volume csv file (Attached) in the Data02 Module, but getting the parameters like parent and code which are not present in the module as well as the CSV file. Below is the screenshot of the module line item (blueprint). Below is the mapping screen to which , I need to input the Parent Data and Code if anybody can guide me that would be great help. Thanks Vivek Singh

About vivekpratap2015

Ending Learning of Anaplan

Certification for Level 2 and The Anaplan Way

Front end and Back end

Re: Date format during CSV import

Re: Date format during CSV import

Re: Level 2 Sprint 2 - Dem01 data uploading wrong...

Re: Import of Saved View

Date format during CSV import

Import of Saved View

Saved Views

Re: Activity - subset line items

Activity - subset line items

List Subset

How To get the Level 1 MB Certificate

Re: Lookup Mapping

Re: Lookup Mapping

Re: Level1: EMP03 Employee Drivers by Role does no...

Lookup Mapping

Data is not able to transfer properly even though ...

Re: Importing the text file

Re: Importing the text file

Importing the text file

Re: Look up Function reference formula

Re: Look up Function reference formula

Look up Function reference formula

Re: i @Re: Level1 MB Activity -2

Level1 MB Activity -2

Re: Importing the text file

Re: Import of Saved View

Re: Import of Saved View

Re: Import of Saved View