2 Replies Latest reply: May 23, 2012 9:38 AM by Peyman Azimabadi RSS

    straight table dimensions- mix of query + synthetic

    Sonika Jain

      Hi all,

       

      I am stuck in a problem where , in a table, few of the dimensions come from the load script (column in the data base) , and few are added synthetically (using valuelist/inline).

       

      For example, in the table below, the ones highlighted in yellow are the ones that come from the database,the values

      and the ones in blue are the ones that are to be  generated synthetically. The calculation of these columns  also have a different calculation for each row, far dissimilar to the ones in yellow, which  get populated through a same calculation.

       

       

      dimensionsValue1Value2Value3
      allowed expense


      netpaid expense


      cost sharing


      difference


      allocated amount


      Avg membership


       

      Please Please help me on this.

       

      Thanks in advance.

       

      Sonika