View Full Version : dimension with 2 hierarchies

11-23-2003, 11:38 PM
I have a dimension with 2 hierarchies.
I want to show the 2 hierarchies in JPIVOT.
When i send the MDX request specifying the dimension select
{[measures]......} on columns
{[myDimension]} on rows
FROM myCube
then JPIVOT let me show only the first hierarchy, the one which is placed at the first place in the XML schema.
How can i specify to show one hierarchy ?
Can i show more than 1 hierarchy in a dimension ?

11-24-2003, 08:21 AM
JPivot does not support this in the GUI, sorry. Couldn't you have 2 dimensions with one hierarchy each?