DBRW formula works for development server but not for production server

[BilalSuleman2019]

Hi,

DBRW formula is not working for production server but is working for development server. Production server is replica of development server.
Can any one help?

Bilal

[tomok]

Probably because the formula is still pointing to the development server. If this is not the case then post a screen shot of the formula and all the cells it is pointing to.

[BilalSuleman2019]

Thanks you tomok for your reply. I have check by signing out of development server and signing in to production server. The problem is still there. Please see the screenshot of the formula and all the cell it is pointing to.

Bilal

Screenshot.jpg (159.22 KiB) Viewed 11623 times

[Steve Rowe]

Are your development TM1 database and your production database called the same thing?

[BilalSuleman2019]

Yes, both development and production server TM1 database has same name.

[Steve Rowe]

This should be a simple issue.

I'd try the DBRW in totally fresh session versus the live server, rather than switching admin servers and relogging.

My best guess from your screen shot is that one of the cell references is not evaluating properly when the DBRW calcs since the DBRW is returning #Value.
You just need to step through the references and check them all for issues. Maybe range value them all.

[BilalSuleman2019]

Hi All,

Sorry for late reply but the issue was resolved by external consultant. Access rights was not defined for all elements in one dimension in production server due to which DBRW formula was not working.

Thanks to all for help

Best Regard

Bilal