This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

ASO Employee Hierarchy

June 19 2017 at 3:02 PM
No score for this post
AU 
from IP address 68.114.34.11

Hi,
I’m building the employee hours ASO cube which contains employee hierarchy.
The cube will be build based on SQL server table extract.
Employee hierarchy table as follows:
CIO | SVP | VP | Sr. Director | Director | Sr. Manager | Manager | Developer1 | Developer2|
I used generation dim build method. My issue is that the data is consolidated from Level 0 to the top based on rollups.

CIO
SVP
VP
Sr. Director
Director
Sr. Manager
Manager
Developer1
Developer2

I need to have data for each company employee from CIO to Developers, not to be overwritten by Level 0 data..

I would appreciate your feedback/help.
Thanks!

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Why generational then? - Cord123 on Jun 19, 2017, 3:07 PM
    1. Re: Why generational then? - AU on Jun 19, 2017, 3:11 PM
      1. Re: Why generational then? - Tim Faitsch on Jun 19, 2017, 3:56 PM
        1. Re: Why generational then? - AU on Jun 19, 2017, 5:03 PM
          1. Re: Why generational then? - Pete on Jun 19, 2017, 9:02 PM
            1. Re: Why generational then? - Tim Faitsch on Jun 20, 2017, 9:21 AM
              1. Re: Why generational then? - AU on Jun 20, 2017, 11:39 AM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.