TM1 Forum

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

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.

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

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.

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