none
Publishing the SSAS cube?

    Question

  • Hello,

    I've got that cube I built. With dimension, and their hierarchies.
    I can browse that cube in ssas. Its really neat: reordering my measures by its dimensions.

    How can I publish that cube so other can use it as well? Taking advantage of the defined hierarchies and so on?

    Or is there another way to utilize this information?

    Thank you in advance.
    Wednesday, January 14, 2009 6:14 PM

Answers

  • Take a look at the following, again, even via web, there a lot of options. What are the user requirements? Sorry, but to really be helpful, more specifics are needed. The question right now is kinda of like "I need a house", but how big, where, how many rooms, etc.
    Here are the links:

    http://technet.microsoft.com/en-us/library/bb326358.aspx

    http://technet.microsoft.com/en-us/library/aa964121(SQL.90).aspx

    http://technet.microsoft.com/en-us/library/aa964126(SQL.90).aspx

    Excel 2007 can be published in SharePoint 2007 with links to the cube or perspectives in the cube: http://technet.microsoft.com/en-us/magazine/2009.02.bookbi.aspx
     
    but you will need to make sure Kerberos is the default authentication on your network, most people use NTLM: http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx

    Sid Atkinson -- www.sidatkinson.com
    • Marked as answer by Somcello Friday, January 16, 2009 9:43 AM
    Thursday, January 15, 2009 4:25 PM
  • Somcello said:

    Hello and thank you for your replies.

    So, the cube I built in SSAS is just the multidimensional database which enables a faster and more efficient way of querying and reporting than? But I liked the fast way I could access the datas there.

    Anyways, I've in mind two scenarios:

    1. Reports with some parameters to be specified using that cube - I could imagine this could be done by the Report Models as suggested and consumed by the (standard) user via a webbrowser.
    2. Excel (2007 ?) to analyze the data in an even more dynamic way (mirroring the functionality the browsing of the cube in ssas offers) so more experienced user and analysts could go crazy.

    I already tried a simple example (SQL Tutorial) how to create a report using a report model. But somehow stuff like user defined hierarchies were missing and the overall experience concerning the responsiveness was sluggish.

    Thank you for any helpful input in advance.



    I really don't like the way report models work (or fail to work) with SSAS. If you have standard format reports that you want to present in SSRS with some parameters you can setup a connection SSAS and use "standard" reports. I know of plenty of people using reporting services, but I don't know of anyone using report models in production.

    You can connect to the cubes using both Excel 2003 & 2007, but Excel 2003 is not "multi-hierarchy" aware so the experience is not quite as good.
    http://geekswithblogs.net/darrengosbell - please mark correct answers
    • Marked as answer by Somcello Friday, January 16, 2009 9:44 AM
    Friday, January 16, 2009 3:09 AM

All replies

  • You can publish the cube in a sharepoint site, but how we do that i don't know i would be intrested to know that.I guess you have to ask in share point forumz, i am just guessing.
    Another way that your cube can be browsed is using EXCEL depends on what you are using 2003/2007
    And this might be useful.

    Thanks
    D
    Wednesday, January 14, 2009 7:29 PM
  • You can create an excel of your cube and then upload that in a share point site which would be
    a site where any authorize person can access the informations

    a similiar example
    http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/73d8379e-8789-42a5-87c5-70876e5d1676
    D
    Wednesday, January 14, 2009 7:42 PM
  • You won't "publish" the SSAS database to anything other than the Analysis Server -- what you want to do is provide access mechanisms to the Analysis Services database where your cube is now published. There are untold numbers of possibilities here, it all depends on your environment, web, windows, distributed, etc.

    Common Microsoft end user reporting tools are Reporting Services, particularly using Report Models, Excel 2007, and ProClarity. Even Access is a possible delivery mechanism. All of the fore stated can be implemented in a web or windows environment. Let us know what your parameters are and then we can discuss options.
    Sid Atkinson -- www.sidatkinson.com
    • Proposed as answer by Mahesh_Hegde Thursday, January 15, 2009 11:01 AM
    • Unproposed as answer by Somcello Thursday, January 15, 2009 1:27 PM
    Wednesday, January 14, 2009 8:01 PM
  • Hello and thank you for your replies.

    So, the cube I built in SSAS is just the multidimensional database which enables a faster and more efficient way of querying and reporting than? But I liked the fast way I could access the datas there.

    Anyways, I've in mind two scenarios:
    1. Reports with some parameters to be specified using that cube - I could imagine this could be done by the Report Models as suggested and consumed by the (standard) user via a webbrowser.
    2. Excel (2007 ?) to analyze the data in an even more dynamic way (mirroring the functionality the browsing of the cube in ssas offers) so more experienced user and analysts could go crazy.

    I already tried a simple example (SQL Tutorial) how to create a report using a report model. But somehow stuff like user defined hierarchies were missing and the overall experience concerning the responsiveness was sluggish.

    Thank you for any helpful input in advance.
    Thursday, January 15, 2009 11:01 AM
  • Take a look at the following, again, even via web, there a lot of options. What are the user requirements? Sorry, but to really be helpful, more specifics are needed. The question right now is kinda of like "I need a house", but how big, where, how many rooms, etc.
    Here are the links:

    http://technet.microsoft.com/en-us/library/bb326358.aspx

    http://technet.microsoft.com/en-us/library/aa964121(SQL.90).aspx

    http://technet.microsoft.com/en-us/library/aa964126(SQL.90).aspx

    Excel 2007 can be published in SharePoint 2007 with links to the cube or perspectives in the cube: http://technet.microsoft.com/en-us/magazine/2009.02.bookbi.aspx
     
    but you will need to make sure Kerberos is the default authentication on your network, most people use NTLM: http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx

    Sid Atkinson -- www.sidatkinson.com
    • Marked as answer by Somcello Friday, January 16, 2009 9:43 AM
    Thursday, January 15, 2009 4:25 PM
  • Okay,

    at the moment I can't give any more details because I'm just too inexperienced. But I'm pretty sure that house should have a bathroom, a kitchen and at least to other rooms.
    I'll go through the links you've provided.

    Thank you so far.
    Thursday, January 15, 2009 9:02 PM
  • No problem -- when you get the chance, post the user scenario so you can get help. The fun, and the pain for new developers, is that there are some many ways to utilize these tools that it can be mind boggling when you first jump in.

    Feel free to leave this thread open if you want to follow up shortly with more questions, otherwise go ahead and close it out, and when you have some more detailed questions, feel free to post again and everyone here will be glad to help.
    Sid Atkinson -- www.sidatkinson.com
    Thursday, January 15, 2009 10:08 PM
  • Somcello said:

    Hello and thank you for your replies.

    So, the cube I built in SSAS is just the multidimensional database which enables a faster and more efficient way of querying and reporting than? But I liked the fast way I could access the datas there.

    Anyways, I've in mind two scenarios:

    1. Reports with some parameters to be specified using that cube - I could imagine this could be done by the Report Models as suggested and consumed by the (standard) user via a webbrowser.
    2. Excel (2007 ?) to analyze the data in an even more dynamic way (mirroring the functionality the browsing of the cube in ssas offers) so more experienced user and analysts could go crazy.

    I already tried a simple example (SQL Tutorial) how to create a report using a report model. But somehow stuff like user defined hierarchies were missing and the overall experience concerning the responsiveness was sluggish.

    Thank you for any helpful input in advance.



    I really don't like the way report models work (or fail to work) with SSAS. If you have standard format reports that you want to present in SSRS with some parameters you can setup a connection SSAS and use "standard" reports. I know of plenty of people using reporting services, but I don't know of anyone using report models in production.

    You can connect to the cubes using both Excel 2003 & 2007, but Excel 2003 is not "multi-hierarchy" aware so the experience is not quite as good.
    http://geekswithblogs.net/darrengosbell - please mark correct answers
    • Marked as answer by Somcello Friday, January 16, 2009 9:44 AM
    Friday, January 16, 2009 3:09 AM