Cell Number Limit for DBSW?
Posted: Wed Jan 27, 2021 4:23 am
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?
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?