Newbie Question - Automatically update

Maybe my question is not at the right place but I'm totally new to this.

So I have the following scenario:

I have a DB with one table with five records. I create a cube on this. Based on the cube I have to show some KPIs. Everyday I have one more record in my table. If someone clicks on this site it has to show the current uptodate KPIs every day. How can I do this?

If I understand right I have to process the cubes manually to show the actual datas from the DB. Is there a way to automate this somehow?

thanks for any your help

Create an integration services package that processes the cube and then create a job with the Sql Server Agent that consists of running this package. Schedule the job to run once nightly. If you need more flexibility then integration services offers you you'll have to write your own .Net program with AMO and then schedule it similarly but normally this shouldn't be needed.|||

First, thanks for the quick answer it helped me a lot.

The only what I don't really know how to process the cube in the Integration services package. Could you please help me with this?

|||

SSIS has a Processing task - from memory it looks like a little cube - which you can drag onto your control flow. You then set which objects you want to process.

Another option may be proactive caching - it depends on your structures and what sort of transformations you are doing to your data. In a way it allows you to configure your cubes to process themselves.

see: http://www.microsoft.com/technet/prodtechnol/sql/2005/rtbissas.mspx

|||

Thanks Guys it helped me a lot.

Is there a way to run this from the site? I mean If the user would like to refresh the datas click on a button and it processes the cube and refreshes the data.

|||

I'm assuming you'll have to write some code yourself - either to run the package or agent job programmatically which seems to be described here (though I haven't tested it myself):

http://msdn2.microsoft.com/en-us/library/ms403355.aspx

Alternatively you bypass the package entirely and writes a program in AMO that works directly at Analysis Services and processes the cube. AMO is described here:

http://msdn2.microsoft.com/en-us/library/ms345092.aspx