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

Post Reply
yyround
Posts: 15
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: MS 2010

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

Post by yyround » Wed May 03, 2017 11:54 pm

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: 1562
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis » Thu May 04, 2017 7:37 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

yyround
Posts: 15
Joined: Tue Apr 18, 2017 1:20 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: MS 2010

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

Post by yyround » Thu May 04, 2017 11:53 am

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

User avatar
tomok
MVP
Posts: 2349
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 » Thu May 04, 2017 12:25 pm

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 » Tue Sep 05, 2017 9:23 am

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