Excel dynamic name range chart not refreshed in TM1 web

Post Reply
danz
Posts: 6
Joined: Mon Jun 10, 2019 2:47 am
OLAP Product: TM1
Version: PA2
Excel Version: Office365

Excel dynamic name range chart not refreshed in TM1 web

Post by danz »

I have set up a dynamic name range referencing a range of data which use Offset to reference ActiveForm data.

Dynamic range similar to below
Capture.PNG
Capture.PNG (13.51 KiB) Viewed 6977 times
Then I created a pie chart based on the name range.

In Excel, I change SUBNM selection and rebuild, the ActiveForm updates and so as the pie chart, perfect!

However, the pie chart does not update anymore once the workbook is uploaded to TM1 web. I did some research and found a related IBM reported error about chart with OFFSET datasource not rendered probably.

Does anyone know a workaround?

Thanks in advance.
Dan

Office 365
PA 2.0.6 Perspective
Post Reply