If you are unable to create a new account, please email support@bspsoftware.com

 

Calling Cognos reporting based on an external (Oracle) table value

Started by Farr.P, 28 Feb 2022 10:53:36 AM

Previous topic - Next topic

Farr.P

I am brand new at this, so please bear with me :)

We have a data warehouse with a date table.  It is this date table I must query to determine whether to run a Cognos report or not.  For example, our Veterans Student Success department wants a report (report is already written) that will run on the start of term (a date already defined in the table), and two weeks before the start of term (date that must be calculated). 

Should I do trigger based reporting, use an oracle package to connect to Framework Manager (which I have not even touched yet), or can Cognos vanilla scheduling help me with this?

Thank you!

Pamela Farr

MFGF

Quote from: Farr.P on 28 Feb 2022 10:53:36 AM
I am brand new at this, so please bear with me :)

We have a data warehouse with a date table.  It is this date table I must query to determine whether to run a Cognos report or not.  For example, our Veterans Student Success department wants a report (report is already written) that will run on the start of term (a date already defined in the table), and two weeks before the start of term (date that must be calculated). 

Should I do trigger based reporting, use an oracle package to connect to Framework Manager (which I have not even touched yet), or can Cognos vanilla scheduling help me with this?

Thank you!

Pamela Farr

Hi,

Firstly, you'll need access to the table from within your Cognos instance, which involves setting up a data source connection/data server connection, and creating metadata to describe it un either a Framework Manager package or in a Data Module.

Once you have got this far, I would look at using Event Studio for this task.

Best regards,

MF.
Meep!

Farr.P

Thank you for your response!  The report I spoke of (and I should have indicated), runs out of our data warehouse also, so we're set there.  DBA is having connection issues to Framework Manager (a whole other thing), and I created a package yesterday to be defined IN Framework Manager once we fix the connection issues.

For Event Studio, is that legacy that is going away?  Is there going to be something to replace it?

MFGF

Quote from: Farr.P on 01 Mar 2022 09:38:56 AM
Thank you for your response!  The report I spoke of (and I should have indicated), runs out of our data warehouse also, so we're set there.  DBA is having connection issues to Framework Manager (a whole other thing), and I created a package yesterday to be defined IN Framework Manager once we fix the connection issues.

For Event Studio, is that legacy that is going away?  Is there going to be something to replace it?

Hi,

Event Studio isn't going away. I imagine at some point IBM will either update its UI or move its capabilities to other places, but the capabilities it supports are important, and I don't believe IBM will just abandon them.

Cheers!

MF.
Meep!