Oracle regexp sample
/* Formatted on 05.07.2013 10:03:10 (QP5 v5.252.13127.32847) */
SELECT REGEXP_SUBSTR (
'20130704125118|2170391:100A2876|952828909|905337662754|aksa|0||0|ORG',
'([^\|]*)\||$',
1,
5,
NULL,
1)
FROM DUAL
-----
: aksa
Oracle BI EE 11.1.1.7.0 - Catalog Manager Command Line Options
Some of my customers want to see detailed Usage Tracking Report with all objects created in the repository whether not been clicked once. For this I'm planning to do: - export the whole objects list with required columns from repository to csv file, - then import it to DB as a table , - and then outer join this table to my Usage Tracking report table as required. - Finally every night ODI triggers the command line below on the BI server : ./runcat.sh -cmd report -offline /u01/mw_home/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/SampleAppLite/ -outputFile /media/sf_expdp/CATALOG/export_object_names.csv -delimiter ";" -distinct -type "Analysis" "Name" "Created" "Creator" "Modified" "Modifier" "Owner" "Subject Area" "Path"
Yorumlar