About RobinSilk

RobinSilk

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

RobinSilk

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

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

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

RobinSilk

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.

RobinSilk · ‎11-12-2019

Within Q1, January is the first month (1), February the second (2), March the (3rd). Then Q2 starts, and April is the first (1), May is the second (2), and so on. Is there a good way to set something like this up? I ask because I want to build an IF AND statement, in which IF a value exists within a cell AND that cell is #2 within that quarter, a cell will be populated.

RobinSilk · ‎11-11-2019

What is the status of this?

RobinSilk · ‎10-25-2019

I have finished the sprints and I am going through the conclusion of Model Building 2. I have created the Shipping Export module, and now it wants me to log into the FP&A model to import the data. The problem is, unless I missed it, I was never given a link to the FP&A model. Here are the instructions:

RobinSilk · ‎10-07-2019

I dug a little deeper and found that in both 1.5 and 1.6 I was using "RS - Level 2 Data Hub Start / 'SYS12 SKU Details'.Build SKU", but in 1.6 I need to be using "RS - Level 2 Data Hub Start / 'SYS12 SKU Details'.Build SKU". I think this might be the fix to the issue. The only problem is that the second Source Label is too long and I am receiving this error message:

RobinSilk · ‎10-07-2019

Okay, should I be setting SKU Flat as the parent here?

Online Status	Offline
Date Last Visited	a week ago