About Sheethal

Sheethal · ‎05-14-2020

Seems like this is a issue in the cell storing the mail id. Please elaborate how is the mail id fed into Anaplan? Is it data entry or imported data? Also, adding screenshots will help in understanding the exact issue.

Sheethal · ‎05-13-2020

If you are fine to show the outcome in text, you can try the following method. This will be a easier method if the data is only for display purpose. Create a mapping list to map the month in numeric (3) to month in words (Mar) as shown in the screenshot. Then you can use "CODE(FINDITEM(Mapping, RIGHT(Data, 1))) & " " & MID(Data, 3, 2)" formula to get the output in text format.

Sheethal · ‎05-12-2020

Please check whether the following works: jdbc.connect.url=jdbc:sqlserver://[servername]:1433/[databasename]

Sheethal · ‎05-12-2020

This will be a very useful feature. Looking forward for this. Any visibility around the timeline of release?

Sheethal · ‎05-12-2020

Congrats @Misbah! Great to hear this!

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-15-2019

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

Sheethal · ‎05-15-2019

Please post the screenshot of your import mapping.

Sheethal · ‎05-15-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.