Start Reports Configuration - Intergraph Smart Materials - Version 2016 R4 (8.4.0) - Help - Hexagon PPM

Intergraph Smart Materials Classic Help (2016 R4)

PPMProduct
Intergraph Smart Materials
PPMCategory_custom
Help
Version_SPMat_custom
2016 R4 (8.4)

To use the Start Reports functionality in Smart Materials Web, you must configure DBA settings and possibly specify commands as described in this chapter.

BI_START_REPORT_SERVER

The DBA setting BI_START_REPORT_SERVER must be set that it points to the Oracle Reports server, for example, http://dor-mds-as02.net.com/reports/rwservlet.

REPORT_SERVER

With the Application Server specific DBA setting REPORT_SERVER you define the report server name. The name of the report server is required if you want to use the Oracle report server architecture for running reports. The report server name is generated with the following syntax: ReportsServer_ + <your_machine_name> + _asinst_1. For example, with the machine name dor-mds.as02, the report server name would be ReportsServer_dor-mds-as02_asinst_1.

You can find the name in the Oracle Enterprise Manager (http://<your_machine_name>:7001/em) at the Farm_ClassicDomain/Reports node. Or, you can find it on the file system underneath Oracle/Middleware/asinst_1/ReportsServerComponent.

There must be at least one active value for this setting. If there are more than one active value, you can select the report server name when you run any report.

Optional BIR Command

The reports started from Smart Materials Web use the parameter commands defined in the Command field on the A.30.05 Parameter screen as usual, to show the allowed values for the parameter in the selection list if the parameter query type is Query. Since the Smart Materials reports use :GLOBAL and :CTRL variables which are set during the Smart Materials Classic session, these variables cannot be used for the reports started from Smart Materials BIR. To resolve this problem, all standard report parameters which use any of the mentioned variables have an alternative command assigned that is used when starting the report from Smart Materials Web. These alternative commands are displayed in the BIR Command field on the A.30.05 screen.

If you use any of the values listed below in the Original Value column in your own (custom) reports, you should define a BIR command for the concerning parameters, considering the following instructions.

Original Value

Replace with

:CTRL.proj_id

m_pck_admin.current_proj_id

:GLOBAL.proj_id

m_pck_admin.current_proj_id

:CTRL.user

m_pck_admin.current_proj_id

:GLOBAL.user

m_pck_admin.current_proj_id

:CTRL.nls_id

mpck_login.current_nls_id

:GLOBAL.nls_id

mpck_login.current_nls_id

:CTRL.m_usr_id

mpck_login.current_usr_id

:GLOBAL.username

mpck_login.current_usr_id

:CTRL.us_id

mpck_login.current_us_id

:GLOBAL.us_id

mpck_login.current_us_id

:CTRL.dp_id

mpck_login.current_dp_id

:GLOBAL.dp_id

mpck_login.current_dp_id

:CTRL.standard_id

m_sys.m_api_bireport.get_standard_id

:GLOBAL.standard_id

m_sys.m_api_bireport.get_standard_id

:CTRL.standard_code

m_sys.m_api_bireport.get_standard_id

:GLOBAL.standard_code

m_sys.m_api_bireport.get_standard_id

m_pck_ppd_defaults.get_project_default(…)

W_PCK_BIREPORT.get_project_default(m_pck_admin.current_proj_id ,’PRJECT_DEFAULT_CODE’)

Example:

This is the original command used when starting the report from Smart Materials:

select a.cg_group_code, b.short_desc

from m_commodity_groups a, m_commodity_group_nls b

where b.group_id = a.group_id(+)

and b.nls_id(+) = :CTRL.NLS_ID

and ( a.dp_id IN (SELECT g.dp_id

FROM m_us_id_display_disciplines g

WHERE g.us_id = :GLOBAL.US_ID

AND g.display_ind = 'Y' ) or a.dp_id = :Global.dp_id)

/*S.10.02 Commodity Group */

And this is the alternative BIR command which will be used when starting the report from Smart Materials Web:

select a.cg_group_code, b.short_desc

from m_commodity_groups a, m_commodity_group_nls b

where b.group_id = a.group_id(+)

and b.nls_id(+) = mpck_login.current_nls_id

and ( a.dp_id IN (SELECT g.dp_id

FROM m_us_id_display_disciplines g

WHERE g.us_id = mpck_login.current_us_id

AND g.display_ind = 'Y' ) or a.dp_id = mpck_login.current_dp_id)

/*S.10.02 Commodity Group */

In case you use other Forms parameters (for example, :block.item_name), you might contact the support for assistance which appropriate package call should be used instead.