Importing and Exporting Data

Mapping problem
I am not getting how to do mapping in SYS05 region details
Export with combined dimensions.
Hi all, I have a ask to run a export from anaplan module, currently the export looks like this, but it should look something like the image below: First question: is it even feasible Second question: if it is, what could be the possible workaround for it. Thanks and regars.
1.4.3.2 Import Data & Add Formula
Trying to import the Product and Distribution Center data into the SYS12 SKU Details module. But the SKU file has Code SKU Distr Ctre and Product Code but not Product. Is there a step I am missing?
Level 1 MB, Lesson 7, Number formatting while import data
Hi, While importing data to the Module SYS08 Employee Details I ended up with Commission % 15 instead of 0.15 as in the source file The format of this Line Item below How can I fix this?
level 1 EXAM Activity 5
Hi Guys, I am stuck on Activity 5 for Hours now. I added the roles list and for top level gave it All ROLES. I kept this list under other lists. further more the FORMULA I wrote was IF Employed? THEN 'EMP03 Employee Drivers by Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee…
level 1 exam
Hi, In activity 4 it says to to import to emp03......and underneat as a note:the data file contains (Monthly) not yearly, does it mean once you have imported the file, you are suppose to change the time scale to monthly in EMP03 MODULE. when I do that it shows me Zeros and when i Dont it gives me some sort of numbers…
Import date enclosed in double quotation
Hi, I want to import csv file. But the data was enclosed by double quotation in text file. Are there any problems when I import this type of csv file?
Custom Preconfigured Messages in Notifications
Hi, Is there a possible way to add custom preconfigured message derived from a line item in Anaplan and what is the process for the same. Regards, Aakash Sachdeva
Error on activity 1.3.10.2
Hi Team, I keep getting error, Will like you to point me in the right direction. I have followed a few suggestions in the community as regards manually populating the list. yet no result. Kindly assist
activity 1.3.4.2
Hi Team, Any idea why after importing, the code column is not populating even with the formular Or does it have to be manually inserted, I realized this activity is preventing me from completing activity 1.3.10.2.
Set .xlsx as the default format when extracting data from Anaplan
It is great that now we are able to export data in xlsx format. Thanks Anaplan Team! It would be helpful to have xlsx as the default format when manually exporting data from the system. Current default format is .xls.
Automate current date import using Power Automate
As you all know, Anaplan cannot display the current time from a function, so it needs to be imported into a module by an import action. As described here it can be done via Python: Import and automate current date import to Anaplan. I would like to to show you an easier way of doing it when your organization has access to…
Loading data from another module: Data is ignored when loading to Version
I have one module called DAT01, which contains employee census data. There are two others modules called DAT02a and DAT02b, which are identical with the exception that DAT02b applies to all versions whereas DAT02a does not apply to any versions. DAT01 only has one dimension, which is a unique ID containing a combination of…
10.2.2 Activity: Import Data into Non Employee Expenses Module
le résultat n'est pas le même la première photo est la mienne la deuxième est le résultat du cours
Run process in anaplan from informatica
Is it possible to connect to a process as a target in informatica cloud(hyper connect) and run the process instead of individual actions?
1 4 3 2 Import Data and Add Formula
I have reached to this lesson and have been unable to import the csv file 'SKUs.csv) into SYS12 SKU Details module. Can someone advise if I should have time series as the column in the SYS12 module and should I see Time as the target (which in my opinion, should not see Time as source)? If they should not be here, how…
What is Managed By functionality?
Change the file name everytime the user Export
Hi, Community I want to change the export name everytime I export The definition of the name whould be "Module name and Time the user selected" or "Setting name when I create the export and Time the user selected I look for the way to do, but I couldn't find it. I really appreciated if you help Kind Regard
Employee detials
Hi Team, Can you please provide me with download to the link for Employee+Detials+By +Role csv from Level 1 exam. My one was opened and I would like to get it to practice before I have another attempt. thanks Regards, Aye
Import Shipping Expenses into OTH01 Module
Hi, I am trying to import shipping expenses into OTH01 Module but I am doing some wrongs, where? Here are my screenshots: Yes, I see that the capacity doesn't match and tried hide it but it doesn't work still. Please guide me! Mark
2.3.9 Activity: Historic Volumes to Baseline Forecast
Hi, Some values should be in 'Offset Volumes for 1st Forecast Year' line, but nothing! Where am I doing wrong? Thanks, Mark
L2 Model Building - Conclusion Exam: Upload Supply Chain Model History
Hi, i'm trying to complete the L2 Model Building Exam and it is required to upload the supply chain model history. I have issue since i transferred my model to another workspace and it makes the history renew on the new workspace. How could i solve this? Because i can't upload 2 files in the fields. Thanks.
12.4.2
Create saved view for country margin but the problem is now I have notice that REV01, 02, & 03 Modules don't have any data for FY21 so the model don't look the same when I check my work, any suggestions?
Drill Through/Link External Source Mapping to a given line item
Be able to list or link to a URL the original source information when there is no deeper level. EG. In a source data module, if drill down is completed the admin has the ability to attach a URL to the source material (if it is an extract/table that was pulled from, view, etc.) and if it is entered having the view/field…
L1 Exam Activity 4 Import Error
I am getting error codes when importing to the EMP03 and SYS08 modules as shown in the screenshots. Can anyone point me in the direction of where I went wrong and/or how to fix it?
Change Source of a Model from Data Hub Dev to Data Hub Prod
Hi All, I am working in a User Story of a Dev Model to change the sources of data from Data Hub Dev to Data Hub Prod. The model In Dev I am working by now has already around 70 actions that are pointing different views of Data Hub Dev as a source of data. In my analysis I found that one way to do the change is: * Go to the…
Issue in Tabular Multiple Column Export Format
Hi All, I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv)…
Is Summary not dynamic?
Hi, I have explained everything in the below screenprint. Please share your views on how to handle this case.. Note: The module is data module where all the data is imported through csv file.
2.4.7.1 Create Demand Forecast Grid UX saved view_unable to apply conditional formatting
Hi, I am not able apply conditional formatting to get the result. Could anyone please guide me. required output - Applied conditional formatting - Got below output - Thank you,
How to declare a variable in denodo?
There is a question related to this topic but is not the same that I am going to ask, I need to do something similar as we do in SQL but this time in Denodo. This is in SQL: DECLARE @curr varchar (10); SET @curr = 'USD; SELECT Country, Currency FROM Currencies WHERE Currency = @curr; I have tried something like this in…

Importing and Exporting Data

Discussion List