Post reply

How do I access cube

  • November 29, 2009 at 9:42 pm

    #214413

    Hi,

    I have created a cube user analysis server (SSAS) and deployed as well. I am able to access through SSAS browser tab.

    Now, I want to give access to my clients.

    How do I do this? Do I need to write any programme for this.

    Can any one help me!!

    Thanks in advance,

    keerthy

  • November 29, 2009 at 9:47 pm

    #1085232

    Either of these links should help you to start.

    Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003

    Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows XP

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • November 29, 2009 at 10:17 pm

    #1085238

    Thanks, will go through this articles.

  • November 30, 2009 at 12:29 am

    #1085264

    You can follow below steps:

    1. Create a new Role and add required users in Membership tab of Edit Role wizard.

    2. Give Read Access to Data Sources and Cubes.

    3. Create Excel Pivot Report via connecting the Cube through Excel Services.

    4. Publish Excel report.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • November 30, 2009 at 6:53 am

    #1085375

    Hi

    You could also use Reporting Services & Report Builder.

  • November 30, 2009 at 5:21 pm

    #1085598

    You can also use Analyzer, our front-end for Analysis Services, to make it easy for you and your non-technical business users to access and work with the data in your cube(s). You can download a free trial version from our web site at http://www.strategycompanion.com and use it with your cube(s). It installs quickly on IIS. You will also find free, bite-sized On-Demand Training videos under "Support".

  • December 2, 2009 at 2:04 am

    #1086310

    Hi,

    There are a variety of ways to allow your clients to access AS Cubes, and the best one for you will depend on what you're trying to do. Excel is by a long way the best way for clients to interact with cubes. Excel 2007 has built in abilities to connect to cubes allowing users to "slice and dice" and run ad-hoc queries. If that's not an option, then there are a number of excellent plugins for Excel 2003. Check out Intelligencia, XLCubed, to name but a few.

    Alternatively there are some thick clients which users can have on their desktops (e.g. Panorama, ProClarity, Business Objects), or your users could access via the web. SharePoint (via PerformancePoint / Excel Services / Reporting Services ), Reporting Services (standalone), Panorama, etc. are all tools which allow this.

    Finally you could interrogate the cube programatically via XMLA or ADOMD.Net. So lots of methods and the best one for you will be based on what your trying to, what your clients have got and how much you can spend 🙂

    J.

  • December 2, 2009 at 5:46 am

    #1086393

    Thanks a lot for the intime help.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply