locked
How to deploy SSAS cubes to another analysis server? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hi,

    I am researching on various BI tools. I want to know is it possible to use SSAS cubes in another tools?

    My findings show that we can connect to IBM cognos cubes via SSAS and vice versa. As we know we can get SSAS cubes as XMLA codes. My question is twofold:

    1-       Can we connect to SSAS database from another server like Mondrian or Microstrategy  or some others?

    2-      Can we get XMLA codes using SSAS and then generate cubes in other servers from those XMLA codes?

    I will very thankful for any solution

    Tuesday, April 26, 2011 2:15 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi farhad

    1) some other vendor client tools can connect to the SSAS server (like Microstrategy).  That is a client/server environment, not a server to server.  However, you can use SSAS as a data source for other servers like in the case of BusinessObjects universes.

    2) I dont believe you can use XMLA from SSAS in other vendor's OLAP software. Thought XMLA is a standard, my understanding is that XMLA-scripted SSAS objects can only be used in SSAS. The reason i think this is that the xml namespace in the declaration specifies the analysis service engine...



    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx
    Tuesday, April 26, 2011 2:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi farhad

    1) some other vendor client tools can connect to the SSAS server (like Microstrategy).  That is a client/server environment, not a server to server.  However, you can use SSAS as a data source for other servers like iThank you n the case of BusinessObjects universes.

    2) I dont believe you can use XMLA from SSAS in other vendor's OLAP software. Thought XMLA is a standard, my understanding is that XMLA-scripted SSAS objects can only be used in SSAS. The reason i think this is that the xml namespace in the declaration specifies the analysis service engine...



    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx

    Hi,

    Thank you Javier

    So, Can I connect to SSAS from Jasper report builder to design reports?



    Saturday, April 30, 2011 11:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have no experience with Jasper,but based on the forum link it seems to be possible.

    http://stage.jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=60459

     



    Javier Guillen
    http://www.msbicentral.com/Blogs/JavierGuillen.aspx
    Saturday, April 30, 2011 6:37 PM