About Misbah

Misbah

@Kristina_Mihay Yes that is right! The moment name of the Line item changes it impacts the Import mappings because Anaplan Automatically maps (by default) the source name and the target name.

Misbah

@ThiruT Syntax is wrong. Use below formula and make sure it is boolean formatted line item

Misbah

@CommunityMember113484 Ah! If it is only about showing the required products then you can create a matrix of Products and Versions and Write a formula in Boolean formatted line item Data <> 0. Apply the filter based on the above Boolean formatted line item. This will display only those products which have values in current version. Misbah

Misbah

@kenzael Unfortunately there is no LASTNONZERO function available, we will go for a workaround here. See if this helps Step 1: Create a line item call it Numerator. Write below formula in it IF 'Exch Rate - Test' <> 0 THEN 'Exch Rate - Test' ELSE PREVIOUS(Numerator) and change the summary to Sum, Closing Bal Step 2: Create another line item call it Denominator. Hardcode number 1 in it and change the summary to Average Step 3: Go to your target line item ( in my case Exch Rate - Test) and change the summary from Closing Balance to Ratio (Numerator/Denominator)

Misbah

@MadhabikaM As far as I know, No there is no limit on that but it has direct impact on the performance and size based on the number of characters that you have in text formatted line item. You may not see the number of bytes go up with every character that you enter within the line item when the reality is that in backend your model may be more than double the size of what you see on the model screen. So use text formatted line item cautiously. Hope that helps Misbah

Misbah

@CommunityMember113484 Once identified what needs to be deleted use Delete from List using Selection option and try to run it during off Business hours.

Misbah

@CommunityMember113484 Ah I see what you are saying. That may not be possible because you will never have two diff data points in one line item. Benchmark will have its own line item or list item which will not align with the others & will have its own unique positioning in the graph. Hence the mismatch in the alignment. Misbah

Misbah

@CommunityMember113484 Does that mean you want Years to be stacked instead of Products. And you also want Benchmark percentage on top of it.

Misbah

@ThiruT You mean to say this If this is what you mean then my dear friend, you can not add or delete these categories. These are by default, although there are ideas shared on this in idea exchange forum to let model builders create categories to group functional areas. Hope that helps Misbah

Misbah

@CommunityMember113484 See if this helps

Misbah

@MartinBx2019 See if this helps https://help.anaplan.com/anapedia/Content/Data_Integrations/DocuSignforAnaplan.htm Misbah

Misbah

@ThiruT If you have created a module it means that you have the required access to add a category of that module. Go to Modules -> Functional Areas ->Insert Misbah

Misbah

@CommunityMember113484 Can you elaborate on how do you want to see your end result.

Misbah

@DavidSmith As part of Initial release if it is just an action it can be still can be automated thru APIs - that being the major diff between this new feature and Native Bulk Copy feature. Anaplan can then think of updating it further releases. Long Story short yes, it still will be a great feature in initial release. Misbah

Misbah

@Kristina_Mihay What limitations are we talking about?

Misbah

@DavidSmith That will be a great win. For me it was always structural list like Rolling Versions, snapshotting etc. Bulk copy like feature can be automated which is a great great win. One question though can an action be modified once it has been created with List, Source member and target member?

Misbah

@somain.gupta Again, that is a mystery. Ideas have already been shared on idea exchange forum to let page builders re-order the context selectors. As of now you can't do much about it.

Misbah

@somain.gupta 1. No 2. No 3. No. As a workaround create a dummy module with that dimension and publish the module. Once published you can drag the module to the bottom and resize the module so that it becomes almost invisible. These are great ideas. Can you please share these ideas ( idea 1 and 2) on idea exchange forum.

Misbah

@Dileepkumar B What @rob_marshall means to say is .. you can set upper level to READ only and not Hide it... Ofcourse we know that parent will have selective access enabled if children has it, but if you chose READ at the upper level you can see the aggregated data.

Misbah

@Panji There has to be a strong reason for you to take the model out of deployed mode. Thumb Rule is that " Never take the model out of deployed mode" but if you don't have any other way then I would suggest please read following articles before you do that - these are written specifically for such scenarios. ALM Explained—Part 1: Compatibility - Anaplan Community ALM Explained—Part 2: Testing - Anaplan Community ALM Explained—Part 3: Avoiding Data Loss - Anaplan Community

Misbah

@VIGNESH.M Yours is better Solution. One correction though. You don't need to use SUM on Pursuits as it will auto aggregate.

Misbah

@michael.chefer Yes, it has to do with the hierarchy and the reason is that you have kept your Summary turned off on Rank Line item which is rightly done. If you have to pull up the values you will have to play around with summary options of your source module But you can not have multiple summary settings of a single line item - probably you may have to create as many line items as there are ranks (Assuming there are only 3 ranks) Alternatively, You can also get rid of the Pursuits dimension in the target module and create line items for each list member and use LOOKUPs to pull the value (again assuming you do not have too many ranks to play around with)

Misbah

@AngrySiberianBear That's why they call it The Anaplan Way "TAW". Its hybrid of Traditional Scrum and Anaplan based Scrum

Misbah

The other way of doing it is. Go to Blueprint mode->Applies to Column->Double click in Applies to Column and Write the name of your lists.

Misbah

@DavidSmith It was an honor to collaborate with you and Rob on this.

Misbah

@johan.marketoft Form based on a Non Numbered List has only one field mandatory (by default) and that being NAME and for a Numbered List there is None. So what that means is that for a Numbered list user has to fill atleast NAME before Submit button gets activated whereas for the Form based on Numbered list it is always activated even without filling out anything. Again nice idea. Page builders should have an ability to mark certain fields as mandatory fields to fill out for end users. You can put it in idea exchange forum

Misbah

@johan.marketoft No, you can't put instructions within the Form, probably a nice idea. You can put it in idea exchange forum and I will upvote for it. As a workaround create a text card and put instructions on top of your Form. I know it is not exactly what you are looking for but it will be somewhat close to it.

Misbah

@mohitveer_sandhu You can not do any of that sort in the user input line item. Instead you can create another line item which will take the values from user input line item and you can write below logic in the second line item. If X < 0 Then 0 else if X > 100 Then 100 ELSE X ELSE X Misbah

Misbah

@DMManalili Pivot your line items to columns and Time to Pages. That should bring all of your line items to columns and if you are asking about only moving one of the line items to columns - that may not be possible

Misbah

@johan.marketoft Currently, Forms sit on top of models meaning they will not respect dependent dropdowns and I believe DCA as well will not be respected while creating it. But once you create the Form it should respect.

Online Status	Online
Date Last Visited	an hour ago