Heirarcy in FM

[phanicrn]

Hi All

I am creating Heirarchy in Framework Manager and published the package to report studio

I see values repeating in Heirarchy,
But in "Product_Type" there are three values, here values are repeating.. I though i should go with Group by , I can't find, even i tried to edit sql,  that didnt work in heirarchy..

My output should be

Poduct_Type
-------------

LN
CD
SA

But here "LN" repeating multiple number of times.. I am attaching a screenshot of fm..

Help me guys

Thanks
Phani

[praveennb]

You will  need to define Determinants
And for the Hierarchy you need to define the Unique level

Search for Guidelines for "Modeling Metadata" at cognos support

Hope this helps.

[phanicrn]

I have three columns

Product type  as member caption

product group as member description

product code as unique level..

does Product key  should be unique level

even if follow this process, still i get the same  display in report studio..

I have two namespaces on for Relational Modeling and another for Multidimensional Modeling..

So i have to setup heirarchy in fm, where display would be

If users clicks on  Product_type ,it should display these three values

LN
CD
SA

When he clicks on any three values , let say user selected "LN"
Then it should display 

1
2
3


But when i follow the procedure for creating heirarchies, i get the same repeating values in the heirarchy...

[phanicrn]

Problem fixed..

[mrcool]

can u share ur solution