BI前端报表的装备步调(国外英文资料).docVIP

BI前端报表的配置步骤(国外英文资料) Configure XML according to the report sample: The first step is to choose a reference template, the daily report is best to find the corresponding daily report template, the monthly report finds the corresponding monthly report form. Modify the Page_Config Name of the XML file to Name some parameters such as: gd_tm_yz_usr_usr_cnty_day_init, gd_tm_yz_usr_usr_cnty_day_default_para.sql, gd_tm_yz_usr_usr_usr_usr_usr_cnty_day_query_levelsel.sql, etc. In general, the DM table name that corresponds to the report data, which corresponds to multiple reports for the same DM table, is followed by the suffix after the table name. Gd_tm_usr_usr_day_one. This type of naming can be replaced directly on the reference template by replacing it directly with the reference template. Modify the SQL statement, define the SQL statement according to the fields required for the report sample chapter, and define the field alias. It is important to note the SQL to include the start_date, end_date fields, also contain some front end conditions in the where condition, such as: a.T M_INTRVL_CD BETWEEN $the start_date $AND $end_date $AND (FRNT. Tn_privileged_judgment ( $session. Userid $, Dr. EST_LVL1_CD, $vest_type $) = 1) When configuring, you should use the template to fill in the query SQL for different viewing styles. Finally, there is a parameter definition of SQL (XML script last few lines), the general without modifying the SQL, but there are some reports of custom parameters more or less, need to increase or decrease, to pay attention to here. Configure the JSP according to the report sample: The first thing to do is to select the reference template,The daily report is best to find the corresponding daily report form, monthly report form the monthly report form. Modify the title of the JSP file and some other configuration parameters, such as: title communication RiBiao statistics / title , GD_TM_YZ_USR_CNTY_DAY_Init, GD_TM_YZ_USR_CNTY_DAY_Default_Para. SQL, GD_TM