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

Newbie needs place to start

I am totally new to the BI world. I was just wondering where I should start to begin setting up a BI solution. I started trying to go through the Microsoft Anaylsis Services tutorial line for line in the MSDN website. I couldn't get the sample solution to work quite right. Should I be starting somewhere more simple to start. Please help, so far it looks a bit overwelming, especially with the terminology and examples I have seen so far from various sites about BI and Data Mining.

I think the virtual labs are a great place to start.

http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx

Each lab is 20 minutes and gives an overview of one or two technologies. Together they cover the whole BI space, and they all follow similar themes, so learning from one can work with another. Subjects include:

Business Intelligence: Building Integrated BI Solutions Leveraging SQL 2005 and Office 2007 Servers Business Intelligence: Using Business Scorecard Manager 2005 and ProClarity for Performance Management Business Intelligence: Excel 2007 PivotTables and Analysis Services Business Intelligence: Report Builder Business Intelligence: Integration Services Business Intelligence: Service Analysis Business Intelligence: Data Mining Business Intelligence: Business Scorecard Manager

Newbie - Need Help

Hi,

I'm totally newbie in this age of coding / development & need to start to jump-in in this part of IT & need help that how to start / learn client / server database development either web based or something like this using sql2000 / vs2003.net ( vb ect. ). I know that there r new versions of sql & vs.net but I've just have to manage the versions mentioned above.

Just want to let u know that I've just handed over a half completed employee's attendance system ( database running in sql2000 ) & have asked to develop the reports for the data entered daily by employee's in/out barcode card scanning.

Rather to start develop reporting, I want to understand from roots that how the database ( tables etc. ) created / linked & how / which application I need to use at front end for the reporting in this project.

Any help / idea / guideness / advise in this regard will be highly apprecitaed.

Regards / Sulman
Sulman,

I'm sorry, I'm not understanding your question very well. Are you asking for more information on the best way to do reporting out of a SQL Server database?

Thanks, MJ|||

One way of doing reporting would be using Reporting Services. Here's a bunch of tutorials here.

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

Thanks< MJ