About Anilkumarch

Anilkumarch · ‎04-14-2021

Hi @jjconn13 Use the FINDITEM and find the roles that are old and delete those from the list using selective deletion. Then update the list with new roles.

Anilkumarch · ‎03-03-2021

There should an option to add the dimension header that are placed in rows while exporting by end user using the export option is grid. For example if I am using the SKU list as the row dimension and user is trying to export the data from the grid published in pages, there should be an option to get the SKU as the header for 1st column in the export file as SKU. Current Expected export file headers:

Anilkumarch · ‎02-15-2021

Yes, it would be a great future if we are able to capture start and end time of action. In this way we can easily track how much time does each action is taking to get completed.

Anilkumarch · ‎12-16-2020

After new home page view we are not able to see all the archived model which was possible in old home page. It is tough to keep track or remember the archived models workspace, so it is better to have a mode filter(similar to deployed/standard/locked modes) to view archived models without going to workspace of the models.

Anilkumarch · ‎12-09-2020

@sujeethkumar Create a subset in the list and update it using the selection in Step 1. Use the subset as the format of the line items.

Anilkumarch · ‎12-01-2020

Not required. Looks good

Anilkumarch · ‎12-01-2020

Product Code and Product Family details needs to populated using formula. Product code = Code(Item(Product list)) and Product Family = Parent(Item(Product List))

Anilkumarch · ‎11-30-2020

@JosephA looks you are mapping size to product list in import action mapping. You need to map product code column with product list and size in line item(by selecting fixed line item).

Anilkumarch · ‎11-30-2020

@JosephA i see you have places the products in pages so you are seeing only one product. Go to the pivot option and keep the products in rows and line items in columns so that you can view all the data.

Anilkumarch · ‎11-30-2020

@RajeshPrabhu please see my below comments New prod for each sprint may not be accepted by business . If there is no other way, I guess the only option is to propose business to hold development until patches are deployed in production. Yes, the only way is hold development. If possible move the fix along with next sprint if it not show stopper. The next point, just making more clear. If single DEV :- 1. Create the revision tag for current build and capture the history ID. 2. Roll back DEV to previous sprint and apply the fix. 3. Create the revision tag for HOT FIX and capture the history ID for future use. 4. Roll back DEV to future using history ID(point 1) so that current development can continue. 5. Take a PROD copy(HOT FIX #Nov30 UAT) or if already there is UAT model you can use that. 6. Sync the fix with UAT model. 7. Perform UAT.(need to repeat from step 1 to 6 if any fixes are required during UAT) 8. Sync with fix with PROD model. 9. Archive UAT model if not required.

Anilkumarch · ‎11-30-2020

Hi @RajeshPrabhu below are my comments. >> We are essentially holding ongoing sprint development until prod issue hot fix patch is released. Will it not impact sprint timeline given we never know how long it would take for a hot fix change to close. Is it advisable ? Yes, with this approach the current sprint build activity will be hold. If assumed that hot fix is going to take more time then better take the hot fix for next release if possible. Else after each sprint you need to take DEV copy and use it for hot fix so that current sprint build will not be impacted. But with this approach you need to create a new PROD of each sprint as you will not be able to sync the existing PROD model with new sprint changes. >>If there is an ongoing spring UAT then we have to hold that as well. Follow the same process as development. Is that a right understanding? You need to maintain different UAT models for each sprint. Keep it in archived state and unarchive it when required, so that you can save space when the older UAT models are not in use. Else take a copy of PROD and perform UAT for hot fix. >> Would it not override hot fix changes when we put back ongoing sprint build ? Yes, it will. You need redo the hot fix changes after roll back in current sprint so that when current sprint went live there will be any issues.

Anilkumarch · ‎11-30-2020

Hi @RajeshPrabhu you need can achieve this by the following way. - Capture the latest "Revision Tag" and "History ID" of previous Sprint/Release before you start the build of next sprint/release. - If there is hot fix required and you are in middle of next sprint build then you need to send a email notification to your team to inform that the DEV model is going to be roll back to past for a hot fix. This is to avoid any changes during roll back. - Capture(on going Build) the latest "Revision Tag" and "History ID" of the on going build and Roll back the model to the state where previous sprint/release latest RT is in using the history ID captured. - After roll back do the hot fix and then create a revision tag sync it with your UAT model. - Capture(Hot fix) the "Revision Tag" and "History ID" for the future use if there might be any hot fix later. - Roll back the model to the state of current(on going build) using the history ID captured for it. In this with out moving the on going build to UAT and PROD models you can do the hot fix.

Anilkumarch · ‎11-30-2020

@jenniferhallce8995 Just delete the line items(created with inventory numbers) that are created and load with selecting fixed line item for beginning inventory column. In you mapping screenshot you mapped beginning inventory instead you mention as "fixed line item", after that in you right hand side selection keep the same for "Data values from" field. This make you module and action looks good.

Anilkumarch · ‎11-27-2020

@Aniruddha it is not achievable using same list. You need to create another list with List A as parent and add the PY, PPY as childs of each item of AOP V1, AOP V2 ...so on. Now use the new list in the module. Is see only this is the way you can achieve this if you want use page selector. Else use line item selection and filter as mentioned previously.

Anilkumarch · ‎11-27-2020

Hi @johan.marketoft as of now Anaplan do not such functionality of connecting a page with 2 different models. You can publish 2 different modules of same model in one page.

Anilkumarch · ‎11-27-2020

@Aniruddha Could you please provide more details on the relation between the list A and list B. Until if the PY & PPY are the child of V1,V2,etc in list B and list A is parent of list B, then only you can achieve this using page selector.

Anilkumarch · ‎11-27-2020

Hi @Aniruddha as the list A and list B are independent list you cannot directly sync the list B with the selection of list A. If the list A and list B are hierarchy lists then it is possible. You can achieve this my creating a line item with list A format and publish it in the dashboard. Apply the filter on the grid(list B) based on the selection in line item(list A) so that you can only show items as mentioned in your statement.

Anilkumarch · ‎11-26-2020

Hi @RajeshPrabhu if Region is numbered list then you can "Create" action to add items to the "Region" list. Once the items are added then create a module with "Region" list as dimension and add the line items that you mentioned in the module so that admin will update the data in module. Use formula for pulling data from module to "Region" list. If the list is not numbered list then follow the same process that you mentioned but only change you need to add is you need to create dummy list with one item and use that list as the dimension in the module that you created.

Anilkumarch · ‎11-25-2020

Hi @Jerin_KJ need more details on how you are calculating the balance number of days. If balance number of days is equal to "End date - Start date +1" then create a line item to capture the days using "End date - Start date +1" and see if the days are exceeding balance number of days. Create CF line item and say if the "End date - Start date +1" days are exceeding the balance number of days then give 10 else 0. Use this for applying CF on End date line item.

Anilkumarch · ‎11-23-2020

Similar to adding modules/lists, there should be a way to add action into the process by selecting the action that are already present in the process and be able to add before/after the selected action. As the action will be added at the bottom on the process by default it is time taking process for moving action to the required position when there are many actions in process.

Anilkumarch · ‎11-23-2020

This will be helpful and reduce the time to to select the views .

Anilkumarch · ‎11-21-2020

Agree....it is easy future to disabled users from all the workspaces from single point.

Anilkumarch · ‎11-21-2020

I agree with this, copy down and across is the easy option to copy data in the modules.

Anilkumarch · ‎11-20-2020

@CommunityMember113484 if your target line item dimension is Year than automatically you get the sum if summary is enabled for source line item. Let us connect and discuss if you still not able to get it.

Anilkumarch · ‎11-20-2020

Hi @CommunityMember113484 Write a condition in "Loan Amount if maturing" line item saying if mature year is equal to time scale year then take the mature value else keep zero. Then you will get sum values of loan amount which are maturing that year at year dimension.

Anilkumarch · ‎11-20-2020

Hi @CommunityMember113484 Create a new line item and write a formula "IF Text Format Item(line item) = Last non blank item(line item) THEN get period value. ELSE Blank

Anilkumarch · ‎11-20-2020

Hi @Jerin_KJ , If you can provide the details of relation between the dimensions used in grids then i can help. Without knowing the relation between the dimensions it is difficult.

Anilkumarch · ‎11-20-2020

Hi @CommunityMember113484 create a line item and capture the quater value if it is maturing then create another line item with time dimension as year and write a formula to pull data from line item where you are storing loan amount if maturing. You need to enable summary for line item of laon amount if maturing. Below screenshot for ref.

Anilkumarch · ‎11-20-2020

Is the all 10 properties will be vary for each record. I mean you only make a unique record if you combine 10 properties? If yes, then i think there is no option than using 10 properties to import by combination of properties. If No, then try to find the unique key properties and use those properties to form unique key. This will improve the performance of import than using all 10 properties.

Anilkumarch · ‎11-20-2020

Hi @mgb14 can you give more details on what is the issue you are facing