About rob_marshall

rob_marshall

@ntrddragn，这是一个很难说明的，因为每个模型都不同。但是，从您上面描述的内容来看，它可能只是一个不正确的数字（使用为您提供总计的层次结构）而不是使用过滤器（如果过滤器，请给我重复的数量）。但是，再次很难说。抢

rob_marshall

@1454884 This can be done, but it will depend on the number of users that will be using this functionality because you will have to dimensionalized the output module by Users (if all of them will be using it) or by a custom list (Fake Users) if it is only a subset of users. The reason I bring this up, you can very quickly blow up your model space if you have a lot of users using this functionality. The top part or selection piece is what the users can filter on and are flat lists. The bottom is automatic (summed) results of what was selected. Basically, create modules based on the attributes you want to filter on, these modules are dimensionalized by that attribute flat list and User or Fake Users. Create a module dimensionalized by your Materials and your Users/Fake Users with attributes as line items (boolean formatted). This is comparing the attributes on the Materials list with what the users entered above. My "Final Result" is not like yours, yours needs to be a boolean with the formula (Credit? AND DQ? AND FICO? AND Method?). You will use this for your filter. Also, add another line item for the Amount which is linked to your original Amount in your Materials module (this does the dynamic subtotalling). Let me know if this works for you and if you have any questions. Rob

rob_marshall

@Misbah It shouldn't be "expected" behavior. My guess is it is cached, but @anand.shekhawat should put in a case/ticket to support so it can be looked into further. Rob

rob_marshall

@Georgeduckett，由于这不是由Anaplan赞助的，也不是由Anaplan开发的，因此您有可能在Anaplan更改时与Anaplan不合适的风险。并不是说它不是很酷的，也不是很棒的软件，而是不受Anaplan的支持。

rob_marshall

@sosunkwo上述“解决”了您的问题？抢

rob_marshall

@fredrickstraube What I wrote is not the manual option, it is based off the file that is being loaded. You load the Category into SYS Product Properties module and then build a hierarchy with Category as the parent, Product as the child. Rob

rob_marshall

@FredrickStraube对此进行了镜头...创建产品平面列表并将产品导入该列表。创建一个类别平面列表并将类别导入其中。接下来，创建一个sys产品属性模块，创建一个名为类别的行项目，该类别格式为类别平面，然后从文件中导入值。接下来，按照此视频创建您的整体层次结构（https://community.anaplan.com/t5/on-demand-courses/hub-model-hierarchy-management-management-305/ta-p/202），或者您可以关注此信息邮政。https://community.anaplan.com/t5/anaplan-platform/ragged-to-balanced-hierarchy/m-p/103522#m24350希望这会有所帮助，Rob

rob_marshall

@sosunkwo Give this is shot... Create a module (Start/End Month) that is dimensionalized by what you are trying to figure out, I used Row Count but this could very well be Invoice ID or SKU. Line items Sart and End are both formatted as Date. In another module, use the same list as above and add the Time list (at the month level) with the lone line item being Complete Month, formatted as number with Summary turned to None. The formula should be: IF START() >= 'Start/End Month'.Start AND END() <= 'Start/End Month'.End THEN 1 ELSE 0 Back in your Start/End Month module (the first one), create another line item named Number of Complete Months, formatted as Number with Summary set to None. For the formula, you can use TIMESUM(Complete Months.Complete Month) since this module does not have Time in the Applies To. If you have All Periods turned on in your module, you and use Complete Months.Complete Month[Select: Time.All Periods] Hope this helps, Rob

rob_marshall

@Scotta没问题，不便后，我们很抱歉，但我们意识到这一点，希望很快就会解决。

rob_marshall

@Scotta Gotcha，有一个错误，目前您无法单击公式编辑器中的列表成员。这是正在处理的，应尽快发布。这是同一主题的其他几个线程。https://community.anaplan.com/t5/nown-issues-and-workarounds/unable-to-select-list-list-list-list-properties-when-when-using-formula/td-p/125706 Rob

rob_marshall

@ScottA You sure you are in edit mode for the formula? I ask because clicking on a line item works for me.

rob_marshall

@cmaurice正确，这是正在努力补救的事情。抢

rob_marshall

@aenenmoh查看“映射”选项卡中的代码。你里面有额外的碎片。抢

rob_marshall

@nikharsachdeva Sadly, if this is the case and you don't have an archived model of Prod that you can restore to, then you have permanently broken the sync to Dev because Prod can only have one "master" model. Remember, in order to sync, the target model (in this case Prod) has to contain revisions that are in the master/source model, and now the Prod model has a revision that Dev 1 doesn't have. Rob

rob_marshall

@Badam Yes, when you imported the file, check to make sure the of the thousands separator, for Anaplan to use the comma or the period. Rob

rob_marshall

@lilasququ So it depends on your process and the architecture. It looks like, from your picture, you enter the new project name and submitted for, then click the CER button which adds it to the list. If the "project" list that you are now adding the new project to is not a numbered list, then this is the only way it will work. However, if the "project" list is a numbered list, then you can use the Create action which will automatically create a new member where you fill in the Project Name and other information. If you do it this way, then once you click on that new member to fill in project name, your project list will already be sync'd on that member. Hope this helps, Rob

rob_marshall

@lilasququ Yes, it will show the first "detailed" member of what is on the Page axis. As I stated above, I don't think running actions is a good way to go as it could add concurrency issues for other users within the model. From the Planual: https://community.anaplan.com/t5/Chapter-5/5-01-03-Keep-User-actions-in-general-to-a-minimum/ta-p/81295 Rob

rob_marshall

@lilasququ It depends on what the page is dimensionalized by. Meaning, if you have a 5 level hierarchy and it is dimensionalized by L4 (in the page), then it shows the first member in Level 5. This is for both custom views as well as module views. Rob

rob_marshall

@lilasququ The system defaults to the first "detailed" member of the list vs the last or a particular member. I believe this might be on the roadmap, being able to define which member is the default. Rob

rob_marshall

@DeepakSrinivas You can reach out to academy@anaplan.com Rob

rob_marshall

@saisri Why not go the simply route and put a top level on the Product list and change th summary of that line item to FirstNonBlank? @JohnP Kudos and a gold star goes to you for thinking out of the box, well done. Rob

rob_marshall

TextList @KirillKuznetsov @saisri请不要使用, there is a reason why there is a specific Planual rule for it (https://community.anaplan.com/t5/Chapter-2/2-02-11-Avoid-using-TEXTLIST/ta-p/80763) Instead, please read through this thread as well at the one linked to it for ways to get around using TextList. https://community.anaplan.com/t5/Anaplan-Platform/Uses-for-TEXTLIST/m-p/120721#M30238 Rob

rob_marshall

@wbroughton是的。

rob_marshall

@wbroughton Tenant Admin does not have selective access, so the list members the users have access to, as that is only controlled from within the model. So, if you want to know what users have access to certain members of a list, your only options are to export from Users or export the list. Rob

rob_marshall

@bhatjaved @wbroughton 3rd option is to export the list. Rob

rob_marshall

@AJakote Why is the line item Role a subsidiary view, meaning it has different dimensionality than the rest of the module? It shouldn't be. Please to back to that line item (Role) and make it have the same dimensionality as the rest of the line items (Applies To should have a -) Rob

rob_marshall

@Michael.downer Did the above help? Rob

rob_marshall

@OliverMunns First, I agree with @andrewtye in that you should be using MovingSum instead of TimeSum as using TimeSum with a Time list can cause performance issues. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Secondly, have you considered using the Ratio as a summary option?

rob_marshall

@lilasququ Clicking on the one member so it sync's is way better than running actions as the previous posters stated. Actions are concurrency blockers and locks the model for the time it takes to write the data. This might not sound like a big deal, but it could be on large models with many people clicking the same action. Rob

rob_marshall

@Arnab116 Take a look at this article as I think it may help you. Also, I would stay away from TextList as much as possible as it could have performance impacts. https://community.anaplan.com/t5/How-To/Summary-Calculations-With-the-User-List/ta-p/106027 Rob