Hi on the Level 1 model building exam,
I am trying to import the SKU csv and I get a message saying invalid parent and I dont know why.
Wold you mind helping me ?
Can you share a screenshot of your import definition?
Hi @KARASAGE
Thanks for attaching these.
One thing you should change is in your Import Data Source/File Options - you need to change the Header Row to "2" (which will automatically update the First Data row to "3"). In your file preview below, SKU, Parent and Code are our column headers that describe the row level data, and exist in row 2. This isn't the cause of the issues, but will cause some errors to appear.
You should also check the List configuration, and ensure that the Parent Hierarchy has been set properly.
Check which list the Parent Hierarchy has been set to, and then review what list items exist in that list. Check if there is an entry in there with the name or code "Nutzo Bar". If this is all set properly, and you are still having issues, can you please attach some screenshots of the configuration and the lists?
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
I have this template to import back to my module By right it should match the module because the time format is the same as the module the only difference is that in the excel file there is a seperator. M-Y. Thus logically to me it should be But when i run the action using M-Y and match names both result in an import error…
Hi everyone, I was trying to Retrieve a Line Item (Boolean) using TIMESUM as formula to another module by using ANY. This Boolean LI has A,B,C as dimensions. My target module has only A as dimension. In order to use a reference module for mapping, does this reference module had to have A,B and C as dimension or just A…
