Can I hide displaying a certain member?

Hi,

I have a dimension called customers having the following levels:

ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name

Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"create a view on the table like select col1,col3 from the table and access (http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21175087.html#) the view.|||Thanks for the reply. Yup it seems that the view approach is what I will have to go with.

Can I get the values of a level in a dimension by using AMO?

I wnat to get the values of a level in a dimension by using AMO(Analysis Management Object), but I don't know that is it possible ?

Does anyone know that,please tell me how to do and show a sample if possible . Thank you~

Hi Kasper,

Please try use ADOMD.net to get the values instead.

Yan

Can drill through reports display parameters

I have a top level report in which I am select a particular run. The id for
that run is passed to a child report which uses the id from that run to
generate a list of possible values to generate the drill through report. My
problem is that I seem to have to set both values from the top level report
and then the second report does not show the parameters. If I browse
directly to the second report then I have the option of entering parameters.
Should I be able to see parameters when drill into a reportI forgot to mention that when I am in the designer the parameters are always
visible, but when I deploy to website and try to browse the report, that is
when they ar not visible.
"slumley" wrote:
> I have a top level report in which I am select a particular run. The id for
> that run is passed to a child report which uses the id from that run to
> generate a list of possible values to generate the drill through report. My
> problem is that I seem to have to set both values from the top level report
> and then the second report does not show the parameters. If I browse
> directly to the second report then I have the option of entering parameters.
> Should I be able to see parameters when drill into a report|||I have the same problem but only with the latest CTP (Sept), it worked fine
in the June version.
"slumley" wrote:
> I forgot to mention that when I am in the designer the parameters are always
> visible, but when I deploy to website and try to browse the report, that is
> when they ar not visible.
> "slumley" wrote:
> > I have a top level report in which I am select a particular run. The id for
> > that run is passed to a child report which uses the id from that run to
> > generate a list of possible values to generate the drill through report. My
> > problem is that I seem to have to set both values from the top level report
> > and then the second report does not show the parameters. If I browse
> > directly to the second report then I have the option of entering parameters.
> >
> > Should I be able to see parameters when drill into a report

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.
No, you will have to change it at the connection level.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.No, you will have to change it at the connection level.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.

Can default Isolation Level be changed?

Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.No, you will have to change it at the connection level.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Sydney Delieu" <syddel@.hotmail.com> wrote in message
news:OzlpNXxLEHA.1156@.TK2MSFTNGP09.phx.gbl...
Hello,
Just wondering if the default Isolation Level can be changed for an
entire database (or server) instead of having to issue a 'SET ISOLATION
LEVEL...' for a connection.
Many thanks,
Syd.