Search found 3 matches
- Tue Jul 26, 2022 6:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel 2016 DBRW issue - resolved
- Replies: 2
- Views: 1249
Re: Excel 2016 DBRW issue - resolved
the issue was resolved by giving permissions to the default value for the fiscal year parameter in the spreadsheet. apparently "we" have run into this issue before, but did not remember it. When the spreadsheet loads the user needs to have permissions to access the data identified by the d...
- Tue Jul 26, 2022 5:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel 2016 DBRW issue - resolved
- Replies: 2
- Views: 1249
Re: Excel 2016 DBRW issue
small update: I have verified that Object security in our test instance is matching* the production instance. The one exception is the parameter for the Years dimension. The spreadsheet is using the SUBNM function for the Years dimension (and then using "=+I13-1" to get "last year&quo...
- Tue Jul 26, 2022 4:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel 2016 DBRW issue - resolved
- Replies: 2
- Views: 1249
Excel 2016 DBRW issue - resolved
hello everyone, I am a very inexperienced admin, supporting a PA 2.0 in a production environment, and I need some direction analyzing an issue. We have an Excel report/application, which is reading data from a GL cube using DBRW command. The end users are accessing the report from TM1Web. The report...