oracle 如何在BI Publisher中删除ETEXT中的参数

uinbv5nw  于 2023-04-05  发布在  Oracle
关注(0)|答案(1)|浏览(135)

我正在使用基于分隔符的模板来生成CSV文件
除参数外,所有输出均正常
即使没有在ETEXT中显式添加它们也会显示
如何禁用这些参数
以下是输出

**P_DATE_FROM,P_DATE,P_BU,ID,LOCALE,NAME,JOB_CODE,JOB_FAMILY,JOB_ROLE1,ROLE_IS_REQUIRED12022-01-01T04:00:00.000+04:00,2024 -01-01T04:00:00.000+04:00,,**1,en_US,“Vice President- Investment Management”,3000000003295735,TESLA,“Vice President - Investment Management”,TRUE

这是示例XML
<DATA_DS><P_DATE_FROM>2023-01-01T04:00:00.000+04:00</P_DATE_FROM><P_DATE>2023-03-22T04:00:00.000+04:00</P_DATE><P_BU/><G_1>1en_USVice President - Investment Management<JOB_CODE>300000003295735</JOB_CODE><JOB_FAMILY>TESLA Vice</JOB_FAMILY><JOB_ROLE1>President - Investment Management</JOB_ROLE1><ROLE_IS_REQUIRED1>TRUE</ROLE_IS_REQUIRED1></G_1></DATA_DS>
以下是EDI模板说明

Format Setup:

Hint: Define formatting options…
<TEMPLATE TYPE> DELIMITER_BASED
<OUTPUT CHARACTER SET>  iso-8859-1
<NEW RECORD CHARACTER>  Carriage Return

Format Data Records :

Hint: Define Data Layout
<LEVEL> DATA_DS

<LEVEL> G_1
<MAXIMUM LENGTH>    <FORMAT>    <DATA>  <COMMENTS>
<NEW RECORD>    
15  Alpha   ID  REFERENCE NUMBER
1   Alpha   ‘;’ 
240 Alpha   NAME    NAME
1   Alpha   ‘;’ 
240 Alpha   DOMAIN  DOMAIN
1   Alpha   ‘;’ 
240 Number  JOB_ROLE    JOB_ROLE
1   Alpha   ‘;’ 
240 Alpha   DESCRIPTION DESCRIPTION
1   Alpha   ‘;’ 
240 Alpha   JOB_CODE    JOB_CODE
1   Alpha   ‘;’ 
35  Alpha   MIN_SALARY  MIN_SALARY
1   Alpha   ‘;’ 
35  Alpha   MAX_SALARY  MAX_SALARY
1   Alpha   ‘;’ 
23  Alpha   SALARY_CURRENCY SALARY_CURRENCY
1   Alpha   ‘;’ 
35  Alpha   JOB_FAMILY  JOB_FAMILY
1   Alpha   ‘;’ 
11  Alpha   START_DATE  START_DATE
1   Alpha   ‘;’ 
11  Alpha   END_DATE    END_DATE
1   Alpha   ‘;’ 
240 Alpha   STATUS  STATUS
1   Alpha   ‘;’ 
240 Alpha   IS_CRITICAL IS_CRITICAL
1   Alpha   ‘;’ 
240 Alpha   KEY_RESPONSIBILITIES    KEY_RESPONSIBILITIES
1   Alpha   ‘;’ 
240 Alpha   LOCALE  LOCALE
1   Alpha   ‘;’ 
240 Alpha   NEXT_CARR_STEP1 NEXT_CARR_STEP1
1   Alpha   ‘;’ 
240 Alpha   NEXT_CARR_STEP2 NEXT_CARR_STEP2
1   Alpha   ‘;’ 
240 Alpha   NEXT_CARR_STEP3 NEXT_CARR_STEP3
1   Alpha   ‘;’ 
240 Alpha   NEXT_CARR_STEP4 NEXT_CARR_STEP4
1   Alpha   ‘;’ 
240 Alpha   NEXT_CARR_STEP5 NEXT_CARR_STEP5
1   Alpha   ‘;’ 
240 Alpha   JOB_ROLE1   JOB_ROLE1
1   Alpha   ‘;’ 
240 Alpha   ROLE_IS_REQUIRED1   ROLE_IS_REQUIRED1
<END LEVEL> G_1
<END LEVEL> DATA_DS

感谢你的时间和努力来帮助
关于AR

bogh5gae

bogh5gae1#

禁用BI Publisher数据模型属性中的“包括参数标记”,如下面的快照所示,这将解决此问题

相关问题