Hi all,
After importing and mapping of products details using both view options,
my report is not in line with the sample on the training manual.
The value of size did not display properly. See attached.
How do I map to get the correct result
OK, there are several points to make.
You are updating P2 product details so you need to map product code in the source to P2 dimension in the target. You do not need to map product family.
Next, use fixed line item option then set the size column in the source as the source of data and confirm the size line item as the target in the separate line item tab.
It looks like you have imported the size list onto the blueprint and added them to the module as line items.
All you need is code, product family and size as line items. Remove all unnecessary line items and rerun the import but ensure you do this when viewing the grid view.
Hi Chris,
Thanks for your support.
However, I am still having same issues.
I have tried several options but same result.
I even went as far as recreating SYS05 and SYS06, but I got same result.
The dimension and line items are properly inputted.
See attached picture of the mapping page, if there is any wrong posting for your guide.
Kindly assist please as this is delaying my progress with the course
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…
