About ShivankurSharma

Hi Anaplanners,   We got a requirement where client wants to automate a daily report extract from the Anaplan to the source system for the details of Users and the Role in anaplan model. Assuming no ETL is been setup, what could be the best possible way of implementing this. Is any batch script or Postman helpful in implementing this? This needs to be daily or weekly activity so we might need to add a scheduler as well.   Thanks in advance for the help !!   Regards, Shivankur ... View more

Hi Team,   Few observations I have noticed will working on the models with New Modelling Experience:   1. We can't move the tabs in the order we want, like we were able to do in the classic view. Rearranging the Modules which are open. 2. Formula expansion I guess many of the Anaplanners have already raised that we can expand that in the Production Model and if in the Development model if we expand the formula goes to the edit mode and even if we need to just review the formula. 3. If we open a module apply some filter to the module, later we open few more models, and if we open back the first model then the all the filters are cleared.   Regards, Shivankur ... View more

Hi Team,   Recently we encountered an issue where we were importing data to a list, where unique identifier was to be added to the code and we find few records saying as invalid code.   Example: any unique identifier with underscore "_" was at the start or the end was giving error of being invalid code. Can we have these as accepted codes? Since in the vendor tools for the performance the unique identifier is created as mix of alphabets and these special characters, and if the character is in the middle it get's imported to the list, but gives an error where it is at the start or the end.   Can we have these fixed in the future releases.   Thanks, Shivankur  ... View more

Hi Team,   Is it must to have at least one Anaplan User added to the workspace? [my understanding was that, we should have at least one user from the vendor so that if down the line is by mistake all models get deleted, that user ID might help to restore the workspace or any of such cases]   Regards, Shivankur ... View more

Hi Anaplanners,   In my client I am noticing the Time to open/load a page is much longer verses opening a dashboard in the classic view. If anyone have experienced the same and knows the workaround to speed up the New UX app, can you suggest the solution.   Thanks, Shivankur ... View more

It would be a great help for the user, if he is able to export/or copy the grid from the drill down, for example if we drill down on the cell in new UX we get all the values that contributes to the calculation, and if the count of the drill down goes over 100 values it gets difficult to analyze the data, neither we can copy the data. It would be helpful if the user can get that extract to see what numbers contribute to that value at the backend.   Thanks, Shivankur ... View more

Hi Anaplan,   It would be great if we can get a functionality to check from the model as to which all New UX applications the Model is linked to. As if we are working on a MSP model, it gets really difficult to track as the model is linked to which all New UX Apps.   Thanks, Shivankur  ... View more

Hi Anaplanner's,   Need a help on a calculation:   Have a module where Time is not a dimension, we have system created list to be used as year, and there is a line item where we need to get the ending balance as the opening balance in another line, which formula can help us attain that?   In the below screenshot, we need to get the numbers of last line as the opening of next year.   Thank you !!     ... View more

Hi Team,   We are looking forward for a Data Integration between Taland and Anaplan, would like to seek advice if anyone has done this integration and any information that would be helpful before we start implementing the same.   Regards, Shivankur ... View more

Hi,   Looking for a solution to get the effective date for working on a location(Result(output Required)).   Employee 1 1. Got hired on 15th March so output to be 15th March for the period March. 2. Moved to US location in May and stayed there for 3 months, for July period the result to be 31st May(period since working at that location). 3. Moved back to India in August, and been working from same location thereafter, so every period return once generated should give the result as 31st Aug (period since working at that location) 4. and this may go for multiple location change   How can we formulate this to be working   Sample: Date(Period end return) Employee Name Work Country Effective Start Date Result (output required) 31-03-2020 Employee 1 India 15-03-2020 15-03-2020 30-04-2020 Employee 1 India 15-03-2020   31-05-2020 Employee 1 US 15-03-2020   30-06-2020 Employee 1 US 15-03-2020   31-07-2020 Employee 1 US 15-03-2020 31-05-2020 31-08-2020 Employee 1 India 15-03-2020   30-09-2020 Employee 1 India 15-03-2020   31-10-2020 Employee 1 India 15-03-2020   30-11-2020 Employee 1 India 15-03-2020   31-12-2020 Employee 1 India 15-03-2020 31-08-2020     THANK YOU !! ... View more

Hi Anaplanner's,   I am trying to export the history log via New UX. The action gets processed but the file is not extracted. Same process when executed from Model is a success and i get the file, did anyone faced the same and have a work around?   Thanks, Shivankur ... View more

When the models are migrated from a tenant to another tenant (we are talking about like 6+Models). During the migration it should also allow the Apps related to those migration be moved to the new tenant. If only the models are moved and the client is scheduled to work from New UX and the Apps doesn't move, it brings back lot of effort again building the app from scratch.   Thanks. ... View more

Hi Anaplanners,   Can you please guide me which Text Encoding should be used while import, when the data set have some data in Chinese Language.   Thank you!! ... View more

Hi Anaplanners,   There is something I need an assistance. I have created an action to import the data, and the Module is multi-dimensioned. During the creation of the action one of the dimension "Match on Names or Codes" is disabled, which means by default we have to match it manually. Can anyone please let me know why the option is disabled? Have attached the screenshot. The dimension is mapped to be "Column Headers".   @akhil.kohli    Thanks You!!     ... View more

Hi Anaplanners,   Is there a way by which I can get log history of records, when data is loaded through Integration. Ideally, the history log in Anaplan can just let us know for the number of records which gets loaded, not the one which were ignored. Is there a way to find that through Anaplan?    Ideally if we manually load a file we get to see the number of records Created/Updated or Ignored, something like this I need to show.   I know we don't have this in Anaplan, just checking out-loud if anyone got in same situation and did some workaround.   Thanks. ... View more

Hi Anaplanners,   Need to have some understanding on the Generic Email id that can be used for Data Integration to Anaplan Models.   We are planning to use the system generated generic account for data integration to Anaplan Model from 3rd party tool, as per Anaplan policies that password needs to be reset every 90 days, will that generic email id will require a password reset? and if yes, is there a way we can automate so that passwords are automatically reset in time, and this doesn't impact any data from from source to Anaplan Model? As this generic email id will just be used for Data Integration.   Thank you !! ... View more