OAS : Files/Logs/Scripts Location

 OBIEE 12C or OAS file location is different than OBIEE 11G. 

Below are the location for some critical files/logs/scripts.

NQSConfig.INI: 

$/Middleware/Domain_Home/bi/config/fmwconfig/biconfig/OBIS

instanceconfig.xml

$/Middleware/Domain_Home/bi/config/fmwconfig/biconfig/OBIPS

Live RPD:

$/Middleware/Domain_Home/bi/bidata/service_instances/ssi/metadata/datamodel/customizations

Catalog: 

$/Middleware/Domain_Home/bi/bidata/service_instances/ssi/metadata/content/catalog

Admin Server Log file:

$/Middleware/Domain_Home/bi/servers/AdminServer/logs

BI Server Log File:

$/Middleware/Domain_Home/bi/servers/bi_server1/logs

BI Tools (datamodel.sh, start.sh, stop.sh, status.sh, etc.. )

$/Middleware/Domain_Home/bi/bitools/bin

happy Learning !!

OBIEE : Catalog Manager Report Run Through Command line

 Below is the syntax to run catalog manager report through command line. 

./runcat.sh -cmd report -offline CATALOG_PATH -outputFile EXPORT_REPORT_PATH/File.csv

-delimiter ";" -type "Analysis" -fields "Col1:Col2:Col3"

Example:

./runcat.sh -cmd report -offline /u01/BIUAT/OBIEE/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/OracleBIApps -outputFile /u01/BIUAT/OBIEE/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/export_object_names01.csv -delimiter ";" -type "Analysis" -fields "Name:Created:Modified:Path:Subject Area:Table:Column" 

Happy Learning !! 

OAS : Repository (RPD) Upload/Download

 OBIEE 12C or OAS has removed the option to upload RPD through EM page. 

We will have to upload or download RPD through command prompt only. 

Go to the below path:

$Middleware/Domain_Home/bi/bitools/bin

Run the below command to Download RPD : 

Syntax: 

./datamodel.sh downloadrpd -O RPD_PATH/oas.rpd -U weblogic -P WeblogicPassword -SI ssi

Example:

./datamodel.sh downloadrpd -O /Stage/OBIEE/uat/RPD/oas.rpd -U weblogic -P weblogic123 -SI ssi

It will ask for RPD password. 

Run the below code if you don't want to mention WebLogic password in command script. 

./datamodel.sh downloadrpd -O /Stage/OBIEE/uat/RPD/oas.rpd -U weblogic  -SI ssi

It will ask for WebLogic & RPD password. 

Run the below command to Upload RPD : 

Syntax: 

./datamodel.sh uploadrpd -I RPD_PATH/after_migration_new.rpd -SI ssi -U weblogic -P WeblogicPassword

Example:

./datamodel.sh uploadrpd -I /Stage/OBIEE/uat/RPD/after_migration_new.rpd -SI ssi -U weblogic -P weblogic123

As like download , upload also can be run without WebLogic Password. 

Happy Learning !!

OAS : Use of Tooltip

 

Hover your mouse on graph it will show the all values along with all dimensions. Like below.

Let’s say if we want to show values as tooltip only then we need to add those columns in Tooltip section.

Now let’s say, we only want tooltip values to be shown when we hover mouse on graph.

Then Select Tooltip -> Tooltip Grammar Only

Keep learning & Stay healthy !!