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.



      allowed expense

      netpaid expense

      cost sharing


      allocated amount

      Avg membership


      Please Please help me on this.


      Thanks in advance.