Hello, our company is signing up with an external company who will develop our Business Intelligence dashboard. They will be working on some KPIs and drill-through right down to team level.  

 

At the moment we have SQL stored procedures set up for each KPI, the consultant suggesting that he will put the SQL stored procedure through SSIS and then SSAS to analyse dimensions, and then feed it through performance point to present BI.

 

Now, my view is, as we already have SQL stored procedures for each of these KPIs, is there any need to feed it through SSIS? I can understand to feed it through to SSAS to create dimensions but I am unsure about the rationale behind using SSIS.

 

Please can you advise me whether you can see any reasons why they are going to use SSIS as the sql stored procedure is already provided to them, any comments would be very much appreciated.

 

Thanks in advance.