This post is for an OBIEE Upgrade project. I assumed that RPD setup was already done in the initial implementation. This post will show you how to set up usage tracking in a newly installed OBIEE instance. Create the Usage Tracking Tables in XXX_BIPLATFORM Schema DROP TABLE S_ETL_DAY ; CREATE TABLE S_ETL_DAY( DAY_DT date null, …
Continue reading Enabling Usage Tracking in a fresh OBIEE Instance
Here is the SQL to check locked objects. You may need SELECT_CATALOG_ROLE privilege to run the SQL.
Here is the SQL to show used/free space by tablespace name. You may need SELECT_CATALOG_ROLE privilege to run the SQL.
First we need to Configure DataDirect ODBC on Linux/Unix with PowerCenter, then we Configure PowerCenter on Linux to connect to Microsoft SQL Server using DataDirect ODBC protocol. By default, the installation of Informatica include the DataDirect ODBC driver on Linux/Unix Server. Your Linux/Unix OS might have unixODBC drive which was also installed by default when …
Continue reading How to configure ODBC for Informatica in Linux Server to connect to SQL Server
This part is very challenging. You need lots of knowledge about networking and security. 1 Create a certificate key pair for the Server Certificate using the keytool genkeypair command. [tankbiee@oraclebiee ssl]$ keytool -genkeypair -alias oraclebiee -keyalg RSA -keysize 2048 -validity 1865 -keypass welcome1 -keystore /devobieeapp/u01/app/oracle/product/fmw/ssl/myIdentity.jks -storepass welcome1 What is your first and last name? [Unknown]: oraclebiee …
This section is based on the assumption that the RPD settings from the Source instance remain the same, and we migrate this RPD to the newly upgraded instance. Therefore, the RPD setup for security integration will not be covered here. Note that in OBIEE 11.1.1.9 and 12c, after you compete the SSO, you can no …
The process of synchronizing the GUIDs revolves completely around the fact that user identities are stored atomically within the Presentation Catalog, not by username but by a globally unique identifier (GUID). In certain circumstances, specifically when moving between environments with different identity providers or changes to users within those providers are made, the GUIDs can …
It's important to validate your catalog when you just finish Catalog upgrade. Here are the detailed steps: 1) Stop the BI Services from EM2) Take the backup of Catalog, instanceconfig.xml and nqConfig.ini into a separate folder.3) Update the Catalog element in instanceconfig.xml, Locate the Catalog element and update it as follows: <Catalog> <Validate>OnStartupAndExit</Validate> <ValidateAccounts>Clean</ValidateAccounts> <ValidateHomes>Report</ValidateHomes> …
Upgrade web catalog has two approaches. The first approach is that you can upgrade from analytics website under Administration if you are able to log in to the analytics website. Some times after you update the catalog path, you will not be able to log into analytics site. Then you need to upgrade catalog at …
Download OBIEE client tool from Analytics home page. Install the client tool on a local machine. Set ODBC connection for the new BI server. (refer to http://gerardnico.com/wiki/dat/obiee/odbc_driver_bi_server_create ) Open the source RPD in the new Admin tool. The RPD will be upgraded automatically. You will see lots of warning, which is normal. After upgrade is …
Tank Liu's Techlog 