How to add an additional category for the total to a graph in OBIEE?
Sometimes in the requirements you need to present a breakdown of values by categories and their total on one chart. In the example below this is done for horizontal bar graph, but it can be done for any graph using the Calculated Items feature.
How to select all values as a default for a variable in a filter?
When a report is filtered by variable values we need to either make sure that the variable is populated with prompted values or variable’s default value is set. Otherwise the report will bring no results:
How to override the log level settings directly in Answers?
Level of query logging for users should be set in the Oracle BI Administration Tool in Security Manager, but we can override the session variable to turn on logging (or change to a higher level of logging) for a particular analysis.
This can be sometimes useful as in production environments logging level is usually set to 0 (no logging). Changing it to second logging level (LOGLEVEL=2) would fetch both the logical and physical SQL. Continue reading
How to start editing a report on Criteria tab instead of Results tab?
By default the when you click on Edit report, you OBIEE Answers opens it on the Results tab. This triggers the report’s query execution and most of the time you want to go to the Criteria tab anyway. So it can save you some time if you change your account settings to navigate directly to the Criteria tab when editing. Continue reading
How to check which objects are locked in Oracle database?
Sometimes its necessary to check which tables are locked on the database (be it by running ETL sessions or other database users). Information on current locks on the Oracle database objects can be found in the V$LOCKED_OBJECT view. Here’s a SQL query to check the locked objects on Oracle database: Continue reading