hierarchy

hi All,

i am facing a problem while creating a simple product hierarchy in SSAS.

i am able to create the hierarchy and deploy the cube,but in the browser while analysing i drag and drop the hierarchy .but only the key are displayed not the caption.

Please do help me with this

thanks in advance

Lalitha

You need to post this to the SQL Server Analysis Services forum.|||

There shouldn't be any secrets to getting this to work, so I would just double check what you've done. Check the definition of the hierarchy/level/attribute and ensure that you are browsing the correct object. If you are still having troubles, please provide more info such as what version of SSAS you are using (2000 or 2005), what browser you are using, and more details about just what the problematic hierarchy looks like (key columns, name columns, etc).

Hope this helps

|||

hi,

i am using SSAS 2005 . and i am using the browser tab which is available when the cube is proccessed.

i'll give the steps what i have done

i created a dimension of product consisting of attribute

productid

productname

producttypeid

priducttypename

productcategoryid

productcategoryname

then i am creating the heirarchy in the dimension Structure tab available.

the level were automatically identified and there was no caption avaliable

i draged and dropped the captions to the appropriate levels

and the caption didnot appear while browsing the cube..

This what is did

please do help me as soon as possible

Thanks in advances

Lalitha

|||

What exactly are you doing when you "drag and drop captions" to appropriate levels? I'm guessing you're dragging attributes onto the hierahcy panel and dropping them under levels which creates attribute relationships (and thus Member Properties), but is not related to the caption of the level.

Levels are based on attributes and get their members from the values of the attribute on which they are based. Each attribute contains a KeyColumns property that determines how members are uniquely identified by the server and a NameColumn property that determines how the members are displayed. If the NameColumn is not specified, then the KeyColumn will also be used as the name. (If multiple key columns are specified, then a name column must be specified.) (In addition to names, translations can also be specified in the translations tab but as long as you've not changed anything in the translations tab it should have no impact.)

|||

hi Matt Carroll

Thanks , I solved it. You'r information help me a lot

Regards

Lalitha