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!
-
Datamart and Refresh on demand
Is there a middle layer to store the metadata,if yes,is that layer can retrieve up to the minute data from the database? Right now we run complex queires through Access, and users do ask for up to the minute data as well as static reports that we run once-twice a week. Now, the compnay has...- SamAsher
- Post #3
- Forum: Cognos solutions
-
Datamart and Refresh on demand
Can I create complex queries to develop reports even though I am interested in not having a data mart (at least in the beginning), but access the database directly?, On the other hand, If the client will insist in having a data mart, can they still get the concurrent data in their report that...- SamAsher
- Thread
- Replies: 3
- Forum: Cognos solutions
-
Connecting to Database
We are considering Cognos reporting (very new), do we have to create a data mart or can we go directly against the database if we are not concerned about performance. The goal is to make sure that changes that occur, are reflected immediately when users run reports. Thanks- SamAsher
- Thread
- Replies: 1
- Forum: Cognos solutions
