2 Replies Latest reply: Aug 6, 2013 3:31 PM by Shankar S.-Oracle RSS

    Many to many AWM OLAP

    1001997

      Hello,

      I need to look into the issue of many to many relationships in OLAP, and to check if there is a way to transpose data through the awm modeler....? For example

       

      "the diag dimension is joined to the diag bridge which i am changing so that it's not flat...

       

       

      .......it will allow many diagnosis codes to 1 ref key"
      Please assist.
      Thanks

       

        • 1. Re: Many to many AWM OLAP
          1001997

          So basically the question is : How does AWM OLAP handle Brigde Tables?

           

          Thanks

          • 2. Re: Many to many AWM OLAP
            Shankar S.-Oracle

            Try modeling the bridge table as a fact (factless fact table) or in olap terms, model a cube with source as bridge table with addl column defined with constant value (=1) perhaps. Maybe you can use AWM mapping and key in the constant in awm mapping screen (instead of dragging a column from bridge table to map to measure).

             

            Define additional olap measures (calculated measures) like sum, max, count of dim1 or count of dim2 or count of dim1/dim2 combination etc. as needed for analysis.

            For text measures/attributes, you can attempt concatenating the strings into a long delimited list of values and convert many codes into a single display string.