Running validations

[Former Member]

Hi,

I have a question about the validation business rules package. Under BPC 5.1 I had a package that ran just the validations (runvalidation.dts in the system files folder). I am now looking to build the same in 7.5 but there is no package of the same or of a similar name.

I have looked everywhere on the server, but there is no file that seems like it could be what I am looking for. Has this been removed in 7.5?

I tried to copy the file from my 5.1 BPC but when I add it as a package I get an error message.

Anyone got any ideas?

[Former Member · Accepted solution]

Hi,

The validations business rule can be called through a stored procedure. Please take a look at the parameters of this stored procedure in the below link from help.sap:

http://help.sap.com/saphelp_bpc75/helpdata/en/f1/776c150c054770b60d658c11c1015e/content.htm

You can call this in a script logic and you can have a DM package which will call that script logic.

Hope this helps.

[Former Member · Accepted solution]

How do I create a package that calls the script logic from the XL interface?

[Former Member · Accepted solution]

The easiest way to have the logic execute when data is sent through excel templates, is to add the SPRUNVALID code to the default logic script file.

[Former Member · Accepted solution]

Hi,

If you want the validation to run every time data is sent, you can have it in the default logic. However, if this is not desired, then you can have it in a script logic and this script logic should be called from the DM package. Please refer to example packages like FX restatement or Currency conversion. These DM packages call a script logic. So, you can copy this DM package and just change the name of the script logic it is calling.

Hope you got the idea.