2 Replies Latest reply on Jun 11, 2013 1:57 PM by user11987733

    How to create aggregate table for ragged hierarchy

    user11987733

      Hi:

      OBIEE 11.1.1.6.5

      When I use the aggregate persistence wizard to create a aggregate table on a dimension with a ragged hierarchy, I receive an error

       

      "Discarding aggregate (dimension(s) contain ragged levels/hierarchies) ag_W_PATIENT_COST_ - "DW"."Cost Center Hier Temp DDim"

       

      Question:

      How do I create an aggregate table that includes a dimension with a ragged hierarchy?

       

      Thanks.