Hi,
I have the following problem:
I log into TM1WEB. I run a process that is updating a dimension, and after that is doing some calculation. So let s say that in this dimension I insert a new Element X.
If after the update I open a report with X selected, the values from the cube for element X are not displayed.
I use a active form to bring the values into the report and the first column of the report that is using TM1RPTROW is displayed but the next ones that are using DBRW are empty.
IF I close TM1WEB and reopen it, all is working as expected and the report is showing the values. This behavior is happening with admin access.
Thank you
TM1 DBRW not displaying values after update
-
AnonimusMax
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
-
tomok
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: TM1 DBRW not displaying values after update
Did you issue a REBUILD to the active form report after opening it?
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 DBRW not displaying values after update
What version are you using?
I have seen a bug in early 10.2.2 where an active form seems to hold on to a cache and newly inserted elements appear in the rows but the data points would be blank (not zero or anything but just empty)... rebuilds didn't help as the elements were already there; wasn't cell security as the same happened to Admins and the only way to resolve was to completely close web and go back in... even closing and opening the sheet/page wasn't sufficient.
I have seen a bug in early 10.2.2 where an active form seems to hold on to a cache and newly inserted elements appear in the rows but the data points would be blank (not zero or anything but just empty)... rebuilds didn't help as the elements were already there; wasn't cell security as the same happened to Admins and the only way to resolve was to completely close web and go back in... even closing and opening the sheet/page wasn't sufficient.
Declan Rodger
-
AnonimusMax
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: TM1 DBRW not displaying values after update
declanr wrote:What version are you using?
I have seen a bug in early 10.2.2 where an active form seems to hold on to a cache and newly inserted elements appear in the rows but the data points would be blank (not zero or anything but just empty)... rebuilds didn't help as the elements were already there; wasn't cell security as the same happened to Admins and the only way to resolve was to completely close web and go back in... even closing and opening the sheet/page wasn't sufficient.
we use 10.2.2.and this is the exact behavior for my report also. is there a way to solve this? rebuild doesn t work.
did you find a way to solve this problem?