About ShivankurSharma

ShivankurSharma

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 !!

ShivankurSharma

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

ShivankurSharma

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.

ShivankurSharma · ‎09-29-2020

@ben_speight No there are no duplicates. Also, when I edit the action and with just a click on Match, all source and Target gets matched. But for that i have edit.

ShivankurSharma · ‎09-29-2020

@MaartenGijbels Please find attached the screenshot as from file and Anaplan. File is a txt file.

ShivankurSharma · ‎09-29-2020

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!!

ShivankurSharma · ‎09-29-2020

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!!

ShivankurSharma · ‎09-24-2020

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.

ShivankurSharma · ‎07-22-2020

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 !!

ShivankurSharma · ‎05-20-2020

@nathan_rudman Created a new Time Module and used the line items from that modules as a filter and post that this issue got fixed. Thank you 🙂

ShivankurSharma · ‎05-20-2020

The list is present in Production model. That is the dimension of the module where that filter needs to be applied. Also the Boolean line item is returning the true when the condition is true but not getting picked in the saved view.

ShivankurSharma · ‎05-20-2020

Hi@nathan_rudman , I have a Selection Module without any dimensions where the end user will add the month he wish to view the data for and export from Anaplan. That line item in selection module is used as a filter in my spoke modules to display the data. Below Boolean formula is created in module to filter data: Selection Module.Month = ITEM(Time) and then that filter is used in the saved view Do I need to change any logic ?

ShivankurSharma · ‎05-20-2020

Hi, I have created a Time filter for a Dashboard and Export view in Dev Model. But when i push that to Production every time the Filter gets crashed in the Saved view, so i am not able to get the desired layout in the Dashboard and Export File. Can you let me know where am i going wrong. Attaching the screenshot from Dev model which says the layout i want in Production and the Layout gets disturbed in Production where the saved view in not keeping the filter. Thanks.

ShivankurSharma · ‎05-13-2020

@MaartenGijbels this didn't worked. Applied the logic in TEST 6. The result is zero, since the name formula converted gave output as #number of the display. In the screenshot Capture 2. Test 6 line item should have 1 as output (i can have boolean line item as well, if the result is correct) Also, added screenshot Capture 3 to see different logic that can be applied. But I am not able to get the desired result. Thanks.

ShivankurSharma · ‎05-13-2020

Hi @MaartenGijbels Thanks for the reply. I can convert it to Name(), but how would i create a logic of comparison of text fields? (where the display name of numbered list is a Text formatted) I need to create a logic where i need to search for all those items matching the text display of numbered list. Lookup will work on the list formatted line. Thanks.

ShivankurSharma · ‎05-13-2020

Hi, The module is Numbered List as a dimension. Requirement: to flag all the members matching the text member of the dimension. Attached the screenshot for reference. Dimension is numbered list with the property as a text (display name) TEST 2 : selection through some formula flag. Requirement is I need a boolean to flag all the member of the list which are identical to the TEST 2. eg. in TEST 2 we have a member U000025. so i need boolean flag for all the members matching U000025. what should be the work around for this? Thanks.

ShivankurSharma · ‎05-06-2020

Hi, Need a help to build a formula, have attached a screenshot for reference. Formula Needs to be build in Revenue Seasonality which need to take the values from Revenue Column and doing the sum of Periods. For Example: Period 1 amounts: 112+ 95. Needs to be clubbed as 207 and shown in Revenue Seasonality against all the Period 1. Similar goes for rest of the periods. Thanks.

ShivankurSharma · ‎05-04-2020

Hi, I need to covert the text field range to a period number, what should be the formula for that? I am getting the text range input as: JAN 2019 - DEC 2019 (in a single text cell) I need an output as period number. 1 for Jan 2019 in one line item and in the second line item 12 for Dec 2019. Thanks for the help 🙂

ShivankurSharma · ‎04-30-2020

Yes, correct headers should remain intact. Even I can add separator in others after discussing with client if he foresee any separator that can be a part. Thanks for checking.

ShivankurSharma · ‎04-30-2020

@sandeep_bk thanks Sandeep. If during the initial creation of the action if we select all the separators and save the process even if the file is not using all the separators in the load. That will be saved in history, and even if next load is with different separator it will get loaded since that was already selected during the creation, correct?

ShivankurSharma · ‎04-30-2020

Hi, I need a clarity on data import through integration. For the first time load the load was set and configured in the Integration process, but what if next time the data load comes in with a different delimiter or separators. Will the Integration load auto detects the load and adjust the import or will it give a error. Thanks.

ShivankurSharma · ‎04-29-2020

Ideally in my last notice, there was no change made to any dimension of the module, even then the saved view filter got crashed.

ShivankurSharma · ‎04-29-2020

Hi, I have seen instances where the filters applied in saved views gets crashed, either as we proceed with the development or while ALM (the production marks the filter as crashed while the Dev Model still have the filter intact, then we have to remove and reapply the same filter and move back to Prod, and then it works). Can you let me know what are the reasons for getting a filter crash, as the complete functionality or the view gets disturbed. Thanks.

ShivankurSharma · ‎04-19-2020

I might need to add a refresh button as well to get the below table updated and then process the export action. But the solution helps, will check if have two buttons help, one to refresh and other to export.

ShivankurSharma · ‎04-17-2020

@Misbah But in that case I need to publish that line item from Module A to the dashboard for the User to select. While there is another table already present in the dashboard which is with Time dimension and user looks to the data in that table and then exports. In your approach the user will first select the Time from dimension and then over look the data and then select the time again in that line item and then exports. Which will be a length process for user to do multiple selections.

ShivankurSharma · ‎04-17-2020

Hi, I am trying to create a process for export on a dashboard, facing few challenges in the data. 1. I created a saved view in a module where time is a dimension (time in Months) 2. Build an export action to run the export where Time is a selector and saved that export action and created a process from that and published to the dashboard 3. End user will be extracting Monthly data from that dashboard through the process. User will select the month from the selector on dashboard and accordingly the data will be refreshed, and if all looks good, user will run the process and have the data in excel. Challenge: When I created the export action from the saved view, lets say the time was selected as Jan'19. and completed other part of creating the process and publishing it to the dashboard. Now if I go to the dashboard and select March'19 and click the process the file again gets export for the month of Jan'19 and not for March'19. while the saved view is in sync and displays March'19. Where do I miss that the action gets in sync with saved view and should give the data per the month selected by the user. Thanks.

ShivankurSharma · ‎04-17-2020

Yes we moved with the same approach. Did a hot fix and added the data again. Thanks for the help.

ShivankurSharma · ‎04-15-2020

Thanks Jason.

ShivankurSharma · ‎04-15-2020

It's true. It will be highly risky.

ShivankurSharma · ‎04-15-2020

Thanks Kavin, Community Members can you confirm is you foresee any issue in this approach or if we can take it as an accepted solution to fix the Production Model.

Online Status	Offline
Date Last Visited	18 hours ago