Dimension and Hierachy

Hi, I am new in AS2005

I builded a Dimension "ShipToState" with Hierarchy "ShipToState", "ShipToCity", "ShipToZip"...

When I browse my cube from Excel I see

"ShipToState", "ShipToCity", "ShipToZip"... as 3 different dimensions and a new dimension named "Hierachy".....I think I am doing some mistakes.....

Someone can help?

Thx

Mcrisf

No its correct. The three different dimensions are called attribute hierarchies. They have only an all level at the top. Hierarchy is probably you user hierarchy that you have created in the dimension editor. If you have used the wizard, click on the dimension in solutions explorer and check the design. Attribute hierarchies are to the left and user hierarchies is in the middle.

Regards

Thomas Ivarsson

|||

Thx for the answer....

but i would like to show to the user just only a dimension "ShipToState" and when the drill down to see the "ShipToCity" and "shipTozip"....the user is confused to see all these dimensions and also a hierachy dimension....with the same attributes

There is a solution?

Thx

mcrisf

|||

Each attribute has a property called AttributeHierarchyVisible which you can view and set in the property panel. If you set this property to False for ShiptToCity and ShipToZip, then those will not show up in Excel as Hierarchies but they will still be available in the user defined hierachy you have created.

On a unrelated note, I don't know what your cube looks like, but if you will have a BillTo or other dimension in the cube that is based on the same address table but joined to a measure group by different columns, you'll want to create a single Address dimension and include it in the cube with two different names (ShipTo and BillTo). This saves you redefining the dimension and keeping the two versions in sync and is more effecient on the server.

|||

I understand your confusion. You can put attribute hierarchies in a separate folder.

Right click on the attribute and choose properties. You do this in the dimension editor.After that you can find a property called something like AttributeDisplayFolder. Write the name of the displayfolder there.

Check this in the browser in BI-Devlopment Studio afterwards.

Regards

Thomas Ivarsson

|||

Thx you ...this is was i was seaching for.... AttributeHierachyVisible=false