What is drill down in OBIEE?

Posted on by Emilia Duggan

What is drill down in OBIEE?

In OBIEE, drilling is one way to navigate or interact within the data. OBIEE allows two types of drilling: drill down: from one level to lower level of the same hierarchy. drill through: form one level of a hierarchy to an other level from an other hierarchy.

How do I create an action link in OBIEE?

Enabling BI Navigation

  1. Log in to Oracle BI EE and Create an Analysis.
  2. Add an Action Link to the Analysis.
  3. Test the Action Link.
  4. Save the Action in the Presentation Catalog.
  5. Add a Named Action to the Analysis.
  6. Set the Action Link to Display Conditionally.
  7. Test the Action Link.
  8. Create a New Action.

When you drill up in a table pivot table heat matrix or trellis The detail level data is added to the current data?

When you drill down in a table, pivot table, heat matrix, or trellis, the detail level data is added to the current data. For example, when you drill from a continent, the table displays data for the continent and for the countries in that continent. Hover over a value in a view.

How do you drill down in Essbase?

Because spreadsheets can accommodate more rows than columns, Essbase retrieves data into rows, by default, when you drill down on a member. To drill across columns, press and hold down Alt, double-click the member name you want to expand, and release Alt.

How do you drill down in Siebel?

Creating Drilldown Objects for the View

  1. In Siebel Tools, select the Applet object.
  2. Query for Product Catalog RootSubCategory List Applet (eSales).
  3. Expand the Applet object, and then select Drilldown Object.
  4. Copy the Product Basic record.

What is action link in Obiee?

Action link which is used to make link from the analysis/Dashboard to other URL of Web Pages. Actions provide functionality to navigate to BI Contents, including actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives, and KPIs.

How do I drill down details in a PivotTable?

Drill into PivotTable data

  1. In your OLAP cube or Data Model PivotTable, pick an item (like Accessories in our example) in the field (like the Category field in our example).
  2. Click the Quick Explore button.
  3. In the Explore box, pick the item you want to explore, and click Drill Down.

What is Essbase 19c?

March 2, 2020. While Essbase is no longer part of the Oracle Analytics stack, it has reclaimed its identity as a database management system. The latest release is called Essbase 19c, and it will be part of the database family.

How do you create a dynamic drilldown in Siebel?

Creating a Dynamic Drilldown

  1. Create a dynamic drilldown object: In the Object Explorer, click Applet.
  2. Create dynamic drilldown destination objects: In the Drilldown Objects list, locate the Original drilldown object.
  3. Compile your changes. For more information, see Compiling Projects.
  4. Test your changes.

What is Siebel picklist?

A static picklist is a type of picklist that displays a single-column list of predefined values when the user clicks the arrow that is located to the right of a field. When the user chooses a value from this list, Siebel CRM enters the value in the field.

What is drilling in obiee?

In OBIEE, drilling is one way to OBIEE – Data Navigation (Drill Down, Through, Link, ) within the data. OBIEE allows two types of drilling: Dimensional Data Operation – Drill Down / Up: from one level to lower level of the same hierarchy Drilling is the action to discover the data along an hierarchy (ie through the different levels).

How do I drill down in Obi?

Note Within an expression When you use more than an attribute column of a hierarchy in an expression then OBI will drill in the lowest level. For instance, with the below expression, even if you have defined a quarter level between the year and month level, you will drill down in the month level.

How to use the level key to drill down in Revit?

To have this behaviour, you have to configure your dimension as the picture below. The level key to display is set by selecting the Use for drill down check box on the Level Key dialog box. The yellow key is a drill down key to choose the columns that you want to add when you drill.

How to drill down to the month level in Excel?

For instance, with the below expression, even if you have defined a quarter level between the year and month level, you will drill down in the month level. CASE ‘@{TimeLevel}{Year}’ WHEN ‘Year’ then “Date Dimension”.”Year” ELSE “Date Dimension”.”Month” END