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
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.
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...
Problem fixed..
can u share ur solution