dbTalk Databases Forums  

Hide dimension member in AS Cube Edit

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Hide dimension member in AS Cube Edit in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
angi
 
Posts: n/a

Default Hide dimension member in AS Cube Edit - 09-06-2004 , 02:27 AM






Hi,

Is any way to hide dimension member in AS Cube Edit?
For example, I have "A", "B", "C" and "sum1", "sum2" these 5 members in the
same dimension,
sum1 = A + B
sum2 = B + C

So, I just want the Cube Edit show "sum1" and "sum2" these 2 members,
Is any way can do this?

Thanks for your time!


Angi



Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Hide dimension member in AS Cube Edit - 09-07-2004 , 12:41 PM






There is no way to do this that I know.
To an OLAP administrator (which you must be to run the cube editor in
Analysis Manager), all dimension members and all data is exposed.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

"angi" <angi (AT) microsoft (DOT) com> wrote

Quote:
Hi,

Is any way to hide dimension member in AS Cube Edit?
For example, I have "A", "B", "C" and "sum1", "sum2" these 5 members in
the
same dimension,
sum1 = A + B
sum2 = B + C

So, I just want the Cube Edit show "sum1" and "sum2" these 2 members,
Is any way can do this?

Thanks for your time!


Angi





Reply With Quote
  #3  
Old   
angi
 
Posts: n/a

Default Re: Hide dimension member in AS Cube Edit - 09-08-2004 , 08:49 PM



Yes, Thanks!
That seems only can do in MDX...

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:#vyddHQlEHA.896 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Quote:
There is no way to do this that I know.
To an OLAP administrator (which you must be to run the cube editor in
Analysis Manager), all dimension members and all data is exposed.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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.

"angi" <angi (AT) microsoft (DOT) com> wrote in message
news:OjHtpL%23kEHA.1712 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
Hi,

Is any way to hide dimension member in AS Cube Edit?
For example, I have "A", "B", "C" and "sum1", "sum2" these 5 members in
the
same dimension,
sum1 = A + B
sum2 = B + C

So, I just want the Cube Edit show "sum1" and "sum2" these 2 members,
Is any way can do this?

Thanks for your time!


Angi







Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.