Excel 2016 DBRW issue - resolved
Posted: Tue Jul 26, 2022 4:16 pm
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 is unchanged for at least 9 months as far as I am aware, and is in Production use for several years at least.
I am not aware of any changes to security. Multiple users are reporting the issue at the same time, but I cannot confirm if all users are affected.
I have admin rights and when I access the same report, same machine, same browser, same parameters from TM1Web the cells populate with data,
for the end users they do not populate with data (the issue seems to have started a few days ago).
This leads me to believe that the issue should be in the Object security in TM1, which as I said, should not have changed.
I have verified the cube security, dimension security, and element security (where applicable) - the group to which the user belongs has read access (at least) to the necessary objects. We do not have any cell security.
I have only skimmed through "Controlling Access to TM1 Objects" from IBM.
my next step is to compare group security settings with the test environment, when it is available (we are having some issues).
thanks in advance for any assistance.
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 is unchanged for at least 9 months as far as I am aware, and is in Production use for several years at least.
I am not aware of any changes to security. Multiple users are reporting the issue at the same time, but I cannot confirm if all users are affected.
I have admin rights and when I access the same report, same machine, same browser, same parameters from TM1Web the cells populate with data,
for the end users they do not populate with data (the issue seems to have started a few days ago).
This leads me to believe that the issue should be in the Object security in TM1, which as I said, should not have changed.
I have verified the cube security, dimension security, and element security (where applicable) - the group to which the user belongs has read access (at least) to the necessary objects. We do not have any cell security.
I have only skimmed through "Controlling Access to TM1 Objects" from IBM.
my next step is to compare group security settings with the test environment, when it is available (we are having some issues).
thanks in advance for any assistance.