Categories
- All Categories
- 89 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 50 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Custom Formatting in OBIEE Graphs
Hi,
I am working on OBIEE 12.2.1.3.0. I am facing an issue while creating graphs, I am using 'date' and 'Vendor' in Bars, and 'Network Classification' in Legend. There are 7 dates and 3 Vendors, I have a requirement that three vendors should be shown separtely. I am attaching OBIEE format and my required Format, from there you can have clear idea of the issue.
Answers
-
Hi,
On the group by part for the horizontal axis, try moving vendor above date
0 -
Hi,
Already tried this but this does not work.
0 -
3698127 wrote:Hi,Already tried this but this does not work.
What does "this does not work" mean?
Because the order of the columns define the order of the bars in the chart.
Now if what you expect to get is exactly the picture you posted, sorry but the tool doesn't do it. OBIEE does many things, but you can't expect any possible kind of random chart you saw somewhere else.
And you are also calculating things in the analysis (with SUM(...) ), while this is supposed to be a measure in the RPD already.
0 -
Hi,
I have attached a screen shot in which OBIEE format and required format is also shown.
I jist need that three vendors should be shown seperately against all dates as shown in screen shot.
0 -
First vendor and 7 dates, then second vendor and 7 dates are requiree.
But OBIEE works like that one vendor and a date, then other vendor and a date.
0 -
Sorry but you are either not doing it right or not saying everything about the analysis. OBIEE always worked as @Shane.S said.
The order of the columns in the horizontal axis box matter: Brand, Year generate this chart with first a group by brand and for each brand every year as bar.
If you want to have first a group by year and for each year the bar of every brand you simply reverse the order of the 2 columns:
Are you saying that you change the order of the columns and the chart doesn't change? Post a screenshot of the layout of your view if it's the case.
0 -
Hi,
As per your screenshot my requirement is that first two bars of year 2012 and 2013 and brand will be Biz Tech. And third and fourth bar is of year 12 and 13 and brand will be Funpod.
As in tabular format Biztech column properties is 'suppress' and against this brand all year values are repeates.
0 -
Hi,As per this screen shot you can find each vendor is shown only once and its corresponding values are repeated.
As per your screen shot I need every brand is shown only once and its corresponding years are repeatee.
0 -
Hi,
I need like as shown below.
0 -
Hi,
I need graph format of you attached report is as shown below.
0
