Multiple dynamic Areas in one report

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

Multiple dynamic Areas in one report

Post by schlemiel29 »

Hi all,
I have a report which I should rebuild using TM/1. It is a dynamic area showing some products and their volumes.
If I click on one of them (maybe with a value writing back a "1" to a helper cube) in another dynamic area below the one above some more details should be listed.
Is it possible to define multiple dynamic areas within one report (in Excel)?
I know that using PAW I can create a dashboard with multiple small reports which are linked via variables or values in a cube, but this seems to be very slow and is limited to PAW only. If a user wants to use an Excel sheet in Excel too, this will not work.
Any idea?
Best regards
Dirk
Wim Gielis
MVP
Posts: 3222
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: Multiple dynamic Areas in one report

Post by Wim Gielis »

Why not multiple dynamic reports below each other in PAfE ?
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