Can Active Forms that use same title dimensions be in diffrent sheets

Post Reply
yyround
Posts: 27
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: PA2.0.8
Excel Version: MS 2016

Can Active Forms that use same title dimensions be in diffrent sheets

Post by yyround »

Hi all,
Continuing with my search for the solution on my previous post http://www.tm1forum.com/viewtopic.php?f=3&t=13250. I tried to put a few active form reports in different worksheets and put the title dimensions they share in a new worksheet call "coversheet". I was hoping by doing that, I can use the print report function to generate a set of management reports that iterate through the cost centres in a defined subset.


But I came across these problem:

t first, I moved the title dimensions (selectable with SUBNM function) over to the new worksheets and the reports didnt work. I found this posthttp://www.tm1forum.com/viewtopic.php?t=10108 in the forum where says:"The Element (2nd parameter) MUST reference a cell located on the same worksheet page as the TM1RptTitle function itself", so I move the tm1rptview formula to the "coversheet" tab as well. But it still didn't work.

What should I do? do all active forms need to be put in one sheet? Has anyone tried to achieve these without any macro? If macro is needed, can you please provide some guidance?

Regards
Gaby
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Can Active Forms that use same title dimensions be in diffrent sheets

Post by Wim Gielis »

Hello Gaby,

In the past, I tried similar things as you did, and I could not get it to work unless it's all on 1 sheet.
IIRC I had a thread in this forum about this, where someone (I thought Lotsaram) said that it was not possible.
Best regards,

Wim Gielis

IBM Champion 2024
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
yyround
Posts: 27
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: PA2.0.8
Excel Version: MS 2016

Re: Can Active Forms that use same title dimensions be in diffrent sheets

Post by yyround »

Thanks Wim,

I got it to work this afternoon. The users are now able to print multiple reports that iterate through the cost centres in the defined subset through TM1 web (not using perspective!!).

I didnt use coversheet, instead, I keep the subnm for the dimension titles in the first active form but point the dimension titles in the other sheets to the same dimension titles in the first sheet. And it works perfectly.

Regards
Gaby
tomok
MVP
Posts: 2831
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: Can Active Forms that use same title dimensions be in diffrent sheets

Post by tomok »

yyround wrote:I keep the subnm for the dimension titles in the first active form but point the dimension titles in the other sheets to the same dimension titles in the first sheet. And it works perfectly.
That's what I told you to do in the other thread. :?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Abhayv
Posts: 1
Joined: Tue Sep 05, 2017 7:36 am
OLAP Product: Tm1
Version: Tm1
Excel Version: 2010

Re: Can Active Forms that use same title dimensions be in diffrent sheets

Post by Abhayv »

Hey
I have similar sort of query ...how we do the reference to first sheet for all other active forms ..I tried it but doesn’t work for me. I am using perspective.
Could you please help me with that . I need it to get it running.

To be specific ...I have got membership no....and what I want if I choose membership no in one and then it should auto selected in other sheets ..and sheets should update accordingly. Please help
Post Reply