'SYS08 Employee Details'.Region

Wade
Wade
in Modeling

I'm having a little difficulty in the exam on activity 6.  I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08.  Am I going down the wrong path or how should I think about updating this region in the module?

 

Thanks, 

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @Wade 

    So close! Just to add to @einas.ibrahim query. In the SYS08 module you were asked to add a line item called Region. Since you already know the country of the employee then you can easily determine the region using the function PARENT(). Parent(Country) .

    The system module is used like a lookup table. In this way, you don't need to add the Region to your module that has all the data in it because it would just repeat the region unnecessarily and take up space.

    Give it another try. I think you've got this.

     SYS08.png

Answers

Categories