TM1Web-Report sync with PAW visuals?

Post Reply
schlemiel29
Posts: 68
Joined: Tue May 08, 2012 8:29 am
OLAP Product: TM/1
Version: 11.8
Excel Version: Excel 365

TM1Web-Report sync with PAW visuals?

Post by schlemiel29 »

In PAW I have the option to sync controls with each other by dimensions. When I define a Report in Excel and upload it to TM1Web, I can also use this in PAW as a visual. But its values are not offered outside to syncronize them.
I can save the selected elements in a special cube and make the other PAW controls to query from there, but is there a more convinient way to do it? Maybe there is a convention for naming ranges in the TM1Web report???
Wim Gielis
MVP
Posts: 3203
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1Web-Report sync with PAW visuals?

Post by Wim Gielis »

The cells with SUBNM() formulas should synchronize in PAW and you can toggle which one you want to sync, if not all.
1 requirement though is that the SUBNM() cells should not be in hidden rows or columns.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply