RPD Merging in OBIEE 11G

Merging two RPDs:-

PROCESS 1:-

Consider the two RPD that are to be merged as

RPD1-Consisting of all the previous version Modelling (Existing deployed in Prod)

RPD2-Consisting of modified modules that are to be merged to the RPD1

RPD3- Consider a dummy RPD which is blank as.

Now below are the steps to merge the RPDs via Blank RPD method.

àOpen RPD1 and go to file menu > merge

àIn the merging options Select Master RPD as Blank Rpd i.e RPD3

àModified RPD as the RPD2 which has the changes that are to be merged.

àCurrent RPD will be the RPD1.

Click next and in the conflicts select Current for those whose descriptions is as ‘Add to current’ and select modified for the those whose description is as  ‘Delete from current’.

Thus the merged RPD will be saved at the location mentioned in the previous step.

PROCESS 2:-

è Open the blank RPD first.

è In merge options give the master repository as Production RPD and modified repository as Dev RPD.

And follow the above steps of process 1. 

K@run@

EM/console taking long time to open

This Happens because of too many logs created for Adminserver and BI server.

Solution:-

It can be restricted by disabling the log level parameters
Logon to console. Go to Environment -> Servers -> Adminserver (admin) -> Debug -> Expand Weblogic -> security
check any of the paramters are enabled. Disable them by clicking on Lock and edit under change center and Activate the new changes

K@run@

Interface mapping Query ODI 11G

Below query will give you complete details of an ODI PROJECT like

PROJECT_NAME,FOLDER_NAME,INTERFACE_NAME,INTERFACE_TYPE,JOIN_CONDITION_OR_FILTER_TEXT, KM_USED,SOURCE_TABLES,COLUMNS and TARGET_TABLES,COLUMNS.

(Without connecting to ODI STUDIO to know the column mappings)

SELECT

SNP_PROJECT.PROJECT_NAME    AS PROJECT_NAME,

SNP_FOLDER.FOLDER_NAME      AS FOLDER_NAME,

SNP_POP.POP_NAME            AS INTERFACE_NAME,

CASE

WHEN SNP_POP.WSTAGE='E' THEN 'PRIMARY_INTEFACE'

ELSE 'TEMP_INTERFACE' END   AS INTERFACE_TYPE,

SNP_TXT_HEADER.FULL_TEXT JOIN_CONDITION_OR_FILTER_TEXT,

DECODE (SNP_POP_CLAUSE.JOIN_TYPE ,'J', 'JOIN','FILTER') EXPRESSION_TYPE,

NVL(STL.TRT_NAME,'NONE') AS LKM_USED ,

NVL(STI.TRT_NAME,'NONE') AS IKM_USED ,

NVL(STC.TRT_NAME,'NONE') AS CKM_USED,

SNP_SOURCE_TAB.SRC_TAB_ALIAS SOURCE_TABLE,

SNP_COL.COL_NAME  AS SOURCE_COLUMN,

SNP_POP.LSCHEMA_NAME        AS TARGET_SCHEMA,

SNP_POP.TABLE_NAME          AS TARGET_TABLE,

SNP_POP_COL.COL_NAME        AS TARGET_COLUMN

FROM SNP_FOLDER

LEFT OUTER JOIN SNP_PROJECT ON SNP_PROJECT.I_PROJECT=SNP_FOLDER.I_PROJECT

LEFT OUTER JOIN SNP_POP ON SNP_FOLDER.I_FOLDER = SNP_POP.I_FOLDER

LEFT OUTER JOIN SNP_DATA_SET ON SNP_DATA_SET.I_POP = SNP_POP.I_POP

LEFT OUTER JOIN SNP_POP_CLAUSE ON SNP_POP_CLAUSE.I_POP_CLAUSE = SNP_DATA_SET.I_POP

LEFT OUTER JOIN SNP_TXT_HEADER  ON SNP_POP_CLAUSE.I_TXT_SQL  = SNP_TXT_HEADER.I_TXT

LEFT OUTER JOIN SNP_SRC_SET ON SNP_POP.I_POP = SNP_SRC_SET.I_POP

LEFT OUTER JOIN SNP_TRT STL ON SNP_SRC_SET.I_TRT_KLM = STL.I_TRT

LEFT OUTER JOIN SNP_TRT STI ON STI.I_TRT = SNP_POP.I_TRT_KIM

LEFT OUTER JOIN SNP_TRT STC ON STC.I_TRT = SNP_POP.I_TRT_KCM

LEFT OUTER JOIN SNP_SOURCE_TAB ON SNP_SOURCE_TAB.I_DATA_SET=SNP_DATA_SET.I_DATA_SET

LEFT OUTER JOIN SNP_COL ON SNP_SOURCE_TAB.I_TABLE=SNP_COL.I_TABLE

LEFT OUTER JOIN SNP_POP_COL ON SNP_POP_COL.I_POP=SNP_POP.I_POP

WHERE

SNP_PROJECT.PROJECT_NAME='DEVELOPMENT'

--and SNP_TXT_HEADER.FULL_TEXT is not null

--AND SNP_SOURCE_TAB.I_TABLE=SNP_COL.I_TABLE

ORDER BY SNP_POP.POP_NAME;

K@run@