none
Unanswered posts!! RRS feed

  • Question

  • I just would like to know if there is a reason behind not answering my question in the previous posy entitled (Trigger SSIs package through performance point 2007)…

    if there is no clear answer for the mentioned problem up till now,  I think this should be somehow clear (for me at least). But waiting for the answer for about 3 days till now is not something good at all.

    please inform me if the problem has not clear answer.

    The problem again:

    Hi all,

    I am currently working on a Real-time BI project. We are developing a Dashboard that connects to a ROLAP cube, the cube is fed with data from a UDM (Data warehouse). An SSIS package connects to external 3rd party application's DB and feeds the UDM. So where is the problem?

    Our goal is to enable end-users to view real-time data in the PP's Dashboard, i.e. when the end-user opens the dashboard it is supposed to trigger the SSIS package to go and get the required data, feed it in the data warehouse and the ROLAP cube now contains the most up-to-date data.

    The question is: What mechanism can we follow in order to make the SSIS package triggered to execute when the end-user opens the PP’s Dashboard?”

     

    I am using MS SharePoint for opening the Dashboard.

    Please let me know if further business requirements are needed.

     

    Saturday, August 9, 2008 10:56 PM

Answers

All replies

  • I understand you want to display the real time data in the dashboard. But in reality its not that easy to display the data the way you are expecting. Let me explain.

    What will happen in your scenario, User opens the Sharepoint Site, the dashboard page and now lets say the SSIS package is triggered (not explaining how, just the scenario), now the data transformation happens and data loaded to Cube (which means the cube is processed). So user have to wait until these operations are completed. How much time do you think this activitities would take? do you really want to make the user wait till all these background work gets completed? whats the assurance that the cube or SSIS transformation won't break in between due to some issues and user gets an error page?

     

    So the better way is to schedule the SSIS transformation and cube processing in a SQL job and execute it in regular interval. This way you can atleast get near real time data in the dashboard, and this is easy to trace the exceptions as well.

    Monday, August 11, 2008 5:39 PM
  • If the community is not responding, consider opening a support case: https://support.microsoft.com/oas/default.aspx?ln=en-us&prid=11773&gprid=528610

     

    I would consider using proactive cache settings for your ROLAP cube: http://www.microsoft.com/technet/prodtechnol/sql/2005/rtbissas.mspx

     

    The amount of time required to kick off an SSIS package to populate data, query and retrieve data, as well as render a dashboard would likely be unacceptable to end users.

     

    HTH,
    Shannon

    Monday, August 11, 2008 8:14 PM
  •  

    The impact on the current user is not the only thing you should be concerned with.  All other users connected to the cube database will be impacted while the SSIS package is in progress.  Although this may not be technically accurate as to what is going on, I equate it to a table lock during updates on a relational database.  Performance will get clobbered.

     

    I view PerformancePoint as an Analytic tool, not a realtime reporting system.  For realtime reports requirements, I would look more towards SQLServer Reporting Services running against your warehouse database.  You can put the SSRS reports as links within your sharepoint site so that they seem somewhat intergrated.  You will be much better performance going this route.

    Wednesday, August 13, 2008 7:45 PM