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