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

Mon, 10 Sep 2012 05:46:29 GMT

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???

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

whiteline — Mon, 10 Sep 2012 05:54:09 GMT

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 ...