Hi,

is there a way to hide measure from calcuation code.
Something like assigning default member:
ALTER CUBE CURRENTCUBE UPDATE DIMENSION Measures,
DEFAULT_MEMBER=[Measures].[Profit]My original problem is: I want to have
measure group that containsjust calculated measures. I have to leave at
least one measure in measure groupso that measuregroup is visible in
perspectives. But during cube execution I would like to hide that measure.
Is there any other way of doing this?Thanks

Hi Vimas,

Thank you for using MSDN Managed Newsgroup Support.

From your description, my understanding of this issue is: You want to hide
a measure when you access the cube. If I misunderstood your concern, please
feel free to let me know.

You can easily change the Visible property of a measure to False.

Hope this will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks Wei, that works.
Somehow I thought that after I make Visible property value False, I will not
be able to add it to Perspective. That is not a case. Now I have a measure
that is not visible.

Thanks again.


"Wei Lu" <weilu (AT) online (DOT) microsoft.com> wrote

Hi Vimas,

Thanks for the update. Glad to hear the information is helpful.

If you have any questions or concerns, please feel free to let me know.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.