Client is on TM1 9.5.1 accessed through Citrix using Excel 2003.
Have others encountered this?
When a DBS formula references a blank cell and is refreshed, any value in the cube is overwritten with zero.
When a DBSW formula references a blank cell and is refreshed, the value in the cube is not overwritten.
(Admin note: Moved from bugs till proven/SR raised)
DBSW vs DBS Clearing cells
-
Christopher Kernahan
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
-
sachin
- Posts: 92
- Joined: Fri Jan 15, 2010 9:54 pm
- OLAP Product: Transformer,SSAS, EP, TM1
- Version: 7.3 2005 10.1 10.1.1
- Excel Version: 2013
- Contact:
Re: DBSW vs DBS Clearing cells
Did you find an answer to this? We have a similar issue in a spreadsheet.
If we use DBS then we get #N/A in all the cells. If we use DBSW, then we can see the numbers in the spreadsheet, but they are not sent to the cube at all. Infact, it wiped out the existing data in the cube!
Thanks.
If we use DBS then we get #N/A in all the cells. If we use DBSW, then we can see the numbers in the spreadsheet, but they are not sent to the cube at all. Infact, it wiped out the existing data in the cube!
Thanks.
Check out my blog for some good information on TM1, SPSS
-
Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: DBSW vs DBS Clearing cells
Hi,
What is the source for the number you are trying to load through the DBSW formula ?
DBRWs can not be used to source a DBSW.
It is due to the priority in which the formula get calculated.
You can look at this post for more details.
http://www.tm1forum.com/viewtopic.php?f=3&t=3064
Hope this helps,
What is the source for the number you are trying to load through the DBSW formula ?
DBRWs can not be used to source a DBSW.
It is due to the priority in which the formula get calculated.
You can look at this post for more details.
http://www.tm1forum.com/viewtopic.php?f=3&t=3064
Hope this helps,
HTH
Olivier
Olivier