Focal Point
OLAP : MULTIPLE HIERARCHY ON A DIMENSION

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2261068331

June 03, 2005, 06:24 AM
Heart-Shape Box
OLAP : MULTIPLE HIERARCHY ON A DIMENSION
Are there any possible ways to display more than one hierarchies on WebFocus?

(FOC11207) ERROR IN THE QUERY:
(FOC11248) ONLY ONE HIERARCHY ON A DIMENSION CAN BE REFERENCED Product

Thanks in advance.
June 03, 2005, 10:56 AM
<JG>
If you want to report from multiple hierarchies then you must extract the data from each hierarchy, hold them, with common keys, then join the hold files. And produce your report against the joined structure