About Misbah

@SSUS Talk to academy@anplan.com they should be able to help you Misbah Miz Logix ... View more

@SUDHAMANOHARG I believe there is a way to retrieve cell data with the help of Anaplan Transactional APIs using Pageination of selectors. Misbah Miz Logix ... View more

@SUDHAMANOHARG With Anaplan Transactional APIs you will be able to get it in json format Misbah Miz Logix ... View more

@SUDHAMANOHARG Views are like subsets of the module. You can create as many views as you want, they don't take any space. You create views when 1. Underlying module is to be used as a source of an import 2. View is to be published on classic dashboard and it is to be used many a times on UX. 3. You need specific column widths on dashboards. etc. Hope that helps Misbah Miz Logix ... View more

@143kishornaidu  Could you please share the screenshot of your query?   Misbah Miz Logix ... View more

@hamzaghazilabassi    See if this helps Convert Values from a 445 Calendar to a Normal, Mo... - Anaplan Community   Misbah Miz Logix     ... View more

@AshutoshR    No, you can not. Codes are supposed to be fed into the list and not expected out of the list.   Hope that helps, Misbah Miz Logix ... View more

@ManuelSampaio    If you right click on the grid card you will get an option Save Card as a template but the bad news is that this template can be used only for Report Pages.    Between Boards and Worksheets you can use the templates created in these two types of dashboards only and for Report pages, it looks these templates can not be used else where. I am not sure if this is intended or it is a missing functionality.   Thanks, Misbah Miz Logix ... View more

@ManuelSampaio  Nope! It can not be done   Misbah Miz Logix   ... View more

@ManuelSampaio    There are multiple ways to do so: Here are a couple of options that i can think of Option 1:  1. Create a Line Item Subset (LIS) based off of Example Module and pick all the three lines in your LIS. 2. Create another module, Module 1, dimensioned by LIS and Country and Time. Use COLLECT() function to pull the data from Example module to this module. 3. Create,Module 2, dimensioned by LIS and Country. There should not be Time dimension in here. Insert four lines in this module - FY20, FY21, Difference  and Variation. I would recommend Naming FY20 and FY 21 as general time periods like Current Year, Previous Year etc. Use Module 1 as a source module and pull the data from module 1 to module 2 using LOOKUP function. For example  FY20/Previous Year line item = Module 1. Data line item[LOOKUP: SYS Global module.Previous Year] Note: Here Global Module is a System module with no dimensions and having a line item called Previous Year or FY 20  which is formatted on Time(Year) and manually select FY20 in it. Similarly there will be another line for Current Year or FY21. Finally you can calculate difference and variation lines   Option 2:   In Report Pages of UX, there is Variance Analysis functionality with no additional development required as it needs to be done in option 1.     Thanks, Misbah Miz Logix ... View more

@NataliaLink    Outlet format wo totals :Name -  Can you use code of this line instead of Name and see if that helps   Misbah Miz Logix ... View more

@CommunityMember125605  Revert to last revision gets activated only when there is a structural change made in the model after the last revision tag. In your case I don't think there was any change that was made after the latest RT creation. I don't think there is an easy way to compare the source and target model. You may have to do it manually like exporting the model blueprint, checking all the lists (Prod and structural)  and list items, subsets, properties of structural lists, classic dashboards if any. This indeed will be a laborious activity.  I wish there was an option to compare the models. You could post this idea in an idea exchange forum as well. You can also think of initiating a new ALM by Creating fresh Dev model from last revision using Create Model from Revision option    Thanks, Misbah Miz Logix ... View more

@andrewtye Congratulations on winning 2022 ACE award. ... View more

@Varchasva.Jain  1. There is no benefit. In fact, having Parent Hierarchy takes precedence over the Top Level.  2. Yes, they could have. If a list is a large list then it is better to have Parent rather than Top Level but if it is small then Top level was probably ok. They would have created this way based on the requirements they would have received - probably there was a need to do Top Down approach or Probably parent hierarchy might grow bigger, more than one, nobody could tell why they built the way they did.   As I mentioned in Point 2, having Parents for children where the list is large performs better than the ones where you have Top Level set for Large lists. Hope that helps, Misbah Miz Logix   ... View more

@AbhishekChatterjee14  In Anaplan, For a Number formatted line item the default Summary setting is "Sum". For Text, List & Boolean formatted line item it is "None" That means if there is any flat list (with top level set) or composite hierarchy as a dimension in the module then the numbers are rolled up automatically from granular level to the top level. On the other hand if there is a module dimensioned by Time as well it has its own settings. To answer you question  Summary- Formula, Time Summary: Same as main summary - This means that the data will be calculated on aggregated levels as well as opposed to default Summation for Hierarchical Lists. If Time is set as "Same as Main Summary" then it means this is also kept as Formula. Your Summary Settings can also be read as Summary - Formula, Time - Formula. Summary- None, Time Summary: Formula-  This means that the data will NOT be aggregated at higher levels of the hierarchy. On the other hand, it will calculate the data as per the formula for TIME dimension.   Note:If you want to see it working, I would recommend you add a hierarchical list as a dimension to your module and also keep Time in it.   Hope that helps, Misbah Miz Logix ... View more

@laxmitater  Yes, Employee can be summarized as "Closing Balance"  Thanks, Misbah Miz Logix ... View more

@laxmitater  Just use + sign in between the line items Totals = Shipping Costs + Rent + Utilities + Shared Costs   Misbah Miz Logix ... View more

@BapinB  Subsidiary views should be strictly used and only in exceptions given in the Planual. If there is a need to remove the dimension of a line item which doesn't fall under the exceptions then it should be in its own module which shares the same dimensionality. Thanks, Misbah Miz Logix ... View more

@NoahJ  See if this helps Note: Posted Month has to be populated for Time where it is to be posted   Note: I have not calculated Initial Calculated Payment Amount line and Diff in Periods line. I hope Initial Calculated Payment line is not taking its values from any of the downstream line items Thanks, Misbah Miz Logix ... View more

@wbroughton    There you go! You need to change it to WRITE or READ.  You are not able to make change because it must be in deployed mode. You have to make this change in Dev model and push it to PROD thru Revision Tag.   Hope that helps, Misbah Miz Logix ... View more

@wbroughton  It has to be access issue, I think. Check if the underlying module for Text card is accessed by the role  And if Text card is published already and not saved in drafts.   Misbah Miz Logix ... View more

@wbroughton    Yes! Undoubtedly, you can change it back to full access. Edit: You can not take away your WS admin access and there is no need to do so. All you have to do is change the model role and test it.   Misbah Miz Logix ... View more

@wbroughton  You need to share the screenshot of your target module and its dimensionality. One possible reason i could think of is, If this module had a formula in its line item and  later that formula was deleted, module would have retained the numbers even if the formula was deleted. If that's not the case, please share more info so that we can take a look. Thanks, Misbah Miz Logix ... View more

@wbroughton    Yes, you can change your role from Full Access to the specific role that he is on.  If the schedule has filters applied on it, then that role needs to have access to filter module as well   Thanks, Misbah Miz Logix ... View more

@SoumyaBhattacharyaMA   Nicely done Shomu!! ... View more