cancel
Showing results for 
Search instead for 
Did you mean: 

Running Validation (set up in Business Rules) from SSIS package

Former Member
0 Kudos

Hi Experts,

The environment:

MS BPC 10

MS SQL 2012

Visual Studio 2010 (BIDS)

I would like a SSIS data package to run SPRUNVALID and SPRUNCONVERSION (which are both in the DEFAULT.LGF) after the data load to the fact table (I used both tblFAC2Model and tblFACTWBModel to load data to test). After loading and optimising, neither of the stored procedures worked. I understand that the default logic will work in input sheets and journals (if JOURNALS.LGF is set up). The input sheets update tblFACTWBModel table, so I thought maybe this will work with SSIS data package, but it didn't.

These 2 currently works in EPM input sheets and in the data manager package.

However, running either from the SSIS package does not process any record. I tried running the Validate.dstx (this runs SPRUNVALID stored procedure called from EPM), but this does not work either.

Has anyone tried to run business rules or FX translation from BIDS? 

Accepted Solutions (1)

Accepted Solutions (1)

former_member186498
Active Contributor
0 Kudos

Hi Joey,

"after the data load to the fact table (I used both tblFAC2Model and tblFACTWBModel to load data to test" sorry but it isn't clear, are you trying to load data with script ? also in fact2? are you sure the OLAP is processed after that?

"After loading and optimising, neither of the stored procedures worked." "

However, running either from the SSIS package does not process any record. I tried running the Validate.dstx (this runs SPRUNVALID stored procedure called from EPM), but this does not work either." do you receive an error in the package logs?

Can you please explain better the sequence of the things you're trying to do?

Kind regards

     Roberto

Former Member
0 Kudos

Hi Roberto,

We are using Visual Studio (BIDS) to load TB data from .csv files to staging then to the fact tables. I tried to load data from staging initially to fac2, then to factWB in the OLE DB destination. Yes, it updates the tables and we can optimise the model after loading the data.

Anyway, in the BPC task logic tool that calls a .LGX logic file, I passed parameters (using a combination of Expressions [defined in Variables] and SQL stored procs) to the Script logic file that is evaluated at runtime and it worked!

I am sending you a screen shot.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Joey, how do you understand that your SP is not running. It is because you are not seeing any record WB table or becuase its failing with error message. And I didnt understand after loading and optimising SP's are not working. Please try deleting few converted number from fact table > then full opt > and then try running these SP's again.

You may also like to send the log file from one which has gone success and from one with issue. Thanks.

Rohit Sharma

Former Member
0 Kudos

Hi Rohit, the Script is running, but it wasn't posting any data to the fact table. Anyway, we have now make this work. Thanks!