Wednesday, March 7, 2012
Cube Processing
I have a cube, whose fact table has over 50 million records,
each day the cube is incrementally processed
as I was incrementally updating everyday it was not a problem.
but lately there was some problem while cube was processing
and cube need to be re-processed from scratch as I have lost
all the process data from year 2003.
To process 1 day data it takes around 20 minutes, please let me
know the easiler way to process the complete data from year 2003.
secondly is there anyway i can take the backup and restore it and
later which require no processing of cube and cubes data is intact.
Thanks,
MonTo do individual periods, your best solution is to use partitioning. A
typical design might be yearly partitions for all of history and monthly
partitions in the current year. This allows you to process just a particular
year (for previous years) or individual months in the current year.
On your second question, archive and restore is done at the database level.
If the database was consistent when you backed it up (i.e. no processing was
required); then it will be restored in the same state (i.e. no processing
required).
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mon" <Mon@.discussions.microsoft.com> wrote in message
news:A8E3DEF2-B4FF-4F30-95CE-800D285BB6C0@.microsoft.com...
> Hi ,
> I have a cube, whose fact table has over 50 million records,
> each day the cube is incrementally processed
> as I was incrementally updating everyday it was not a problem.
> but lately there was some problem while cube was processing
> and cube need to be re-processed from scratch as I have lost
> all the process data from year 2003.
> To process 1 day data it takes around 20 minutes, please let me
> know the easiler way to process the complete data from year 2003.
> secondly is there anyway i can take the backup and restore it and
> later which require no processing of cube and cubes data is intact.
> Thanks,
> Mon
>
Tuesday, February 14, 2012
CSV --> SQL and CSV <-- SQL
Second I would like to do what ever he is doing and create my own csv file that is outputted from a proc's output everyday. I have the proc setup so when it is run it will pull the information I need and then I copy it to excel. I would like to take the idiot user who is going to mess it up (me) out of the equation. Is there anyone that can help me with how to do this? Thanks, Ben.
Quote:
Originally Posted by ryushinyama
I have two things that I need to do. I have a csv file that comes from our distributor. It sits and is updated everyday on their website. I would like to automate a table to be dropped and updated with this information everyday. Then I can use some procs to do with it what I need to do with it.
Second I would like to do what ever he is doing and create my own csv file that is outputted from a proc's output everyday. I have the proc setup so when it is run it will pull the information I need and then I copy it to excel. I would like to take the idiot user who is going to mess it up (me) out of the equation. Is there anyone that can help me with how to do this? Thanks, Ben.
you can use DTS(Data Transformation) In SQL Server .you can also import/export wizards in enterprise manger of sql server to do this schedually.if you want to customize the control in your application ,you must use MSSQL SDK.