Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

straight table dimensions- mix of query + synthetic

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

2 Replies
sonikajain
Partner - Contributor
Partner - Contributor
Author

Please guide me on this

azimabadi
Creator III
Creator III

Hi,

can you attach a sample qvw of your problem?