-
Integration of Data from Anaplan to Power BI.
Hello All , My source is Anaplan data , i extract the data in CSV and do run a R-script for unpivoting the columns and then connect the updated CSV file to Power BI. Now , i have requirement to connect the data directly from Anaplan to Power BI. Any Suggestions ? Thanks for the help in Advance. 😄
-
Anaplan Connect Export script
Hi, I am getting error when I use the following script for exporting @Echo off set AnaplanUser="XXX" set WorkspaceId="XXX" set ModelId="XXX" set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "ABC" -execute -get "D:\ABC.csv" rem *** End of settings - Do not edit below this line ***…
-
Level 3 Sprint 1
Hey, Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file for now. Can anyone help me to identify if the mappings given in the image are correct? Unfortunately, I am getting the error "Invalid line item…
-
Lesson 7 importing employees
please help me to correct the format exactly with anaplan screenshot given in leaning centers for example i need SHALA ENGLE in first column
-
Level 1 Model Building import data for Non employee model
Hi all, please help me in importing the data of non employee expense
-
Commission % on employees details module
I have imported the data into the employees details module. everything is correct however the commission % is not showing correctly. The correct format is 0.15% and the imported format is showing as 15.00% what am i doing wrong? screenshot attached.
-
Unique ID longer than 60 chars
Hi, As per Anaplan's best practice in loading data, we are trying to create unique ID, however, since the original codes are very long, the unique IDs we are trying to create by concatenating the codes of the different dimensions are longer than 60 characters long. For example, we have Cost Center, Measure, FinGeo etc, and…
-
Anaplan Connect Error Messages
Hi All, We have a number of Anaplan Connect scripts with certificate authentication, let's say 10, as part of a daily job. Somehow, jobs # 1-3 were successful, # 4-6 were failed, and # 7-10 were successful again. I wonder if the those failed ones were due to connection issue during that point in time as prior and…
-
Possibility for Data encryption during export
hi Community! Our business users would like to protect exports from anaplan with a password. So that, any time when they export a file with confidential information, it could not be accessed people without authorization. Do you have any idea how this can be done in anaplan or using other technologies in addition to…
-
Applying one Pivot Filter to multiple cloned connections with the Excel Addin
I have one Excel workbook with multiple worksheets and I want to apply one Pivot value filter (e.g. Time - May 21) to all the worksheets. Rather than updating each individual worksheet "Time Value".... When I used reference this value across worksheets it is blown away after the refresh.
-
'cmd' is not recognized as an internal or external command - while importing
Hi, I am trying to use a bat script to import in a list. When I manually enter username and password in the script, it works fine but when I change it to read it from a .txt file, it shows the error: "'cmd' is not recognized as an internal or external command, operable program or batch file.". It's not like there is an…
-
level 1 Model Building (lesson 7)
How to map data for module employees? import process will populate the module with Name, Country, Start Date, Leave Date, Current Salary, and Commission % data. also need to set header and first row.
-
Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…
-
issue loading data from views with page selectors
Hi, I am running into issues when I try to import data from views with page selectors - when I save a view that has selectors and then set up the import elsewhere, the view looks completely different, and can lead to unpredictable results. There are workaround available, but this seems like an problem. Thanks Ethan
-
Importing data from .csv files
Can you please explain how should I import the .csv File at the mapping stage? How do i know what options to select under the SOURCE dropdown? what logic it uses so that the data can be displayed as desired in the model. I am trying to import the subset file however it is a bit confusing as to what i should select in…
-
Excel Extract in mail attachment
Hi, I want to attach Saved view as a mail attachment and send it to clients. We dont want to show other module data to them so excel add-in doesn't work. So do we have any solution for that. Regards, Ajinkya S
-
Can't upload a new import data source for part of actions
When I tried to upload a new import data source file(.cvs file) for a action, I find it is void, no any error message, It looks like everything is working, but when I want to edit the action after upload new source file, still prompt "The uploaded file is no longer available; please upload the file again". And I found it…
-
Exporting multiple modules using API takes too much time
Hello Community, I'm trying to export multiple modules (7 modules) using the API. but it takes up to 4 hours to do that. The size of the biggest module is about 600Mo. My questions are the following : Is there way to do a full export of the Anaplan modules (like creating a dump) ? Is there some possibilities to accelerate…
-
Export Formats
Hi, Just wanted to know that while exporting from the New UX is there any way in which the pdf export format be obtained as an A3 page. Currently the export is landscape oriented by default so is there any way out that this can be changed. Thanks in advance!
-
Confused as to why this import is not mapping automatically
I am trying to build a process where end users can upload values into an input module. Ideally they can export out the template from Anaplan and then update the values and then import the updated csv into the Module. However when I am trying to create the import action the automatic mapping for the field Sales Plan Region…