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!

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

Real Time Data

Status
Not open for further replies.
EFREE

EFREE

Programmer
Jun 29, 2005
41
US
I have two complex databases each with over 100 tables. We have a DTS process that runs every night to update some tables with key performances so our clients can create their own reports with ease. Each of these tables is populated by a stored procedure that calculates and puts these key performances in there respective tables. They then run reports the next day on all information from the previous day and back.

Is there a way to supply these tables real time???

ALL IDEA’S GREATLY APPRESHIATED!!!!

Eric
 
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
170
Benedito Almeida
Benedito Almeida
Komal0735
  • Locked
  • Question
how to perform partial cube processing without losing data - SSAS, SSIS
Replies
0
Views
196
Komal0735
Komal0735
KumarD
  • Locked
  • Question
How to externally access data warehouse - is SSAS needed?
Replies
1
Views
195
johnherman
johnherman
skanskan
  • Locked
  • Question
Data Mining Cubes?
Replies
1
Views
179
johnherman
johnherman
jbluedelta
  • Locked
  • Question
OLAP over HTTP and 503 error and connection time out
Replies
0
Views
199
jbluedelta
jbluedelta

Part and Inventory Search

Sponsor

Back
Top