Microsoft SSAS with Cognos Front End

Tags:
Cognos
SQL Server
SSAS
SSIS
Is there anyone out there that is working or has worked with a Microsoft back-end (SQL SVR 2005, SSIS, SSAS) and a Cognos front end ? What is your experience with this ?

Answer Wiki

Thanks. We'll let you know when a new response is added.

We have been using Cognos front-end with SQL 2005 back-end for about 1.5 yrs – using SSIS for copying/transforming data from Cognos to our accounting system, but not using SSAS with it (and no plans to that I’m aware of). Just have the normal DBA jobs to dynamically back up any user database nightly ( databases = ‘stores’ in Cognos) and perform other normal maintenance jobs, such as shrinking the logs – since the db’s are in simple mode, and the normal health checks. Otherwise we just monitor the databases for disk space usage and try to touch them as little as possible – don’t want to break the app ;) Internally we have another team that uses the Cognos front-end – we DBAs just keep it running smoothly.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Eim
    Yes I did implement last year using SQL 2005 Analysis Services Cube and it is working perfectly. There was initial problem but once you startup your Cognos Service using account, which has SQLcube access then no issue. Please let me know if you have any question.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following