About RobinSilk

RobinSilk

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

What is the status of this?

RobinSilk

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?

RobinSilk · ‎10-07-2019

RobinSilk · ‎10-07-2019

I'm not sure what the best way to show the action is that gives the most insight into it. Here I highlight the source label: Here are all the relevant imports:

RobinSilk · ‎10-07-2019

Thanks for the response. Here is what the view looks like from the Data Hub:

RobinSilk · ‎10-07-2019

I encountered an issue with my SYS08 module in which the data isn't being reflected the way it should. Products are not correctly population under their parent, instead they are put in at the bottom as shown in this screenshot: This leaves the "parents" blank: I have tried rerunning processes 1 and 2 (responsible for building and populating hierarchies), and it hasn't fixed the issue. Any ideas? Furthermore, if you look at the first screenshot, Nutzo Bar_EN says it is supplied by "New York". This seems wrong. Perhaps this will be resolved once the data is correctly in the module.

RobinSilk · ‎09-30-2019

That appears to have done the trick - good catch. Here is a screenshot of what it looks like now that it has successfully uploaded and matched the codes:

RobinSilk · ‎09-30-2019

Here is a screenshot of my employee list, where you can see that each employee does have a code associated with them. Do you recommend that I clear out this list and attempt to repopulate it?

RobinSilk · ‎09-30-2019

Thanks for the response. Here are some more screenshots: This first one shows the mapping that corresponds to the screenshot from the original post. This second one, I believe, follows how you are implying I should be mapping. This third one shows what I see when I use the Mapping set up from the second screenshot. It still doesn't seem to be working. What am I missing? Thanks in advance!

RobinSilk · ‎09-30-2019

We are asked to import Emloyees.csv into SYS08 Employee Details and I am unable to get the names in the list to match on the names in the employees list that I already have in. I checked and I have the data type as "Text" listed within the SYS08 module, and the .csv has the data in that column listed as "General". I also tried changing that to "Text"; neither work. I can do it manually but it will take a long time. Is there something I'm missing or should consider?

About RobinSilk

Formula to number months within a quarter?

Re: Ability to Format Cells and Cell Contents

Model Building Level 2 - Where Is The FP&A Model?

Re: Level 2 Model Building: SYS08 Incorrect Data P...

Re: Level 2 Model Building: SYS08 Incorrect Data P...

Re: Level 2 Model Building: SYS08 Incorrect Data P...

Re: Level 2 Model Building: SYS08 Incorrect Data P...

Re: Level 2 Model Building: SYS08 Incorrect Data P...

Level 2 Model Building: SYS08 Incorrect Data Popul...

Re: Level 1 Model Building SYS08 Employee Details ...

Re: Level 1 Model Building SYS08 Employee Details ...

Re: Level 1 Model Building SYS08 Employee Details ...

Level 1 Model Building SYS08 Employee Details Impo...