Master detail relationship in obiee wiki

Karl Arao's TiddlyWiki - has moved to -> pdl-inc.info

master detail relationship in obiee wiki

You can link views such that one view drives changes in one or more other views . Master-detail linking of views allows you to establish a relationship When a master-detail event is raised, it passes the definition of the cell (or. In computer user interface design, a master–detail interface displays a master list and the Examples of a master-detail relationship are: a set of purchase orders and a set of line items belonging to each purchase order, an expense report with .

The Table view displays results in a standard table. You can navigate and drill down in the data. You can add totals, customize headings, and change the formula or aggregation rule for a column. You can also swap columns, control the appearance of a column and its contents, and specify formatting to apply only if the contents of the column meet certain conditions. In the Compound Layout, you can create different views of the analysis results such as graphs, tickers, and pivot tables.

These are covered in this tutorial going forward. Filtering, Sorting, and Saving Your Analysis This topic demonstrates how to filter, sort, and save the analysis you have created above. You will add a filter to the analysis and then save the filter. Filters allow you to limit the amount of data displayed in the analysis and are applied before the analysis is aggregated. Filters affect the analysis and thus the resulting values for measures.

OBIEE 11g - Master Detail linking view

Filters can be applied directly to attribute columns and measure columns. A filter created and stored at the analysis level is called an inline filter because the filter is embedded in the analysis and is not stored as an object in the Presentation Catalog Catalog. Therefore, an inline filter cannot be reused by other analysis or dashboards. If you save the filter however, it can be reused and is known as a named filter.

Named filters can also be created from the global header. Perform the following steps to filter, sort and save the previously created analysis. Click the Criteria tab. To do this, click the drop-down list for Value, and click the desired check boxes. The Filters pane displays the newly created filter. Click the More Options icon in the filters pane and select Save Filters.

The Save As dialog box appears. A filter must be saved to a subject area folder so that it is available when you create an analysis using the same subject area. If a Confirm Save Location dialog box appears, accept the default. Oracle BI EE allows you to save any type of business intelligence object to any location within the Catalog. The Save As dialog box should look like this: The Filters pane should look like this: Next, you save the analysis so that you can verify the creation of your named filter within the Catalog.

Click the Save icon to save your analysis. First you create a folder named Regional Revenue. Click Cancel to exit Save As dialog box. Click the Save icon.

Master–detail interface

Verify that the Regional Revenue folder is selected. The analysis is saved to the catalog folder Regional Revenue. Click Home in the global navigation bar. The analysis is added to the Favorites list and a Favorites icon displays next to the analysis name.

Click the Edit ink for the Regional Revenue analysis. Observe that a sort icon is added to 1- Revenue. The order of the sort is indicated by an arrow; in this case, the arrows points down, indicating that it is descending. Additionally, if multiple sorts are added, a subscript number will also appear, indicating the sequence for the sort order.

master detail relationship in obiee wiki

Save your analysis again. Click the Results tab to verify the filter and sort are being applied to your analysis. The Compound Layout display the filtered and sorted analysis.

This concludes the topic of saving an analysis and sorting it. Creating Selection Steps for Your Analysis This topic covers how to add selection steps to an analysis. Both filters and selection steps allow you to limit the data displayed in your analysis. Unlike filters that are applied before the analysis is aggregated, selection steps are applied after the analysis is aggregated. Selection steps only affect the members displayed, not the resulting aggregate values.

What is a FACTLESS FACT TABLE?Where we use Factless Fact

For example, the outline total for the top level of a hierarchy is not affected if some members of the hierarchy are excluded from the selection. Selection steps are per column and cannot cross columns. While measure columns appear in the Selection Steps pane, you cannot create selection steps for them. Note that however, the grand totals and column totals are affected by selections. You can create selection steps for both attribute columns and hierarchical columns. You will add a selection step for products.

Creating Analyses and Dashboards

The Selection Steps pane opens. Under Products - P1 Product, hover over 1. Start with all members, and click the pencil icon. The Edit Member Step dialog box appears with the list of available products. You will use the shuttle icons to move column members between the Available and the Selected columns. Click the Move All shuttle icon to move all members from Available to Selected pane.

In the Selected column, select Install and Maintenance and click the Remove icon to return these two members to the Available column. You can use Ctrl-click to select multiple members in the list. The Selection Steps pane appears with the new values added.

Observe that you can also save the Selection Steps as an object in the Catalog by clicking the Save icon. Click the Selection Steps pane again to minimize the Selection Steps pane Verify your results by reviewing your analysis in the Table view of the Results tab. Install and Maintenance should not be list in the product list.

The Table Editor appears. To add a grand total to the analysis, click the Total icon to the right of Columns and Measures in the Layout pane of the Table editor.

master detail relationship in obiee wiki

Select After from the drop-down list. Review the results in the Preview pane, and note that the Total icon in the Columns and Measures area now displays a green check mark, indicating that a grand total has been added to the analysis.

Before adding a total for Region, remove the sort from 1 - Revenue: Click the Results tab and review the Table view to confirm that the sort has been removed from the analysis. Now you will add a total by region to your analysis.

  • Before You Begin
  • Linking Views in Master-Detail Relationships
  • Navigation menu

Click the Edit View icon in the Table view. This concludes the section on adding totals to your analysis. Adding Formatting to Your Analysis After you create and run an analysis, default formatting rules are applied to the analysis' results.

Default formatting rules are based on cascading style sheets and XML message files. For example, you can link two views so that when you click a particular Region in a table, your selection affects a graph. The Region on the section slider or prompt in a graph and the data in the graph changes to reflect the Region that you clicked on the table. You must define the two types of views to link: Master view — Drives data changes in one or more detail views. The following types of views can be master views: In a trellis view, only on the outer edges, can be master views, not the inner visualizations.

A master view can be the same analysis as the detail view or in a different analysis. A master view can update the data in one or more detail views.

master detail relationship in obiee wiki

A master view contains a master column, where you set up the interaction that sends master-detail events on a channel. A channel carries master-detail events to the detail view. It must be displayed in the body of the view. Detail view — Responds to master-detail events such as clicking on a value in a master view table.

The following types of views can be detail views: In a trellis view, only the outer edge can be detail views, not the inner visualizations. Open the analysis for editing. For the column that is to be the master column, in the Criteria tab, click the Options button and select Column Properties. On the Column Properties dialog, click the Interaction tab.

master detail relationship in obiee wiki

In the Specify channel field, enter a name for the channel on which the master view sends master-detail events. Click the Results tab to view the default table or pivot table view.

Optionally, create a different view to be the master view. Defining Detail Views As part of the process of linking views in master-detail relationships, you define the detail views that receive changes from the master view.