Save System-Wide Column Formats in Oracle BI EE Answers Not Available for Admin User

Issue:
After the OBIEE Patch upgrade the Admin user cannot save column properties as a system-wide default for the catalog.

Rootcause:
BI Administrator Role is not granted the Save System-Wide Column Formats privilege.

Follow the steps below to fix the issue:

1. Login to the Analytics page as Administrator user.
2. Navigate to Administration, then Manage Privileges.
3. In the Formatting section, assign 'BI Administrator Role' to the 'Save System-Wide
Column Formats' privilege, and remove any existing entries starting with "Denied:
4. Logout and login to Analytics.

OBIA CURRENT_DAY Variable Defaults To A Static Value Instead of a Dynamic Value

Configure the value of the CURRENT_DAY variable to have the Default Initializer
set to VALUEOF("LAST_REFRESH_DT").

This can done by double clicking the CURRENT_DAY repository variable under
the option Manage, then Variables, then Static.

Performance Issue with PLP_GLBALANCEAGGRBYACCTSEGCODS

Modify the override SQL for session PLP_GLBalanceAggrByAcctSegCodes, to add hint

/*+ OPT_PARAM('_GBY_HASH_AGGREGATION_ENABLED', 'true')
USE_HASH(W_GL_BALANCE_F, W_GL_ACCOUNT_D) */

this will improve the performance.

ETL Process



ETL is an acronym for a three step process to extract data from source systems and load the data to a data warehouse. The three steps of the ETL process are:
  1. Extract and load Staging Tables: Extracts and consolidates data from one or more source systems and loads into the data warehouse staging tables.
  2. Transforms the data: Transforms data in the staging tables and computes calculated values in preparation for the load.
  3. Load Dimension and Fact Tables: Generates and maintains data warehouse surrogate keys and loads target dimension and fact tables.






ETL processes are further refined to two types of mappings:

1. Source Dependent Extract (SDE) mappings – extracts the data from the transactional systems and loads to the data warehouse staging tables. SDE mappings are designed with respect to the source’s unique data model.
Source System Databases
2. Source Independent Load (SIL) mappings – extracts and transforms data from the staging tables and loads to the data warehouse target tables. SIL mappings are designed to be universal with any source.



How to start and stop services in OBIEE 12c


Go to below path
Windows:
ORACLE_HOME\user_projects\domains\bi\bitools\bin
Start.cmd for start services
Stop.cmd for stop services
Status.cmd for Status of the services
Linux:
ORACLE_HOME/user_projects/domains/bi/bitools/bin
Start.sh for start services
Stop.sh for stop services
Status.sh for Status of the services

uploadRpd Failed: Failure in trying to acquire lock


Getting the following error while uploading RPD in our new 12c Environment:


ERROR
-----------------------
uploadRpd Failed: Failure in trying to acquire lock. Check bi-lcm-logs or diagnostics. Error Desc Code: DESC_CODE_SERVER_EXCEPTION


RootCause:

WEBLOGIC EM SETTING "DISALLOW RPD UPDATES" PREVENTS UPLOADING RPD.

Resolution:

Open the em Navigate to Business Intelligence -> Configuration->Performance Tab and uncheck Disallow RPD Updates, click apply save changes.


OBIEE 11G LOGIN PAGE HANGING OUT

my obiee login page is taking forever to load.

Try this to reduce the time to login to obiee home page.

Stop all BI services.


Take back up (if necessary) of most recent log and keep them on local drive

DELETE LOG FILES from each of the sub folder inside :
     C:\OBIEE11g\instances\instance1\diagnostics\logs


DELETE all the Log files in :
     C:\OBIEE11g\user_projects\domains\bifoundation_domain\servers\AdminServer\logs