| Author |
frequent rebuild of cube
|
|
| Jesse Aufiero 2005-04-27, 11:23 am |
| Hello,
I have a cube that I'd like to refresh every 5 minutes or so.
Can it be detrimental to refresh a cube so frequently?
If I have users who use PivotTable services to view the cube's results, what
will their experience be like when they query the cube while it is
rebuilding (the rebuild takes around 15 seconds).
Thank you!
Jesse Aufiero
| |
| Francesco Anti 2005-04-27, 11:23 am |
|
"Jesse Aufiero" <jaufiero@moaboil.com> wrote in message
news:OUwcKfzSFHA.204@TK2MSFTNGP12.phx.gbl...
> Hello,
>
> I have a cube that I'd like to refresh every 5 minutes or so.
> Can it be detrimental to refresh a cube so frequently?
Have you considered Real-Time OLAP?
> If I have users who use PivotTable services to view the cube's results,
> what will their experience be like when they query the cube while it is
> rebuilding (the rebuild takes around 15 seconds).
OLAP Server keep a copy of old data while processing. Old data are replaced
only when processing ends: in this moment the users will see a blank pivot
table. They must then push "Refresh Data" button to see them.
>
> Thank you!
>
> Jesse Aufiero
Bye!
Francesco Anti
| |
| Jesse Aufiero 2005-04-27, 11:23 am |
| Real-Time OLAP sounds like it would be a good fit for us. Does Microsoft
provide this? Is there an add-in for Analysis Services. I'd love to hear
more!
Thanks!
"Francesco Anti" <fanti_@_sicosbt.it> wrote in message
news:%23m6B3wzSFHA.336@TK2MSFTNGP09.phx.gbl...
>
> "Jesse Aufiero" <jaufiero@moaboil.com> wrote in message
> news:OUwcKfzSFHA.204@TK2MSFTNGP12.phx.gbl...
>
> Have you considered Real-Time OLAP?
>
>
> OLAP Server keep a copy of old data while processing. Old data are
> replaced only when processing ends: in this moment the users will see a
> blank pivot table. They must then push "Refresh Data" button to see them.
>
> Bye!
> Francesco Anti
>
| |
| Francesco Anti 2005-04-27, 11:23 am |
| Real-time OLAP features require a SQL Server 2000 data source to be used
when creating the cube and some other requirements.
Search for "Real-Time OLAP" and "Real-Time cubes" in BOL
Francesco Anti
"Jesse Aufiero" <jaufiero@moaboil.com> wrote in message
news:uY22n1zSFHA.2124@TK2MSFTNGP14.phx.gbl...
> Real-Time OLAP sounds like it would be a good fit for us. Does Microsoft
> provide this? Is there an add-in for Analysis Services. I'd love to hear
> more!
>
> Thanks!
>
>
> "Francesco Anti" <fanti_@_sicosbt.it> wrote in message
> news:%23m6B3wzSFHA.336@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Deepak Puri 2005-04-27, 8:25 pm |
| For Analysis Services 2000, you can also refer to this MSDN paper on
Real-Time OLAP (AS 2005 has other features):
http://msdn.microsoft.com/library/d...y/en-us/dnsql2k
/html/sql_real-timeolap.asp[color=darkred]
The Reality of Real-time OLAP
Dennis Kennedy
Microsoft Corporation
February 2003
Applies to:
Microsoft® SQL Server™ 2000 Analysis Services
Summary: Discover the functionality and implementation of real-time
OLAP, a key feature of SQL Server 2000 Analysis Services. (11 printed
pages)
...[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
|
|
|
|