General OBIEE

Get Involved. Join the Conversation.

Topic

    Peter Kirwan
    Stats
    Topic posted February 13, 2017 by Peter KirwanBlue Ribbon: 750+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Core HR, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, SQL 
    53 Views, 1 Comment
    Title:
    Stats
    Summary:
    Stat Report
    Content:

    is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows would be the Department Grouping they are in?

    I would then section by Grade

    Comment

     

    • Chris Dabel

      Yes, for this, you could do this:

      1)
      Use a pivot measure for each of the columns containing the age range employee counts.

      The column formulas will look like this:

      Column1 formula:
      FILTER("# of Employees" USING "employee age" BETWEEN 16 AND 20)

      Column2 formula:
      FILTER("# of Employees" USING "employee age" BETWEEN 21 AND 26)

      Etc...

      OBIEE Pivot measures are detailed very well in this resource:
      http://gerardnico.com/wiki/dat/obiee/filter_function


      2)  Then add the Department column to the analysis.

      3)  Then create a new, Pivot Table view > Edit the view.

      4)  Drag Department to the rows

      5)  Move around the columns until it looks like what you want.

      (I'm not sure what you mean by section by Grade, but you can experiment in the pivot table and move your Grade column to different parts in the Pivot Table layout editor and see how the view changes in real time as you move Grade around.)

      7)  Alternatively, you might also consider creating a Graph view on this analysis. This requirement seems amenable to a bar graph visualization.


      Thank you,

      Chris Dabel

      Oracle Fusion Support