Hi,

I have dimension [Report Date] that has levels [Report Yr],[Report
Qtr],[Report Mth] and [Report Day].
Altough I created 4 attributes for each level, I want users to use natural
defined hierarchy of all 4 levels.
So I have visible just one hierarchy that is also name [Report Date].
In some cubes I have data just at [Report Mth] level. Dimension Usage tab in
cube editor lets me specify level at wich dimension is used in the cube. But
I can not find place where I would make just that level invisible to front
end? So In cube I need same [Report Date].[Report Date] hierarchy, just
level [Report Day] should be not visible. How do I do that?

Thanks

Vimas,
You have a couple of options. In the dimension editor you can click on
the attribute hierarchy that you want to hide and set the
"AttributeHierarchyVisible" property to FALSE. This will hide the
attribute hierarchy from any cubes using the shared dimension. Another
option is to create a perspective on your cube that hides all of the
attribute hierarchies and only displays the user defined hierarchies.
This gives you the flexibility of being able to show the attribute
hierarchy or show only the user based hierarchy depending on which
perspective the end user connects to.

HTH,
- Steve

Vimas wrote:

Hi Steve,

Thank you for your answer. My problem is that I do want this hierarchy to be
visible, but I just want to hide one single lowest level in hierarchy. So In
example below I want to see report date hierarchy with levels:
All
[Report Yr]
[Report Qtr]
[Report Mth]
and lowest level [Report Day] not visible in one cube!

This was very easy and natural to do in AS 2000.

Can I do this IN SSAS 2005?

Thanks



<spontello (AT) proclarity (DOT) com> wrote

Just to clarify:
There are two places where I can change "AttributeHierarchyVisible" Property
for attributes.
One is when I edit dimension (dimension editor?) and another when I edit
cube (Cube editor?).
My experience: when I change value to false in cube editor, there is
absolutely no effect in default supplied cube browser (from development
environment) and in Excel 2003.
When I change value in Dimension editor, then this works.
Again, my problem is a bit diferent. I need to hide just one level in
hierarchy in one of the cubes.

Thank you




"Vimas" <Vimas (AT) nospam (DOT) nospam> wrote

Vimas,
Since you are using AS 2005 you are not limited to one hierarchy per
dimension. In AS 2005 you can create multiple hierarchies for the same
dimension. For example you could have:
Hierarchy1
[Report Yr]
[Report Qtr]
[Report Mth]
[Report Day]
and
Hierarchy2
[Report Yr]
[Report Qtr]
[Report Mth]

You then refer to the hierarchy you want to use in your MDX statements:
SELECT { Dimension.Hierarchy2.Members } on rows...

When I was talking about setting the "AttributeHierarchyVisible"
property in the dimension editor, I was referring to the editor that
you use to create and modify dimensions using the "Business
Intelligence Design Studio" (BIDS). When you edit a cube using BIDS
you can click on the "Perspectives" tab to create a perspective that
exposes portions of the cube you have built. This is another method
for hiding different attributes without having to create a seperate
cube.

HTH,
- Steve