greatmaster
11-23-2003, 10: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 ?
thanks
eric
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 ?
thanks
eric