Re: Load and Concurrency

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: mark hill (mark_at_mark-hill.com)
Date: 09/11/04

  • Next message: Jéjé: "Re: Analysis Services vs Cognos Powercubes" 
    Date: Sat, 11 Sep 2004 19:36:34 GMT

    I would also point out that it that for every role , you could end up with a
    copy of the dimension you are trying to secure in memory.

    If your dimension is big you could run into performance issues.

    Mark

    "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
    news:u9UtFCQlEHA.896@TK2MSFTNGP12.phx.gbl...
    > 1) At 700 roles you will see some impact when running Analysis Manager. It
    > will slowdown considerably. The issue is that it is written in VB and VB
    > objects must be fully instantiated before DSO can manipulate them -- DSO
    > is
    > the API which Analysis Manager uses under the covers to update your
    > server.
    > How much of an impact varies from customer to customer; situation to
    > situation. My recommendation would be for you to prototype it. You don't
    > need 700 ADSI users to do this.. just 700 roles. The actual number of NT
    > accounts doesn't matter at all. You might look at using DSO/XML as a way
    > to
    > create a database/cube with 700 roles in it. Just generate the XML, edit
    > it
    > appropriately to create your roles, change the database name and create it
    > from the revised XML. DSO/XML can be found here:
    > http://www.microsoft.com/downloads/details.aspx?FamilyID=10744518-a2be-4534-8092-6be753fcc7bf&DisplayLang=en
    >
    > If you find that you can't live with the manability of Analysis Manager at
    > this level, drop me a line and I can send you a "packet" I have on how to
    > configure dynamic security. Dynamic security has a single role, and maps
    > the
    > USERNAME to a set of allow members. Its pros are that it only takes a
    > single
    > role; its cons are that it requires considerable management structures and
    > administrative steps over and beyond what Analysis Services provides. If
    > you
    > are a member of SQL PASS, (http://www.sqlpass.org) look at their archive
    > of
    > last year's summit in Seattle. I did a presentation on dynamic security
    > there.
    >
    > 2) http access is a SQL Server 2000 Enterprise Edition feature.
    >
    > --
    > Dave Wickert [MSFT]
    > dwickert@online.microsoft.com
    > Program Manager
    > BI SystemsTeam
    > SQL BI Product Unit (Analysis Services)
    > --
    > This posting is provided "AS IS" with no warranties, and confers no
    > rights.
    >
    > "Shanmugavel" <shanmugavel@rsi.ramco.com> wrote in message
    > news:04D18CC4-C06A-4A0F-A4D7-37678EAD69A2@microsoft.com...
    >> Hi,
    >>
    >> 1. We are using Microsoft Analysis Services 2000 for BI solutions to one
    > of
    >> our customer
    >> 2. They have extensive security requirements for about 700 cube roles.
    > They
    >> also need 200 concurrent users.
    >> 3. We have used OLAP cube based security and created cube roles and
    > assigned
    >> the dimension security using analysis services.
    >> 4. We have tested the solution for 20 cube roles and three concurrent
    > users.
    >> It worked fine for that.
    >> 5. We have to apply the dimension security for 3 dimensions, and each
    >> dimension having 3 levels of hierarchy.
    >> 6. We also need to enable Visual Totals. The subtotal should indicate the
    >> total of only the visible rows.
    >> 7. For each cube role, we have created one ADSI user. We can't escape
    >> from
    >> 700 ADSI users, since we have one to one mapping from 700 users to 700
    > roles.
    >> We are connecting with the ADSI user with HTTP URL to Analysis services
    >> database.
    >>
    >>
    >> Questions
    >>
    >> 1. Whether Microsoft analysis services can handle 700 cube roles,
    >> security
    >> and 200 concurrent users?
    >> 2. What kind of license issues will arise for creating 700 cube roles ? (
    >> Considering Point 7 )
    >>
    >>
    >> --
    >> Thanks and Regards,
    >>
    >> Shanmugavel
    >
    >

  • Next message: Jéjé: "Re: Analysis Services vs Cognos Powercubes"

    Relevant Pages

    • Re: Load and Concurrency
      ... Program Manager ... > If your dimension is big you could run into performance issues. ... Dynamic security has a single role, ... >> administrative steps over and beyond what Analysis Services provides. ...
      (microsoft.public.sqlserver.olap)
    • Re: How do I do this!!
      ... "SQL Server Developers Guide to OLAP with Analysis Services" which is good ... > property and create a virtual dimension off of it. ... >> I have a customer dimension which stores the customers birth date. ... >> age range. ...
      (microsoft.public.sqlserver.olap)
    • RE: Key Uniqueness Code
      ... If dimension key for the dimension in question is not unique, as a result, ... Analysis Services dimension structure. ... You may want to consider properly normalize your underlying relational ...
      (microsoft.public.sqlserver.olap)
    • Re: Impersonating Users in Cube Browser
      ... The problem is that username impersonation is done on connection. ... To solve this problem with dynamic security you need to disconnect, ... > Click on the change user icon and enter another user id ... > The dimension members displayed haven't changed. ...
      (microsoft.public.sqlserver.olap)
    • Re: Writeback Option not Available through Dimension Wizard
      ... Perhaps you don't have Enterprise Edition. ... > I have begun to evaluate Analysis Services to replace our existing BI ... > Dimension with WriteBack. ...
      (microsoft.public.sqlserver.olap)