adding,subtracting,dividing and multiplying dimensions at the script level

[#1]

hi all,

I want to know whether we can perform these functions on the two dimensions at the backend or not.

for example

in my fact table i have three columns amount,tax,rent .

the expression i am using at the UI level is sum({$< yearcode={'P'}>} amonut}+ sum({$< yearcode={'P'}>} tax}+sum({$< yearcode={'P'}>} rent}

i want to use it with dimnesion like

sum({$< yearcode={'P'}>} amonut1}

where amount1= amount+rent+tax.....

Is this possible at the script level??? and similar way other functions can be performed or not???

[whiteline]

Hi

Yes of course, its possible.

No. You cann't use set analysis in script.

when you load your data just add another field:

LOAD

     ...

     rangesum(amount, tax,rent) as amount1

     ...

FROM ...