About RobinSilk

RobinSilk · ‎12-22-2020

There would be over 1200 users with access to the model. Unsure how many would need access to the adjustment creation functionality but it would be easier to not make some sort of quasi "subset" of adjustment creators. I do see what you have in mind, though, and will think it through. As far as the number of adjustments, there is no set list length. It needs to be able to grow to any size - potentially thousands but unsure.

RobinSilk · ‎12-22-2020

Per your boolean idea, how would you be able to filter it in order to know who created the adjustment? Would this mean dimensionalizing the line item by the users list or something?

RobinSilk · ‎12-21-2020

Hello, We currently have a model built out with functionality to create "adjustments"; these adjustments have a line item that is dimensionalized by the Users list. The idea is to track who has made which adjustments, and figured that the users list is the best way to do this. We currently have 2 versions of the model - UAT and PROD. UAT has almost 1200 Users in it, while PROD has 124. We expect PROD to reach (and potentially eclipse) the UAT number at some point. Testers have reported performance issues in the UAT model when trying to make a selection with this line item, even to the point that the model will time out. Are there known performance issues for line items dimensionalized by Users when the users list reaches large numbers? Trying to determine the root cause here, and if its an Anaplan bottleneck or something external. For reference, testers have reported this while using Google Chrome. Thanks!

RobinSilk · ‎11-24-2020

Already tried this, didn't work. I did find the issue though: unparented items in the list (orphans) Although you cannot see them in the module, they were being counted by the formula. Deleting out these items would presumably fix the issue.

RobinSilk · ‎11-23-2020

Hello, I am running into a strange issue with the rank formula. In the attached screenshot, you can see a line item with the formula: RANK(1, ASCENDING, SEQUENTIAL, CURRENT FLAG <> Previous Current Flag, Current Flag Mismatch) I have displayed all related line items. A screenshot of the filter on the view has been provided as well. The line item "Current Flag Mismatch" has the formula: CURRENT FLAG <> Previous Current Flag This view is also filtered (screenshot of that attached as well) and sorted ascending for the RANK line item. I am struggling to figure out why the rank starts at 10,293 instead of at 1! This doesn't really seem to make sense. Any help would be appreciated. Thanks, Robin

RobinSilk · ‎10-23-2020

Done as you asked, more screenshots below. Still not flowing as expected.

RobinSilk · ‎10-23-2020

Thanks for your response, unfortunately it isn't working. I've tried changing delta to time summary of any, to no avail. Here are screenshots of how the module + blue print look. Delta Flag and Final Delta Flag are both set to "None, Time: Any"

RobinSilk · ‎10-23-2020

Hello, I have a module with three relevant dimensions: Position ID (FLAT Position ID) Component (FLAT Components) Time (monthly) For a component under a position, if any month is marked true in an initial line item, every month should be marked true in an associated line item. Screenshot attached, but in the example if TBR for BELL is marked TRUE in JAN 21, I want to mark every month as TRUE in the next line item. I have tried using an interim line item that removes the time dimension and then trying to pull it back up using an ANY, but this isn't working. Any suggestions would be appreciated. Thank you

RobinSilk · ‎10-07-2020

Thanks! I haven't completed the Level 3 training yet, so this was new to me.

RobinSilk · ‎10-06-2020

Hello, For each list member in SYS78 (screenshot 1; "Rows") there is a corresponding Baseline value. I want to have the system compare the Baseline value for each list member to the Minimum and Maximum values in SYS77 (screenshot 2), and depending on which range it falls within I want to pull the appropriate Factor. So, compare baseline in SYS78 to the ranges in SYS77, and pull the appropriate ranges associated Factor into SYS78's Factor Lookup line item. How can I do this? Thank you in advance for any help.

RobinSilk · ‎07-30-2020

I think this worked! Thanks so much!

RobinSilk · ‎07-30-2020

Please see attached for settings. These were already all allowed; perhaps there is another to add?

RobinSilk · ‎07-30-2020

I have made sure this is the case for my setup and it is still not working. I posted a video in a response higher up in the thread to illustrate this. My pop-up settings allow Anaplan (screenshot attached).

RobinSilk · ‎07-30-2020

Hey, thanks for this suggestion. I changed to Email text type and now when I click the link a pop-up appears briefly, then closes. No email for me to send. Attached a short recording of this issue.

RobinSilk · ‎07-30-2020

Hey, tried this and no difference in process. Thanks for the suggestion though.

RobinSilk · ‎07-30-2020

Hello, I am trying to build out a module that will have a saved view filtered on if a user has "Has Bug Re-Opened?" = TRUE. I've attached a screenshot of what my MAILTO function looks like along with the other line items to validate that it has been set up correctly. If my understanding is correct, line item "EMAIL: Has Bug Reopened?" should be underlined and when I click on it an email tab should open up. Unfortunately, that doesn't happen; no pop-up appears. Another screenshot attached. Any clue as to why this isn't working? For reference, I am using google chrome.

RobinSilk · ‎07-23-2020

Thanks for your help thus far, Rob. I have created the Custom Users List and module as you advised. As such, my Users list and Custom Users List are identical. The only difference is that the Custom Users List has a top-level item "All Users". I am still having trouble pulling those inputs from the real user module into this custom users module, and a lookup doesn't seem to be cutting it. At this point it is too late to switch the dimension over from Users to Custom Users in that module where these users were inputting data. Attached are some screenshots to help illuminate this: 1) Original Users dimensioned module. The line items at the bottom are the ones we want to be able to aggregate. 2) Error message, Custom Users dimensioned module, and a look at the formula. You can see that I am trying to use "Customer User Identifier", which should be identical for the Users and Custom Users, as a way to bridge the gap. Where do I need to go from here? Thanks, Robin

RobinSilk · ‎07-23-2020

This is great, thank you. Would you mind taking a step back and explaining the easiest way to create a fake users list based on the real users list? How do I go about tieing the real users to the fake users list?

RobinSilk · ‎07-23-2020

Would you mind elaborating on how this might work for a custom user list, and how that LOOKUP might play into making this a possibility?

RobinSilk · ‎07-22-2020

We are using the real Users dimension.

RobinSilk · ‎07-22-2020

Hello, I have a module where users indicate the "priority" of list members using a list formatted line item. These users can potentially assign different priorities to the same line items; a screenshot is attached that illustrates how two users have indicated different levels of priority (one High, one Medium). Is there an easy way to catch these mismatches? For additional context, I want to import this priority level into a separate, non-user-dimensioned module. If I can take it a step further and indicate which value should be used in the event of a mismatch that would be great. Otherwise, if all we can do is filter out cases of mismatches and manually go in to address them, that would be fine too. Thanks in advance for any help.

RobinSilk · ‎06-23-2020

I am trying to limit the options in a dropdown list so that a user cannot select "option A" for both "slot 1" and "slot 2". In the attached image, the equivalent would be blocking the user from assigning "testtest" or "matt 622 upload" in the third slot for the parent "CUMMINGS, JAMIN". Note: every parent should be able to select every option once, but never more than once. What is the easiest way to do this? Is there a certain way I need to setup my lists? Thank you in advance for any help.

RobinSilk · ‎05-01-2020

Now I feel silly, didn't realize it was that simple. Thanks!

RobinSilk · ‎05-01-2020

Hello, I have a numeric line item (picture attached) with cells filling in as 1 if they fulfill a condition, 0 if not. The total number of 1s in this example is 1514; I need to reference this total in another line item in a separate module. This separate module is not dimensioned off of any lists. How can I do this? From what I understand, SUM and SELECT require common list dimensions, is that true or am I mistaken? Thanks, Robin

RobinSilk · ‎03-30-2020

In my model, I have the Current Fiscal Year set as "FY20: 1 Jan 2020 - 31 Dec 2020." As we move into future years this will be updated. I need to write a formula that pulls the last date of the current fiscal year; for this year it would be 12/31/2020 and when we update the Current Fiscal Year in 2021 it will be 12/31/2021. The goal is to compare the last date (12/31/2020) or last period (Dec 20) to a line item value in a different module that does not have a time dimension. I have a system time module set up (pictures attached) wherein I should be able to identify the last period, in this case, Dec 20. I do this by comparing the period month number to 12; if it equals 12 I know it is the last month in the year and the last period. Is there a better way to do this without hardcoding 12? Once I have identified the last period in the system time module, I need to be able to compare/use this value to values in other modules that do not have a time dimension. How can I do that? I can provide more details if necessary. Thank you in advance for any help provided.

RobinSilk · ‎03-09-2020

Hey Jared, My list currently does not have a top-level item, which I think is where this might be going wrong. I will add one and see if that works.

RobinSilk · ‎03-09-2020

Hey Jared, Thanks for your response. I feel like I am close, but potentially missing something. I've attached three screenshots of what I've built out and it mirrors what you did (with some items that were nonessential left out). Do you see what my issue is? My MAX RANK item is not successfully ignoring non-blanks, and is not showing non-maximums either. It should be showing 6 for all of them. - Robin

RobinSilk · ‎03-09-2020

To clarify, I mostly need to know how to identify the max RANK value. The creation of a new row is something I can worry about later.

RobinSilk · ‎03-09-2020

In the attached example, I am using a rank function in the RANK line item to identify rows with non-blank ICM_ASNMT_ID and assigning them ascending rank values. Next, I want the MAX RANK VALUE line item to search through the RANK line item and return the highest value it can find (as demonstrated). In the example, this would be 6 which I have typed into each cell. Ultimately I need a way to reference what the maximum value in RANK is in order to insert new records into this module and populate the ICM_ASNMT_ID with that number. For example, I would be able to use the fact that 6 is the highest RANK value to create a row with the ICM_ASNMT_ID of 7. How can I use a formula to do this?

RobinSilk · ‎03-09-2020

When looking at the page for the rank formula, there is a callout that says " Remember that if a source value is blank, the blank is ranked first for ascending order and last for descending order.". I am wondering how blanks could be excluded from a rank formula where I need to sequentially rank records based on when they are created in a list.