INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...The forum looks great! You guys have done a fantastic job on arranging things there...Your site is very precise and fun to visit..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Project and Data Management > Data Management Programming Tools > Cognos solutions Forum

Cognos Data Source question

Read More Threads Like This One

Accpac2010 (Programmer)

25 Sep 10 21:59

Hi all,
I am planning to use Cognos to create reports for our finance group. I want to get some views whether I should use the financial database as the data source or should I create a new database only for reporting where I copy the desired tables into it. The requirement are to drill down to the line details so I am kind of concerned to have to copy daily transaction tables to the new database.
What's the best practice in this regard,
Thanks in advance.
Bruce

drlex (TechnicalUser)

26 Sep 10 3:27

Bruce,
The choice is often made by the report users and/or the DBA. Use of the financial database directly will give you "live" data, but this can bring with it two issues
- a report can have different values at different times of the day (underlying data has changed);
- performance, as you are "competing" with other users for DB access.
Be wary that what starts as a couple of reports can often end up in an entire analysis suite, with the resultant draw of the DB services.
Lex

soi là, soi carré

blom0344 (TechnicalUser)

26 Sep 10 14:56

If the financial analysis permits it (the latency), then there is also the option to perform a complete database copy overnight. On Oracle/Unix this was called a 'flashcopy'. (No idea how they did it, but Terabytes of data where involved.)

The benefit was the ability to use existing models and reports on 'life' data for special purposes (like in-time fraude detection)

Ties Blom

Accpac2010 (Programmer)

27 Sep 10 13:14

If I understand correctly does this mean I have to create a daily copy of the operation transaction database to a database lets say copy_operation and off of that create another database that would be like datawarehouse lets say reporting_datase with less joins for reporting? Is this correct.
Bruce

blom0344 (TechnicalUser)

27 Sep 10 14:09

No ,the idea is that transaction database and reporting one have the same structure. Performance may be an issue then, but with the right setup heavy queries will not interfere with transactional traffic.

As said, this is a heavy compromise, not a substitute for a real DWH (that is designed for optimized reporting)

Ties Blom

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Cognos solutions