Re: Hiding Dimension Members

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

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 11/13/04 

Date: Fri, 12 Nov 2004 16:38:28 -0800

As Mosha said, it depends on in what context you are hiding things.

If for *all* users, then you can hide complete cubes, dimensions, levels,
measures, or member properties from end users who browse cubes with client
applications. The visibility of these objects is controlled by the Visible
property. For more information, see Properties Pane (Cube Editor Data View)
and Properties Pane (Dimension Editor Data View). Likewise for *all* users,
you can use the "Hide Member If" property in the Dimension Editor to expose
a ragged hierarchy -- by hiding some members.

If you are hiding members for only certain users then this is what Mosha
called "secured members".

Does that answer your question? 

-- 
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.
"Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
news:e20UnPKyEHA.2212@TK2MSFTNGP15.phx.gbl...
> But you can use this to hide specific members - lets say I have a
> dimension A with members A-1-1 and A-1-2 and I can make a calculated
member
> A-1 and
> then hide A-1-1 and A-1-2 ?
>
> "Mosha Pasumansky [MS]" <moshap@online.microsoft.com> wrote in message
> news:#Nh8s#DyEHA.1404@TK2MSFTNGP11.phx.gbl...
> > > So it can be done ?
> > The question deals with hidden members, not with secured members.
> Calculated
> > members can refer to hidden members, but cannot refer to secured
members.
> >
> > --
> > ==================================================
> > Mosha Pasumansky  - http://www.mosha.com/msolap
> > Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
> > Development Lead in the Analysis Server team
> > All you need is love (John Lennon)
> > Disclaimer : This posting is provided "AS IS" with no warranties, and
> > confers no rights.
> > ==================================================
> >
> >
>
>

Relevant Pages

  • Re: Checking if all records are processed.
    ... The cubes are processed at night, ... some members is missing. ... > switch on the option to fail the processing on dimension key errors? ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube and Dimension Processing
    ... I guess you have enough power for process your cubes each hour. ... Will you use a dedicated SSAS server to perform this process or will ... dimension you will need to perform a Full process in you cubes. ... addition of new members but no changes in existing members ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube and Dimension Processing
    ... We are using a dedicated server for SSAS. ... Refrsh/ProcessUpdate on dimension and with Changing Dimension property ... I guess you have enough power for process your cubes each hour. ... addition of new members but no changes in existing members ...
    (microsoft.public.sqlserver.olap)
  • RE: Calculating Max Usage with OLAP
    ... to answer your question about how to only build aggregations at ... dimension and then looking at the Advanced tab in the properties pane). ... The combined number of members on both these ... > Max Used Licenses means –how many concurrent licenses have been used during ...
    (microsoft.public.sqlserver.olap)
  • Re: Problem with Member Counts and applying filters using MDX in M
    ... Now i am trying to count the "members" in this big dimension based on ... various possible filters that the user might apply. ... So far i am able to get the count of members on this big dimenion with one ... Here is the MDX i am trying.... ...
    (microsoft.public.sqlserver.olap)