Linking SAS to Hyperion and Cognos

[deleted_user]

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

[Vince_SAS]

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

[deleted_user]

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

[Cynthia_sas]

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

[deleted_user]

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

[Vince_SAS]

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