D3 With OBIEE

[manas mayur]

I am using d3 graph http://mbostock.github.io/d3/talk/20111018/tree.html  in obiee.The integration works fine.
But the problem is the graph uses JSON for the data.

I want to use the obiee hierarchies for the same.

Please share your ideas.

[Sara Quigley]

Hi Manas

You should check out the example here  

      http://bl.ocks.org/d3noob/fa0f16e271cb191ae85f

which you can use it to take the output from your OBIEE query and convert it to JSON before you compute the tree layout.

Sara

[manas mayur]

Thanks sara,

But here i am trying to achieve collapsible tree.

How i can directly reference my columns for child and parent .

I dont want to use json, but i want to use direct columns from rpd 

[Ben Lyall]

Do these links help?

http://www.askjohnobiee.com/2013/06/how-to-data-visualization-with-external.html

http://hekatonkheires.blogspot.com.au/2012/08/d3js-calendar-configuration-in-obiee-11g.html

They're for calendar views, but the concepts remain similar in terms of getting data out of Oracle and usable on the client side, where d3 does it's work.

There's even a book available for doing data visualisations that covers d3 in the advanced topics area (based on the table of contents): https://www.safaribooksonline.com/library/view/data-visualization-for/9780071837262/

I got those links by doing a google search for "d3 oracle business intelligence", not sure if they're useful or not.

[Sara Quigley]

Hi Manas, 

I've created d3 trees in obiee by following these steps:

1. construct an obiee query that outputs columns for parent and child,

2. add a "narrative view" to your query results, and in that view, "push" the output of your query into a javascript object (Ben's links below describe how to do that)

3. add javascript to the "postfix" which transforms the flat query output into a tree, computes the tree layout, and then updates the layout when you click on a node to expand or collapse it. 

I hope that helps, but if you need more ideas, I recommend you post to Stack Overflow ( http://stackoverflow.com ) with the d3.js tag.

Good luck

Sara

[manas mayur]

Thanks Sara

your help is highly appreciated .

--
You received this message because you are subscribed to a topic in the Google Groups "d3-js" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/d3-js/b16Ye5KLRws/unsubscribe.
To unsubscribe from this group and all its topics, send an email to d3-js+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mohammad Rafi Ansari]

Hi Manas,

Are you able to create this example in OBIEE. Could you please help me to implementing Collapsible Tree example in OBIEE. Something like this

https://bl.ocks.org/d3noob/43a860bc0024792f8803bba8ca0d5ecd

Regards,

Mohammad Rafi Ansari

[manas mayur]

Hi,

Yes I was able to create the graphs on obiee.

--

[Mohammad Rafi Ansari]

Could you please guide me?

Regards,

Rafi

You received this message because you are subscribed to the Google Groups "d3-js" group.
To unsubscribe from this group and stop receiving emails from it, send an email to d3-js+un...@googlegroups.com.

[manas mayur]

I will share something soon.

[Mohammad Rafi Ansari]

Okay. Thank you so much. I will wait for your reply.

Regards,

Rafi

[Mohammad Rafi Ansari]

Hi Manas,

Still looking some help in terms of some example which can guide me to implement something like this.

      http://bl.ocks.org/d3noob/fa0f16e271cb191ae85f 

Could you please share some example? I will be very thankful.

Regards,

Rafi 

[Mohammad Rafi Ansari]

And something like this

http://bl.ocks.org/robschmuecker/7880033

--