3dimension graph in obiee 12c

Question

Hi.,

is there any plugin or way to build  3 dimension chart (x y z values) in OBIEE12c

thanks

Gianni Ceresa · Answer

Did you read the blog post linked above on how to embed D3 in OBIEE using a narrative?

There you see how to do it ... (https://www.rittmanmead.com/blog/content/images/2016/05/06663d3_narrative1.png )

@1, @2, @3 contains a single value each time, they are relative to a single row, so you need to use a piece of code which, when executed multiple times (once per row), keep adding values to the already existing values instead of replacing them.

You are just overwriting the values all the time as you recreate the variable all the time.

You can also maybe an issue when you use [ ] in the narrative, that's why the example uses the function push to add a new value to the array (at least on some versions I had this issue and "push" manage it just fine).

Rajagopal R-Oracle · Answer

Thanks Gianni,

I am trying with ploty.js   https://plot.ly/javascript/3d-surface-plots/

my x axis would be text, y and z axis would be number , how to pass this values to data , i am not getting expected result.

I am passing data like below in Narrative section

var data = [{

z: [@1,@2,@3],

type: 'surface'

}];

or

var data = [{

x: [@1],

y: [@2],

z:[@3]

type: 'surface'

}];

Gianni Ceresa · Answer

It can also not exist and it's up to you to create it, but there must be for sure a JS library doing it ...

(you then embed it the same way as D3)

Look at this for example: https://plot.ly/javascript/3d-axes/