Cube roles + viewing a cube browser

Posted on 2007-10-09
Last Modified: 2016-02-13
I have created cubes using microsoft Analysis Server 2000.
There are a couple of users that need to view the Cubes.
I am going to use Terminal server or remote desktop to allow the users to connect to the analysis server.

I am going to create profiles for the users to have limited acces on the machine.
I would like to know if I can have a link on the person desktop that takes him directly to the cube browser for the cube he has access to with the only the dimensions and measures that he has access to visible.

I dont want them to have to open the analysis server mmc I just want them to go straight to the cube browser.
Question by:Stanton_Roux
    LVL 18

    Expert Comment

    You need to set up roles within SSAS. However if you're going to do that, why not let the users browse the cube via excel - that way they don't need access to the server at all, but they will have full access to the cube that their user profile has been granted righs to see.

    In Excel, Data menu -> Import External Data -> Import Data
    Set up an OLAP data source to the SSAS server and it does the rest for you.

    Author Comment

    I have tried importing the data to excel.
    I keep getting a unable to locate server error message.
    I can see the server in my network neibourhood.
    And I am able to remote desktop to it.

    I am using the Administrator username and password for the SSAS machine to log in.
    Is there anything I need to do on the server to allow access
    LVL 18

    Expert Comment

    this sounds like a configuration problem. By default SQL is locked down quite heavily.
    Run the SQL Server surface area configuration manager (start menu, sql server, configuration tools)
    Go to surface area configuration for services and connections
    open the remote connections node under the Analysis Services tree node.
    click "local and remote connections"

    You may need to restart the SQL services for this to take effect.

    Author Comment

    I dont have the configuration tools in my menu.
    I am using sql 2000 on windows server 2003
    LVL 18

    Expert Comment

    In that case it is likely to be a firewall problem; check the following ports are open
       TCP 2725
       TCP 2393
       TCP 2394


    Author Comment

    Tried opening those ports I still get the same error.
    Do I have to install the excel addin on the server.
    LVL 18

    Accepted Solution

    no, not if you're running Excel on a client PC, it just needs to be able to see the Analysis Services service - which uses those ports.

    Not sure why it won't work for you - can you access SSAS from management studio on another PC?

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Learn about cloud computing and its benefits for small business owners.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Viewers will learn how the fundamental information of how to create a table.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now