✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com

Trends

Wednesday, 14 August 2019

Kashif
Kashif, August 14, 2019

About Pivot View in OBIEE 12C


About Pivot View in OBIEE 12C



1. Close the Preview window that was open for the last exercise.

2. Click the New View icon on the top of the screen.

3. Choose Pivot Table from the dropdown list.





About Pivot View in OBIEE 12C
About Pivot View in OBIEE 12C







All new views get placed at the bottom of the compound layout. This view, like all others in the compound layout has three icons: Format, Edit, and Delete.

About Pivot View in OBIEE 12C
About Pivot View in OBIEE 12C





The Preview pane will display what your pivot table will look like once placed on a dashboard.



The Layout pane is where you arrange your columns in the pivot table. You can also add a Prompt or put a column in the Sections.



The Pivot Table View properties icon allows you to make basic changes to the pivot table such as adding alternating row “green bar” styling.

Kashif
Kashif, August 14, 2019

How to creating a new Analysis in OBIEE 12C





Subject Areas are collections of metrics and attributes that can be reported together in a meaningful way.



Any dashboards that you have accessed recently can be opened from here.



Any analyses that you have accessed recently can be opened from here.


Selecting Columns








Once a subject area is selected, a “Pick List” appears on the left of the screen, organizing metrics and attributes into tables.


When double clicked, the selected metric or attribute appears in the Selected Columns section.


Any filters will appear in this section. In this case, no filters have been added. We will be adding a filter in a future exercise.


The instructions for how to add columns to an analysis are listed in this section.



Result

Kashif
Kashif, August 14, 2019

Working in the Graph Editor in OBIEE 12C




Working in the Graph Editor in OBIEE 12C

You can put columns into the Graph Prompts section to provide a dropdown for users to choose which values to see in the graph.





Working in the Graph Editor in OBIEE 12C







You can put columns into the Sections section to create a graph for each value in that column.



You can move columns around in the Bar Graph section to determine which columns are displayed in the Vertical and Horizontal Axis. You can also use the Excluded section for any columns you don’t want displayed in your graph.

Kashif
Kashif, August 14, 2019

Setting Graph Properties in OBIEE 12C




You can use the Canvas Width and Height settings to adjust the size of your graph.


The default location for the Legend is to the right of the graph.



Setting Graph Properties in OBIEE 12C



Setting Graph Properties in OBIEE 12C





Setting Graph Properties in OBIEE 12C



1. Choose ‘Thousands(k)’ from the Abbreviate dropdown list.

2. Click the OK button.

3. Click the OK button.



Setting Graph Properties in OBIEE 12C



1. Drag and drop the Layout window down so that you can see more of the Preview pane.



2. Your graph should look like the one displayed above.



3. Click Done to return to the compound layout.

Kashif
Kashif, August 14, 2019

How to edit the Graph View in OBIEE 12C


How to edit the Graph View in OBIEE 12C









All new views get placed at the bottom of the compound layout. The graph has been put at the bottom under the Filters view. This view, like all others in the compound layout has three icons: Format, Edit, and Delete. After we edit this chart we will drag and drop it to

be above the Filters view.



How to edit the Graph View in OBIEE 12C




The drop downs here allow you to change the graph type you are working on and other style settings for the graph.



The Layout pane is where you arrange your columns in the Graph. You can also add a Prompt or put a column in the Sections.



The Graph properties icon allows you to make basic changes to the table such as adding a title, moving the legend and cleaning up the axis.



Saving The Result:



How to edit the Graph View in OBIEE 12C

Kashif
Kashif, August 14, 2019

Adding a Grand Total in OBIEE 12C




Clicking on the “Sigma” button to the right of the Columns and Measures section will add a grand total line to the table.






Kashif
Kashif, August 14, 2019

How to change column Order in OBIEE 12C



The column order can be changed by dragging and dropping the column. If you are in the Preview pane, hover over the column until you see the handle displayed above. Then you can just drag the handle to the desired location. If you use this method you will see a gray bar indicating where the column will end up after moving it.


How to change column Order in OBIEE 12C

How to change column Order in OBIEE 12C



You can also re-order columns in the Layout pane. Click on a column header and start to move it. When dragging, a dark blue bar indicates where the column will end up.

Labels