Re: real time data for cube processing

#1

Hello,
the best way to get the real-time data is to use the option of realtime
but it's only available on a ROLAP cube base on a SQL Server OLTP. The other
way you can schedule cube processing in a DTS Package that run each hour.
But processing cube can take alot of ressouce if you have alot of data and
slowdown your server each hour.

HTH

Best Regards,

Patrice
"Wilbur" <Wilbur (AT) icecube (DOT) com> wrote

Quote:

What is the best way to get the closest thing to realtime data into a cube
from an oltp server and processing the cube? Is this even possible?
Perhaps having one hour of latency would be ok from data creation to
readability in querying the cube. Am I missing something completely
obvious
that makes this a redicules question?

thanks in advance for the assistance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: real time data for cube processing

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: real time data for cube processing - 07-09-2003 , 07:09 AM