1 Reply Latest reply on Feb 15, 2017 6:04 PM by Srinidhi Narayan


    Kay Loewenthal

      How can I create 2 different hierarchies in the same workbook with same data? In some views I want to drill down to person in others country. I can/did create one or the other, but don't see how to create both.

        • 1. Re: hierarchies
          Srinidhi Narayan

          Create duplicates of all the dimensions you want in the second hierarchy.  To duplicate a dimension - right click on it and select "duplicate".  This creates a copy, you can rename these duplicates to something more meaningful.   Create the second hierarchy using these duplicate dimensions.