TM1 Forum

When I connect to TM1 via excel, I am getting a RECALC error when I try to refresh my DBRW formulas. I have the add-ins, have tried DBR and DBSW formulas but it still is not working. Any ideas? Thank you

You've started a new thread, but you didn't comment on the suggestion I gave in the last thread. What you should specifically look for in the Error Checking Dropdown is whether or not "Circular References" is greyed out or not. If not, select it and review/fix your circular references. In either case, post back to the forum so others may benefit in the future.

domisisk wrote: ↑Tue Feb 21, 2023 1:53 am When I connect to TM1 via excel, I am getting a RECALC error when I try to refresh my DBRW formulas. I have the add-ins, have tried DBR and DBSW formulas but it still is not working. Any ideas? Thank you

If you're using the newer planning analytics add-in, make sure you're in automatic calculation mode and not manual.

domisisk wrote: ↑Tue Feb 21, 2023 1:53 am When I connect to TM1 via excel, I am getting a RECALC error when I try to refresh my DBRW formulas. I have the add-ins, have tried DBR and DBSW formulas but it still is not working. Any ideas? Thank you

If you are using Perspectives this is normally caused by linking a DBRW formula to another DBRW formula which retrieves a string value which is passed as an argument to the next DBRW as a dimension element ID. You can't do this as all DBRW formulas are completed in a single batch, hence the 1st DBRW has a state of "unknown" at the time it's value is passed to the 2nd DBRW. It is however a very easy problem to fix, the formula which retrieves the element name must be eveluated first, before the DBRW batch, therefore this formula must be a DBR.

The above does not apply to PAfE only Perspectives.