i try to save data on excel hseet also change the data.
simple read is okay... but store is not work...
bplaia wrote:are you trying to save the data change back to TM1 or simply read the value from TM1 and put it in the excel sheet?
Search found 3 matches
- Thu Aug 01, 2013 3:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: can i use IF statment on DBRW excel formula
- Replies: 9
- Views: 9821
Re: can i use IF statment on DBRW excel formula
yes,
i try to save data on excel hseet also change the data.
simple read is okay... but store is not work...
i try to save data on excel hseet also change the data.
simple read is okay... but store is not work...
- Thu Aug 01, 2013 3:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: can i use IF statment on DBRW excel formula
- Replies: 9
- Views: 9821
Re: can i use IF statment on DBRW excel formula
hi Martin, many thanks. yes, in my case the two cubes have a different number of dimensions. so ... you meaning , the way is not work ? You can use IF's on DBRWs only if you want read only information. If you want to type the value over the DBRW formula and send it back to TM1 then it will not work....
- Wed Jul 31, 2013 6:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: can i use IF statment on DBRW excel formula
- Replies: 9
- Views: 9821
can i use IF statment on DBRW excel formula
Hi All i when created dynamic report for column and report made has 2 cube. on excel cell i writhe the formula as below: = IF(M$14<>N$14,DBRW($J$9,$M$11,$O$11,$I21,$H21,N$15),DBRW($M$9,$M$11,$O$11,$I21,$H21,N$16,N$17)) the formula is work on view report. but when i change value on report and save , ...