TM1 Forum

Hello,
I have a DBSS that is called from a VB procedure. However,during run time, it doesnt seem to send the values through. However, when I debug the code and do a Step Into, it sends the data to the cube.Has anyone faced that problem?

telula wrote:Hello,
I have a DBSS that is called from a VB procedure. However,during run time, it doesnt seem to send the values through. However, when I debug the code and do a Step Into, it sends the data to the cube.Has anyone faced that problem?

You haven't indicated whether you have a DBSS in a sheet which you're recalculating by (say) Application.Run "TM1RECALC1", or whether you're directly running a DBSS formula itself via Application.Run.

I shan't ask.

In either case, try using a DBSW instead of a DBSS. Yes, a DBSW will work with strings as well.

Quite often a DBSS, when run by VBA, will send the value through. However it won't change the values of any corresponding DBRWs which are reading the value until you recalculate them. The DBRW will appear to be unchanged.

If you use DBSW instead, all values will be updated.

You haven't indicated whether "it doesnt seem to send the values through" based on DBRW formulas, or on the log file.

I shan't ask.

In any case, DBSW is probably the solution that you need.

You're welcome.

I commonly come across errors/bugs in VBA code that suddenly seem to disappear once I use breakpoints and step through the code.