How to hide unwanted dimension values in SSAS cube

[burakcan]

Hello,

There is a key in my fact table which I don't want to show them in the cube.
I mean I redirect some values as a -1 key (N/A) in fact table.
In dimension table -1--> N/A.
I am trying to hide those N/A values in the dimension to not to show them to the user.
Any suggestion?

Thanks...

 

[Motlatjo]

Hi Burakcan

When Editing you Cube Dimension, click on the field you want to hide, and in the properties window, set AttributeHierachyVisible to False

Regards