Importing into system module

Highlighted
Contributor

Importing into system module

Hi Team,

 

I am trying to Import data into SYS08 Employee Details as part of my Level 1 model builder training program, but while importing i am confused as in what to fill in the time dimension.

1) Since they are flat modules so time dimension should not come, so is that my mistake? do i need to remove time dimension from my numbered list? If yes then how to do it?

 

 

SYS08.jpg

 

9 REPLIES 9
Highlighted
Super Contributor

Re: Importing into system module

Hi @kunal_311,

 

you are right, your system module should be flat, only Employee dimension, no Time dimension. 

 

On how to remove Time dimension:

Please go to your SYS08 module, open blueprint and you need to set 'Not applicable' under Time Scale, on top, as well as for all of your line items in the module.

time.png

Please let me know if you have any other questions!

Highlighted
Contributor

Re: Importing into system module

Hi  filip.sypniewski ,

 

I opted for NA as my time scale but I suppose I need to do it for all the line items under that list. Is my understanding correct?

 

kunal_311_0-1593020631580.png

 

Highlighted
Super Contributor

Re: Importing into system module

Hi @kunal_311,

 

yes, correct, no time dimension in this module, please set 'non applicable' to all your line items. 

Highlighted
Contributor

Re: Importing into system module

Hi  filip.sypniewski ,

 

I am confused with the mapping part of the source to target as well. As is where to map 

Active? 

Employees = Name?

Dept Code = Department?

Country Code = Country?

 

How to make sure data we are mapping is correct?

 

SYS08(1).jpg

Highlighted
Super Contributor

Re: Importing into system module

Hi @kunal_311 

 

I completely agree with @filip.sypniewski .

 

But in addition to that i want to add 1 point.

 

Generally when you are mapping a numbered list, you should always map only the code not the name.

 

Here in your case, you should map Code -> E2 Employees.

 

Thanks,

Sorna Raja Prabhu
Highlighted
Contributor

Re: Importing into system module

Okay sorna,

Column 2: Code - #E2 Numbered list
Column headers : - SYS08 Employees details
Highlighted
Super Contributor

Re: Importing into system module

Yes Kunal
Sorna Raja Prabhu
Highlighted
Contributor

Re: Importing into system module

Hi Sorna Raja Prabhu,

 

Can you help me with as in why in target code and department are disabled for mapping?

SYS08(1).jpg(2).jpg

Highlighted
Super Contributor

Re: Importing into system module

Hi Kunal,
The reason is Code and department has formula written that's why.
Sorna Raja Prabhu