Hi All,
We are right now testing how to use SSAS cubes with Cognos 11. One of the things I have found that the DMR report functions of report studio don't work with SSAS cubes.
Has anyone tries using SSAS cubes with Cognos 11 or previous version of cognos and faced similar challenge and what would be the work around for it.
Quote from: clivenewman on 08 Jan 2017 10:11:58 PM
Hi All,
We are right now testing how to use SSAS cubes with Cognos 11. One of the things I have found that the DMR report functions of report studio don't work with SSAS cubes.
Has anyone tries using SSAS cubes with Cognos 11 or previous version of cognos and faced similar challenge and what would be the work around for it.
Hi,
Can you provide an example of a dimensional function you are having trouble with? I've used Cognos over SSAS in the past without any issues...
MF.
Quote from: MFGF on 09 Jan 2017 03:30:46 AM
Hi,
Can you provide an example of a dimensional function you are having trouble with? I've used Cognos over SSAS in the past without any issues...
MF.
Hi MFGF,
We have tried maximum, minimum, linkmember function
Regards,
Clive
Quote from: clivenewman on 09 Jan 2017 03:41:48 AM
Hi MFGF,
We have tried maximum, minimum, linkmember function
Regards,
Clive
Hi
linkMember() doesn't work with all OLAP sources. I recall it isn't supported in TM1, for example, but I don't remember ever trying it with SSAS. What error do you see?
I'm pretty sure I've used the maximum() and minimum() dimensional summaries before. Can you tell us the exact syntax you're using and the error you get?
Cheers!
Edit: I just tried maximum(<my measure> within set <my Products level>) and it returned the exact results I'd expect. I don't have any dimensions with multiple hierarchies so I can't try linkMember()
MF.
Is there a way to connect to SSAS from Cognos when running on a Linux platform?
The technotes I read online appear to require Cognos to run on Windows, which isnt an option in our case.
We were able to successfully connect to a SSAS cube last month as a proof of concept. From what I recall, everything worked in report studio and functioned as we expected. It also worked well with the Excel add-in CAFE. I didn't personally build the cube, so I can't answer any questions from that aspect. I connected to the cube through Framework Manager which ultimately is just a pass-through. I can try and answer any specific questions you have, but as far as I can tell we have a fully functional cube within report studio.
Quote from: robblob on 17 Jan 2018 11:59:40 AM
We were able to successfully connect to a SSAS cube last month as a proof of concept. From what I recall, everything worked in report studio and functioned as we expected. It also worked well with the Excel add-in CAFE. I didn't personally build the cube, so I can't answer any questions from that aspect. I connected to the cube through Framework Manager which ultimately is just a pass-through. I can try and answer any specific questions you have, but as far as I can tell we have a fully functional cube within report studio.
Thanks Robb,
Are you running Cognos Server on Linux?
The docs I've read from IBM lead me to believe that connecting to SSAS as a data source can only be done from Cognos on a Windows platform.
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cra.10.2.1.doc/c_microsoftsqlserverandmicrosoftanalysisservices.html
Microsoft Analysis Services Data Sources
IBM® Cognos® software supports connectivity to Microsoft Analysis Services from a Microsoft Windows operating system platform.
Quote from: PKPChuck on 17 Jan 2018 12:49:44 PM
Thanks Robb,
Are you running Cognos Server on Linux?
The docs I've read from IBM lead me to believe that connecting to SSAS as a data source can only be done from Cognos on a Windows platform.
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_cra.10.2.1.doc/c_microsoftsqlserverandmicrosoftanalysisservices.html
Microsoft Analysis Services Data Sources
IBM® Cognos® software supports connectivity to Microsoft Analysis Services from a Microsoft Windows operating system platform.
Perhaps I overlooked that bit of information in your post, but no, we are not running on Linux.
Quote from: clivenewman on 08 Jan 2017 10:11:58 PM
Hi All,
We are right now testing how to use SSAS cubes with Cognos 11. One of the things I have found that the DMR report functions of report studio don't work with SSAS cubes.
Has anyone tries using SSAS cubes with Cognos 11 or previous version of cognos and faced similar challenge and what would be the work around for it.
Hi,
Is the above mentioned DMR report functions incompatible with SSAS cube model issue is resolved.
Please let me know. We are also facing the same issue in Cognos 11.
Thanks,
Akila