About VIGNESH.M

Hi @Sravan_Kumar ,   Production List, You can add new records in the list, change parent, change code, make changes in the properties and include/remove the records from the subset in the deployed model   Not Production List. You cannot make any changes. If you want to make any change, apply the change in the Dev model and promote it to production,     Thanks, Vignesh M ... View more

Hi @Sravan_Kumar,   Use parent function, this is the best way to achieve the result instead of doing the import.   Parent L3 List = PARENT(PARENT(ITEM('List'))) Parent Value = Gross[lookup:Parent L3 List]   Do you have a particular reason for not using parent function? Let us know will find another option to get this result.   Regards, Vignesh M     ... View more

Hi @paolovm @Harsha_D    We have duplicates in the Time period, this is causing the problem.    #1. I tried to load this file without making any changes and seeing the system taking time as a flat list, also highlighting the duplicates #2. Removed the duplicates, the system is recognizing the Time Period and I am able to load the month values successfully, year values are getting ignored as expected. Here is a simple month example, #1. With unique months, am seeing the right mapping. #2. With duplicate months, the system showing the duplicates.   When we have duplicates in the Time Dimension, the system cannot identify the one to one mapping and we need to manually do the mapping.   Thanks, Vignesh M             ... View more

Hi, It seems your module contains 1 list(Product code) and Line items, if yes pls try the below solutions.   #1. Only all the line items are number format and the list has Top Level Item, then apply the filter based on the Top-level item to see only the non zero rows. After Filter #2. if you want to o nly show cells where the line item and list members are not zero, then we need to  change the view as shown below and apply the non zero filter.   Regards, Vignesh M ... View more

Hi,   Am not sure about the ask here, let me say what I understood, 1. Create a saved view and apply the filter. 2. Keep your filter line items in SYS module and write the logic in the way you want. Every new data will get appended? - Yes, List items added in the future will be appended automatically in the saved view.        ~Vignesh M ... View more

Hi,   You mean the data flow from Mod 1 to Mod2, then Mod 2 to Mod 3.. So on... Are you importing the data from Mod 1-2, 2-3,.. 5-6?. If yes then Create a Process to achieve the sequential run, in that process include all the 5 actions sequentially. Anapedia Process link, check this  Regards, Vignesh M  ... View more

Hi,   You need to sum by the dimension which presents in the Target module, so you need to sum by Product family, not by Product and sum by Country made in. Check, SUM Function in Anapedia, Link  Target Module.Value = Source Module.Value[sum: Dim A, sum: Dim B]   ~Vignesh M ... View more

Hi,   Create a new line item in text format, Use NAME function to convert list format to text format.   Month Alpha Text  = NAME(Month Alpha)     ~Vignesh M ... View more

Hi @RobinSilk ,   If you want to bring the last month of the current year in a non-time dimensional module, try this. You can use this Last month line item for the comparison.   ~Vignesh M ... View more

Hi @HendrikDeCuyper ,   Try this,   I hope this gives the result you are expecting.   ~Vignesh M ... View more

Hi @Ajinkya    Try this   Step 1: Create a separate Line Item(LOCK) for Locking the List items from deletion             In my example, Module name - Account Deletion Step 2:  Publish this LOCK Line Item to a dashboard and give access to Role A and Role B to this dashboard, so Role C/D cannot access this dashboard and delete the accounts. Step 3: Create Read/Write Access drivers as shown in the module Step 4: Use this read/write access driver in the Delete line item, so the locked account won't be available for the deletion for any user. Step 5: Create a Delete action based on the Delete Line item and publish it your dashboard Step 6: Create another Delete action based on the LOCK line item and publish it in the Lock Account dashboard.   In this way, locked accounts cannot be deleted except the user have access to the LOCK Account dashboard.   I hope this will solve your issue   Thanks, Vignesh M    ... View more

hi @litterbarbie ,   Yes, we don't have detailed information about the export from which saved view the export is created, only we can see from which module the export is taken. Though we create the export from the saved view, the action tab will show the source as the module name, not the saved view name. Whenever the export is created, add the export source view information in the Note section for the future ref.  I think you need to connect with the developer to get more information about the exports.   ~Vignesh M     ... View more