Hide dimension member in AS Cube Edit

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!
AngiUse "Hide Member If" advanced property of a level in the properties pane of
Dimension Editor (if the dimension is shared) or Cube Editor (if the
dimension is private). Properties are at the bottom of the left pane of
Analysis Manager.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"angi" <angi@.microsoft.com> wrote in message
news:usi3WuHlEHA.3648@.TK2MSFTNGP09.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
>

Hide dimension member in AS Cube Edit

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
Use "Hide Member If" advanced property of a level in the properties pane of
Dimension Editor (if the dimension is shared) or Cube Editor (if the
dimension is private). Properties are at the bottom of the left pane of
Analysis Manager.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"angi" <angi@.microsoft.com> wrote in message
news:usi3WuHlEHA.3648@.TK2MSFTNGP09.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
>

Hide [+]/[-] toggle sign when group doesnot have any member

Hi,

I need help to hide [+]/[-] sign when a group doesnot have any item in it. Currently, I have a table with a group header where I put the companyName and in the detail section I put the users for that company. I want that, if a company doesnot have any users then there should not be any [+]/[-] sign next to it. Please help!!

Thanks,

-Rohit

Does any one know the answer to this one?

Thanks.

Hidden member causes Excel to throw error

Hi,

I have an AS2000 utility dimension that hold one calculated member and one 'dummy' member for the fact - dimension join. I use it in a virtual cube to achive currency conversion and I implemented the utility dimension to be able to use it with the aggregrate function that Excel uses on multiple filter selections.

I want to prevent this dummy member to appear in my Excel pivot table. I have tried to use the setting 'Hide member if -No name' and it works great when I browse my cube in ASManager but when I browse it Excel 2007 I get a popup message saying something like 'member could not be found...'

Any idea?

Thanks,Christer

It has been some time since I have worked with AS2000 but I think there is a "Visible" property that you can set on your dummy member.

Another way can be to remove the parent for the calculated member in you shell dimension. Only use the dimension without parent member.

HTH

Thomas Ivarsson

|||Another thing to try is to change the default member for this dimension to point to the calculated member.