Cell Number Limit for DBSW?

Post Reply
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Cell Number Limit for DBSW?

Post by macsir »

Hi, I am experiencing an issue and it looks like there is some limit on the number of DBSW formulas when sending data back to a cube.
The file originally works fine for writing data back in Perspectives and it takes around 10 minutes to complete.
When I put it with PAfE v55, it refreshed but not sending any values to the cube at all no matter what I tried(F9,Shift+F9,Crtl+Alt+F9,Ctrl+Alt+Shift+F9, etc). I reduced the number of DBSW cells (just deleting lines) back to around 220,000 cells and it worked.
I would expect better performance in PAfE without changing anything in the original file and didn't have any impression that IBM put any limits on that?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply