I am stuck on this. When I had my line item my board looks like this. What is wrong in my module ? * I can't remove Time * if in the line item I add Code, Product and Distribution center it looks like this> aren't they supposed to be in column?

SYS12 SKU Details module

Solene

I am stuck on this.

When I had my line item my board looks like this. What is wrong in my module ?

I can't remove Time
if in the line item I add Code, Product and Distribution center it looks like this> aren't they supposed to be in column?

Accepted answers

All comments

Dikshant

Product and location are attributes of a SKU. Since your module says SKU details, it only needs SKU Flat as a dimension. Product and Code as a line item.

Solene

thanks ! and about the time ?

Solene

SriNitya

@Solene
SYS 12 SKU details - Not required.
Refer the article to understand more about DISCO.

https://community.anaplan.com/discussion/35993/oeg-best-practice-best-practices-for-module-design

Dikshant

@Solene

Module: SYS12 SKU Details

Applies to: SKU Flat

Line Items: Product, Location

Time Scale: Not applicable

Solene

Thanks Dikshant,

I have changed time scale. I imported SKUs. Does it look like good now?

SriNitya

Solene
Screenshot is the desired Output.

Dikshant

You need to convert them to list format, so eighter change the format to product and location list and re run the action. Create a new line item called a product list and a location list, and use the FINDITEM function to change from text to list format.

Quick Links

Can you help?

Unanswered questions

Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
Is it not possible to have the same link in 2 dataspaces
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…