How do I clear my cache in Obiee?

Table of Contents

You have to login into OBIEE and navigate to Administration. Select command Issue SQL. Enter command call SAPurgeAllCache() into window and click Issue SQL. Cache will be purged and this should be a result of the command above.

How do I pass values from one report to another in Obiee?

Just move to the criteria of the request and click required column by which you want to navigate. In the column properties of the request there is option naming INTERACTION in that option you will find “Add action link”-> BI content and then just select required request or the required dashboard page.

How do I create a drill down report in Obiee?

The reorganized worksheet should now look like the following one:

Right-click the Maya Silver item and select Drill… in the pop-up menu.
On the left axis of the worksheet, drag the Orddate:Day item (the third from the left) to the second position within the same left axis, just before the Category item.

How do I add users to Obiee?

Creating Users and Groups in OBIEE. OBIEE Default Application Roles.
…
To create users and groups in OBIEE:

Open a new browser window for the WebLogic Administration Console.
Navigate to Security Realms > myrealm > Users and Groups tab.
Select the Groups tab, and click New.
Enter the group name as AIAdmin, and click OK.

How do I clear the command line cache?

Type CMD in the Search bar > right-click on Command Prompt and select Run as Administrator option. On Command Prompt window, type ipconfig /flushdns and press the Enter key. Once the Command is processed, you will see ‘Successfully flushed the DNS Resolver Cache’ message.

What is cache management in Obiee?

The OBIEE BI Server cache can be one of the most effective ways of improving response times of OBIEE dashboards. By using data already in the cache it reduces load on the database, the network, and the BI Server.

How do I merge two columns in Obiee?

Merging cells together so that a single value or text label spans multiple rows and columns, as shown in the screenshot in Figure 1, is a common user requirement. It’s easy. You click of the first and last cells to be combined, and then click on “Merge Cells” within the formatting pop-up window.

What is alias in Obiee?

It is a reference to a physical table. Aliases are created in the physical layer of the repository and are an important part of designing a physical layer. An alias table is a physical table that references a different physical table as its source (called the original table).

How do I create a DDR report in Obiee?

In the OBIEE11g, go to global header, click on new, click on Analysis, then click on create Direct Database request. In the OBIEE10g, Go to Answers, you will find Direct Database request. You can write direct SQL statement in the body and click on Validate SQL and Retrieve Columns. Click on Result to check the data.

How do you drill down into data within a report?

Turn on drill-down for a chart

Edit your report.
Select a chart.
On the right, in the properties panel, select the SETUP tab.
Under Dimension, turn on Drill down.
Add dimensions to the chart. Each dimension you add becomes another level of detail you can drill into.
Select the Default drill down level.

What is LDAP in OBIEE?

When OBI is first installed it is configured to use Weblogic internal user directory, which is fine if you have a small number of users. With most installations however, it’s more ideal to use the company LDAP, which allows users to login with common user-ids (windows/network user-id for example).

Does OBIEE store data?

OBIEE (Oracle Business Intelligence Enterprise Edition) is a BI tool by Oracle Corporation to gather, store, and analyse the data for enterprise reports, dashboards, scorecards and ad hoc analysis.

What command is used to clear?

In computing, CLS (for clear screen) is a command used by the command-line interpreters COMMAND.COM and cmd.exe on DOS, Digital Research FlexOS, IBM OS/2, Microsoft Windows and ReactOS operating systems to clear the screen or console window of commands and any output generated by them.

What is the clear All command?

From the Windows command line or MS-DOS, you can clear the screen and all commands using the CLS command.

How do I enable cache in OBIEE 11g?

On OBIEE 11g/12c, BI Server Cache was enabled/disabled using Fusion Middleware control (EM). Also, Modifying cache setting in NQSConfig. INI works to enable/disable BI Server cache. However, on Oracle Analytics Server (OAS), this option in EM or NQSConfig.

How do you combine two classes of features?

Merge existing features

On the Edit tab, in the Features group, click Modify .
Expand Construct and click Merge .
Click the Existing Feature tab.
Click Select.
In the pane, add or remove features from the selection.
Configure the attributes fields and field values for the merged feature.
Click Merge.

How do I concatenate more than two columns in Oracle?

Oracle String concatenation allows you to append one string to the end of another string. To display the contents of two columns or more under the name of a single column, you can use the double pipe concatenation operator (||).

What is the difference between OBIEE 11g and alias duplicate?

If you duplicate a table in metadata, then that new table (with its new name) must map to a table in the physical database that has that name. If it doesn’t exist, the SQL issued will generate an error. An alias is a reference to a table that already exists, not a separate database object.

What is DB alias in Oracle?

Description. Oracle ALIASES can be used to create a temporary name for columns or tables. COLUMN ALIASES are used to make column headings in your result set easier to read.

How do I use direct database request in Obiee?

Create Direct Database Request is a little-used option within OBIEE.
There are five primary steps to using DDR:

Identify the connection pool you want to use.
Write/Paste your SQL statement in the editor.
Validate the SQL and retrieve the SELECT columns.
Apply the typical Analysis column properties and aggregation rules.

What is DAC in Obiee?

DAC repository stores application objects in a hierarchical framework that defines a data warehouse application. DAC enables you to view the repository application objects based on the source system container you specify.

What is the difference between drill through and drill down?

What Is Drill Through? A drill through is an analytical feature that allows you to visualize additional, more detailed information about a specific KPI in a report. The difference with a drill down is that in a drill though report the new data is opened in a pop-up and not on the same chart.

What is drill down technique?

The drill down technique looks to break the key problem down into its elements and hence find a solution to these factors, with the overall aim of solving the key problem. The technique starts with a table with the key problem outlined in the first column, as shown below.

Why LDAP is faster than database?

Here’s the difference between the two: LDAP is highly optomized for reads, it can do them much faster than your MySQL database can, so it will scale much better than your database solution will in the long run which is optomized for reads and writes.

What is the difference between DNS and LDAP?

What is this? LDAP refers to Lightweight Directory Access Protocol, an application language that can maintain and distribute information from directories over a specific Internet Protocol. LDAP more flexible, secure and allows for more maneuverability than DNS.