Oracle Transactional Business Intelligence
Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version
Summary
Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version
Content
Hi,
Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version? Please advise.
The different levels in the pyramid would represent different grades (e.g. Analyst, Associate consultant, Consultant,... partner, etc.) And their width+number(width of the pyramid) would represented headcount at those grades.
attaching the screenshot of the different ways to represent data. one of the images in the screenshot is of the pyramid shape of data layout that we are trying to achieve.
Thanks,
Rashmi
Comments
-
Moved to correct forum.
-
Hi,
Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version? Please advise.
The different levels in the pyramid would represent different grades (e.g. Analyst, Associate consultant, Consultant,... partner, etc.) And their width+number(width of the pyramid) would represented headcount at those grades.
attaching the screenshot of the different ways to represent data. one of the images in the screenshot is of the pyramid shape of data layout that we are trying to achieve.
Thanks,
Rashmi
-
Rashmi,
OTBI has the funnel graph, I think this is the closest thing.
Thanks, Julian
-
Hi Julian,
I did check the funnel option. But, I guess , it requires for every parameter(like job name), it compares 2 different fact columns(like head count and assignment count). We just need one fact i.e. head count for each job. When I create an analysis like this, it will not give the highest head count at the largest part of the funnel and lowest head count at the smallest part of the funnel, which is our requirement. It will just list the head counts for each job sequentially on the funnel.
Can we atleast have the highest head count at the largest part of the funnel and lowest head count at the smallest part of the funnel?
Regards,
Rashmi
-
Is it possible to sort the table and then create the funnel?
-
Can you please guide , how to sort a analysis on a specific column in descending order?
Regards,
Rashmi
-
I tried sorting--> went to Results screen --> clicked on 'Head Count' column --> Sort --> Descending.
Analysis gets sorted , but, not the funnel. Funnel is, by default i guess,sorted on ascending order of the Job Name.
Can you please help..
Regards,
Rashmi
-
Hi,
I have read about Fusion Charts to get this done.
LInk :https://www.fusioncharts.com/dev/chart-guide/standard-charts/pyramid-chart
Can we use this in an OTBI analysis .xml to get the pyramid layout.
Please confirm. Our client is pushing on having the structure in Pyramid format.
Regards,
Rashmi
-
Can you create the analysis again and sort the table in the criteria tab and then create the funnel - does that work?
-
(That article does not pertain to Oracle products.)
Use the trellis with ascending sort on headcount, with the grades as rows, which will put the largest chunk at the bottom of the base of the trellis and the smallest bit on the top. Select content paging for the trellis. (I think it looks better without gridlines.) You can experiment with 2D, 3D, and 7 different styles like rectangle and triangle; also dynamic and logarithmic scales. If you flip it around with the grades as columns then it looks like a bar chart.
Probably the best graphical representation of grade and headcount is either the bar or stacked charts. You can use 3D to make it more visually appealing. Use ascending sort on headcount to give the shape. It will be a half pyramid, on it's side. -
Hi Gail,
This seems interesting. Would it be possible for you to show the pictorial representation of Trellis. I have tried this option but could not figure out the best look.
Regards,
Urvashi
-
Hi Rashmi,
I am also struggling with the same query. Were you able to figure out the solution for this. Or can you suggest something else for pyramid representation.
Thanks
Urvashi
-
Hi Rashmi,
I am also struggling with the same query. Were you able to figure out the solution for this. Or can you suggest something else for pyramid representation.
Thanks
Urvashi
-
Please attach your report XML.