Search found 3 matches

by gotchev
Tue Jul 26, 2022 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2016 DBRW issue - resolved
Replies: 2
Views: 907

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...
by gotchev
Tue Jul 26, 2022 5:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2016 DBRW issue - resolved
Replies: 2
Views: 907

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...
by gotchev
Tue Jul 26, 2022 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel 2016 DBRW issue - resolved
Replies: 2
Views: 907

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...