Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Tree View in OBIEE 11g

Received Response
42
Views
5
Comments
PinakiB- Oracle-Oracle
PinakiB- Oracle-Oracle Rank 3 - Community Apprentice

Is there any native view in OBIEE like the one in the following links :

*http://www.sandeepvenu.com/2013/11/google-organization-chart-in-obiee-11g.html

*https://www.primefaces.org/showcase/ui/data/organigram.xhtml

If yes, could you please share the steps to do or any known docs?

Thanks in advance!

Answers

  • 3257772 wrote:Is there any native view in OBIEE like the one in the following links

    No,

    nothing native like that. You only option is to use an external library (like Google or any other kind of JS library).

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    3257772 wrote:Is there any native view in OBIEE like the one in the following links :*http://www.sandeepvenu.com/2013/11/google-organization-chart-in-obiee-11g.htmlIf yes, could you please share the steps to do or any known docs?

    Question: What's wrong with that blog post? It tells you what to do and how to do it down to the code!

    Edit: Just checked and I was dead sure...that guy's blog is nothing but a character by character rip-off of SampleApp to get clicks. Any SampleApp contains precisely that example under 02. Visualizations -> 2.32 Google Visuals

    pastedImage_0.png

  • @3257772 : did you give up on this?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @3257772 Thanks for never closing your threads and never deigning to answer to the people spending time investigating your issue and responding. Much appreciated.

  • John_K
    John_K Rank 5 - Community Champion

    Nothing native - you either have to use the Google API's, or if you're feeling a little adventurous then you can generate the HTML and style it manually - that gives you the greatest level of flexibility but it's a lot more involved. Basically you use nested HTML list objects and style the :before and :after selectors by moving them up to the top of the element and applying borders to those. I.e.

    profile.png

    So the both have a top border but only the before has a right border. Then for the first elements you remove the first top border and for the last element you remove the after top border. Sounds complicated but you can get some very nice results from it. Here is one I wrote that generates a chart manually in APEX. Displays the first level horizontally and the remainder vertical. Cells colour coded and names clickable (to drill to detail), with the nodes collapsible too. We append metrics at the bottom as final nodes (the circular cells). The org chart is 100% html/css with the drilldown and node collapse done via jQuery

    pic2.png