Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Frequency of processing a cube?

Status
Not open for further replies.

StevenK

Programmer
Jan 5, 2001
1,294
GB
What is a sensible period of time to leave between the processing of a cube?
The cube is to highlight unpaid invoices - and is to form the basis of a Microsoft Excel pivot table report.

I don't want the client to run this report (having entered in some payments against invoices) and find the spreadsheet does not reflect this...
But similarly don't want to snarl up the clients server with the (re-)processing of this cube...

If anyone can suggest how often they reprocess cubes (via a DTS package) this would be a great help.
Thanks in advance.

Steve
 
I would think the refresh rate would be driven by business needs/requirements.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top