topic Re: Linking SAS to Hyperion and Cognos in Developers

Linking SAS to Hyperion and Cognos

deleted_user — Mon, 25 Oct 2010 02:50:18 GMT

Hi,

I am a begineer in SAS but we are trying to integrate all queries from Hyperion and Cognos to run straight into SAS for analytics. Is there an add on or has anyone tried linking Hyperion and Cognos to SAS for analytic purposes. Your help would be appreciated.

Regards,
Harry

Re: Linking SAS to Hyperion and Cognos

Vince_SAS — Mon, 25 Oct 2010 12:58:31 GMT

Can you provide more details on what you are trying to do? Do you want to run queries against Cognos/Hyperion from within SAS, and then perform analytics with SAS? Or something else?

I don't know the answer, but if you can provide more details I can try to find someone who does.

Vince DelGobbo
SAS R&D

Re: Linking SAS to Hyperion and Cognos

deleted_user — Mon, 25 Oct 2010 22:29:35 GMT

Hi Vince,

Thank you for your reply. I am trying to run queries within Cognos/Hyperion from within SAS and automate that procedure to deliver the results to the query to within SAS to perform analytics within SAS. What we are trying to do is automate the entire procedure to run overnight so as to keep things more automated. Thank you for your help.

Regards,
Harry

Re: Linking SAS to Hyperion and Cognos

Cynthia_sas — Mon, 25 Oct 2010 23:35:31 GMT

Hi:
I'm a bit confused. I thought that Cognos (acquired by IBM) and Hyperion (acquired by Oracle) were BI tools/solutions/platforms that worked with standard datasources, such as an Oracle database or a DB2 database. Don't Cognos/Hyperion connect to SAP data sources???? SAS can connect to many data sources such as Oracle or DB2 (and I think even SAP) directly.

So if SAS can directly access the Oracle or DB2 data, why would you want a stored process on the SAS end to "run queries within Cognos/Hyperion"? That seems an unnecessary layer of querying, if you ultimately want SAS to run analytics based on the query results.

Perhaps your Account Representative can help you figure out the best configuration to access the data that you are currently accessing with Cognos/Hyperion.

cynthia

Re: Linking SAS to Hyperion and Cognos

deleted_user — Mon, 25 Oct 2010 23:45:58 GMT

Hi ,

You are right we should be able to access actuary data straight from Oracle but we are not allowed direct access to it and only data warehouse inside SAS libraries. Some of the reports and analytics we perform is data manually pulled down from Hyperion and Cognos which is a bit of work . In order to make this process more robust and dynamic, we are looking at if it is possible to automate this process.

Regards,
Harry

Re: Linking SAS to Hyperion and Cognos

Vince_SAS — Tue, 26 Oct 2010 00:23:56 GMT

What is the general process used when you manually pull down the data? What format is the data in at this point (XML, CSV, other)? Do Cognos and Hyperion provide Web-based tools that are able to pull down the data?

Vince DelGobbo
SAS R&D