Pax - Expand Above

Post Reply
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Pax - Expand Above

Post by chewza »

Hi Guys

Silly Question - how do you set subset to expand above when you click on it?

Many thanks!!

Regards
Chris
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Pax - Expand Above

Post by Steve Rowe »

In the set editor toggle the Show Totals Leading / Trailing which is the Epsilon with the bars above and below it in the middle of the editor.
Make sure the set editor is in to Hierarchy mode rather than definition mode as well as this (might) make a difference too.
Technical Director
www.infocat.co.uk
Keith Would
Posts: 13
Joined: Tue Dec 06, 2016 11:24 am
OLAP Product: TM1
Version: 10.3.0
Excel Version: 2010

Re: Pax - Expand Above

Post by Keith Would »

Hello

I've looked at this thread as well.
https://www.tm1forum.com/viewtopic.php?t=14451

The TM1ToggleExpandMode seems to stop the dynamic formatting working in a Dynamic PAfE report, making all roll ups be Level 0?

In this case, at the bottom,
5 Total Interest... is actually a Level 1
5100 Interest... is actually a Level 2

Also, you can still click on the + signs, and they then expand below??

Am I missing something?

Image
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Pax - Expand Above

Post by gtonkin »

TM1RptRow has a parameter to expand above. Try set it and see if that helps. Remove the expand mode from the MDX string too.
Keith Would
Posts: 13
Joined: Tue Dec 06, 2016 11:24 am
OLAP Product: TM1
Version: 10.3.0
Excel Version: 2010

Re: Pax - Expand Above

Post by Keith Would »

Ah, I didn't know about that parameter.
Thanks George
Post Reply