Platform

Sheethal · ‎06-15-2019

Then create a unique key in your source file or while importing use combination of properties to get the row uniqueness.

Sheethal · ‎06-15-2019

You can load the data directly into the module instead of doing it via list, as the actuals data is multi dimensional and lists cannot store such data. This should solve your first issue. Invalid list item error occurs when you are trying to load data into a list formatted property & the corresponding data is not found in that list.

Sheethal · ‎05-15-2019

Another easier method will be to Import the model itself from the original source. Import option is available in Model Management screen. https://help.anaplan.com/anapedia/Content/Import_and_Export/Import_Models.html

Sheethal · ‎05-15-2019

You can use Copy Branch option to copy Store 1 as a new store & edit the No. of competitors for the new store created. This will reduce the time involved in creating new list item especially when there are lots of properties associated with the list member.

Sheethal · ‎05-14-2019

Mapping seems to be fine. But did you get any errors in the "Result Summary" after the import?

Sheethal · ‎05-14-2019

Please post the screenshot of your import mapping.

Sheethal · ‎05-14-2019

If your question is how to quickly create a new store, based on existing stores, then you can short list the existing stores based on other members suggestions & then you can use the "Copy Branch" action to create a new store which will have same property as the pre-selected store. This will work only if your Store List is a numbered list. You can read more about the Copy function here: https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Actions/Other_Actions/Copy_Branch.html

Sheethal · ‎05-14-2019

I would suggest you to go for a design which involves Numbered List with the combination of Reps, Customer & Product. This will help you to avoid sparsity as not all the Products will be sold to all customers by all Reps and this in turn will help you to keep the model size at optimum level.

Sheethal · ‎05-14-2019

He meant it while importing the file into the Region list. But for this to work, you should already have the Region List created with Geo as the parent & Geo list should have been already populated with its list members like NOAM, EMEA, APJ, etc.

Sheethal · ‎02-28-2019

From the screen shot, it looks like you are searching for Export option after you Click "Edit" option (Designer Mode). But, to use the export option you should not get into the Edit mode or Designer Mode. Instead, click the down arrow given in the Dashboard Tab (appears only when you hover your mouse pointer over the tab) & you can see Export option as shown below: Please note that this is not browser issue. It works in all browsers.

Sheethal · ‎02-20-2019

Hi, Create a new numbered list with the combination of cost centre, GL and time. Use this list (in a new module) to pull data from other modules. Export the data from this new module. This should solve your sparsity issue. Sheethal N

Sheethal · ‎02-20-2019

Everything related to user access like adding and deleting users, role assignment to users, selective access, etc are done at model level irrespective of whether it is dev or deployed model. Whereas, other role based access controls are controlled in dev model. Regards, Sheethal N

Sheethal · ‎01-15-2019

Thank you David!

Sheethal · ‎01-11-2019

I have 2 questions here: 1. It is mentioned here that Anaplan remembers the sequence of adding the lists. Is there any specific reason / advantage to save this sequence? 2. Isn't it possible for Anaplan to sort this based on the order provided in General List (instead of asking modeller to manually clicking the ellipsis & then click OK)? In fact, I observed that Anaplan itself sorts the lists based on order of General List when I click ellipsis & select the lists under Blueprint --> Applies to.

Sheethal · ‎12-30-2018

Once the count of RT's exceed 500, the loading time of the RT's is too long (almost 1 to 1.5 minutes). Probably the loading time can be reduced by restricting the number of rows that are being loaded on the first go. Moreover, the older RT's are not of much use for day-to-day use.

Sheethal · ‎10-19-2018

This will help in changing Total Positions alone, within dashboard itself, without applying the sorting option. Currently to the Total Positions without applying Sort, one has to apply these changes in module & then re-publish it to the dashboard which take significant amount of time.

Sheethal · ‎09-16-2018

Hi, You can easily get the Ok button, in any screen, by just zooming out the browser screen. Hope this helps. Sheethal N

Sheethal · ‎09-16-2018

Hi, As of now, I don't think there is a way to do this without adding an additional line item. Sheethal N

Sheethal · ‎09-16-2018

Hi, Try to set up your View in source module in such manner that there are no duplicate rows. This might solve your issue. Sheethal N

Sheethal · ‎06-24-2018

Hi, In the initial release, there was no functionality built in Anaplan around Data Tags. However, in the latest Platform Update, the functionality has been updated & search based on Data Tags has been enabled. You can find more details here.

Sheethal · ‎06-24-2018

Instead of using Name or Code to import, you can try importing through "Combination of Properties". That should help in the given secnario.

Sheethal · ‎06-24-2018

Hi, I would be easier to identify the issue if there is some screenshot/sample data.

Sheethal · ‎06-05-2018

Hi Mark, Is there any tool being built which can indicate modules which has high sparsity. This should help saving time by reducing the analysis time in each modules. Thanks, Sheethal N

Sheethal · ‎06-03-2018

Hi Peter, Even for modules with 4 dimensions, the procedure remains same as explained by you for the case of module with 3 dimension. In other words, the last dimension which is left at the top as page selector will be automatically pivoted by Anaplan as a column in the import mapping screen. Hope this solves your question. If not, let me know, so that I can show it with screen shots.

Sheethal · ‎05-06-2018

Generally, I use Source Models when a model has been moved from one workspace to another workspace to change the source model without recreating a new import process. In your example, if you move the Model 1 from WS1 to WS3 & named it as Model 3, then you can use Source Models to change the source of all import processes from WS1/Model 1 to WS3/Model 3. This avoids recreating all the import processes again by remapping the source model. This page gives detailed description of IDS.

Sheethal · ‎05-06-2018

From your question I understand that you want to see the data imported from SQL table in Anaplan & you are trying to do this through "Import Data Sources". I assume you want to see the data in Anaplan as a review step, before it is pushed to destination module. My suggestion would be, instead of trying to see the data through "Import D ata Sources", you can import the data to a temporary module and review the data there. And after review you can push the data from temporary module to destination module.

Sheethal · ‎03-30-2018

Glad that it worked for you. Currently there are 4 modes in Anaplan (Standard, Deployed, Locked & Archived). Each of these modes are mutually exclusive i.e., a model can be assigned to only one of these modes. So when you Archive a model, it moves out of Deployed mode. Here, I understand that your worry is that once you take the model out of archive, it might not be compatible for Sync. My experience is that, if you change the model from Archived to Deployed mode directly, then it must always be compatible for Sync because there was no structural change in the model. Regards, Sheethal N

Sheethal · ‎03-25-2018

If I have understood the question correctly, you need not change an archived model to Standard mode & then to Deployed mode in order to sync the changes. While taking the model out of archive, directly you can change the mode to Deployed & check whether it is compatible for Sync. Regards, Sheethal N

Sheethal · ‎03-07-2018

Hi Brendan, I recently learned that this is done for the purpose of accommodating the new feature of User Personal Saved Dashboards View. Basically, if any change is made before going into edit mode, it will be considered as Personal Saved View & if change is made in Dashboard Designer & saved (accessible only by Admins) then its a permanent change in the dashboard . Regards, Sheethal N

Sheethal · ‎02-21-2018

Hi, Add combination of Emp ID & Cost Centre (with a separator) as Code for the Employee List (eg: 1245-78643). Later you can import your Actual using this combination code which can be recreated in excel file. To load the code in Anaplan, easiest way would be to export the Anaplan Employee list to excel with Anaplan # code, add new column for code using Concatenate formula in excel. Then, import the code created in excel file into Anaplan using # code.

Platform

Academy

Master Anaplanner

Programs

About Sheethal