OBIEE biserverxmlexec utility to convert a xml into a rpd without uid
Hi,
I have a requirement in which, I need to manually or through an API create a OBIEE xml template and use the "biserverxmlexec" utility to convert the xml file into a rpd. Im able to do this with manually providing the uid, id, parent name, parent id, qualified name etc. But according to the oracle docs "Integrator's Guide for Oracle Business Intelligence Enterprise Edition" for the 11g Release 1 (11.1.1), it says we can create a rpd through a xml by providing the qualified name and the remaining parameters like the uid, id etc are automatically generated by the Oracle BI Server. When i try to leave the uid blank, it gives me an error. Appreciate it if some one could throw some light on the format required for xml without providing uid, id etc, in order to create the rpd file. The error prone line is as follows:
example: <ColumnMapping>
<RefLogicalTableSource uid="" qualifiedName=""PR2ATOM"."DIM_RUN_TYPE"."DIM_RUN_TYPE""/>
<RefLogicalTableSource uid qualifiedName=""PR2ATOM"."DIM_RUN_TYPE"."DIM_RUN_TYPE""/>
error: [2012-09-06T09:39:56.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1] [nQSError: 92006] Could not resolve the object "PR2ATOM"."DIM_RUN_TYPE"."N_RUN_TYPE_SKEY" (UID: 0)
error: [2012-09-06T09:23:57.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1] [nQSError: 92006] Could not resolve the object "PR2ATOM"."DIM_RUN_TYPE"."N_RUN_TYPE_SKEY" (UID: 0)
Cheers,
Fazeel.