Your SAS programs, embedded in web apps and elsewhere

Linking SAS to Hyperion and Cognos

Reply
N/A
Posts: 0

Linking SAS to Hyperion and Cognos

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
SAS Super FREQ
Posts: 304

Re: Linking SAS to Hyperion and Cognos

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Linking SAS to Hyperion and Cognos

Posted in reply to Vince_SAS
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
SAS Super FREQ
Posts: 8,866

Re: Linking SAS to Hyperion and Cognos

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Linking SAS to Hyperion and Cognos

Posted in reply to Cynthia_sas
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
SAS Super FREQ
Posts: 304

Re: Linking SAS to Hyperion and Cognos

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 5 replies
  • 1772 views
  • 0 likes
  • 3 in conversation