SAP Commissions - Custom Stored Procedure for Reporting

[former_member726161]

Hi Experts,

I am new to SAP Commissions and currently we are trying to creating a report on SAP Commissions.

Based on the report requirement, we need to create a custom stored procedure on SAP Commissions Hana Database to run certain query and process before the data could be shown on the report.

Wondering how to link this custom stored procedure with generate statement on Pipeline process.

If it is not possible, wondering what approach could be used in order our custom stored procedure could be called before generating statement on pipeline process.

Appreciate your kind help and guidance.

Thank you in advance.

Best Regards

[kprem · Accepted solution]

You will need to open a support ticket requesting

ODSReportsGenerationConfig.xml. Once you receive add your custom procedure at the end and request for migration.

Below is a sample that you can use.

Replace TENT with your tenanted and BUILD_REPORT_DATA.RPT_EXTRACT_DRIVER with your procedure name

<storedprocedure name="BUILD_REPORT_DATA.RPT_EXTRACT_DRIVER" schema="TENTEXT" >
<args>
<name>processingUnitSeq</name>
<name>periodSeq</name>
</args>
</storedprocedure>

[former_member726161 · Accepted solution]

Hi Prem,

Thank you so much for the information shared.

Will raise an incident for requesting ODSREportingGenerationConfig.xml to support team. Wondering what component should be chosen for requesting this file on the support ticket ?

Regarding the XML file, is <name>processingUnitSeq</name> for business unit ?

Appreciate your kind advice and guidance.

Thank you in advance.

[DChristenson · Accepted solution]

the <name> entries determine which parameters are passed into your custom stored procedure so you only include the parameters that are required.

<name>processingUnitSeq</name> is the actual processing unit seq - tied to a business unit

It is pretty common to pass the periodSeq to a custom procedure in order to focus the procedure results on the period selected in the pipeline.

Hope that helps a bit.