Active Form crashing. Is there a better way?

[purplesheep]

Hi all,

First post! Thank you guys for being such a resource in me learning TM1. I still consider myself a novice although having worked with it for almost a year.

My current goal is in creating an expense by vendor report for some geographical, divisional and product intersections. We have all of this data available in a transaction cube.

I currently use an active form and hit "refresh sheet" every month to generate a new report.

This however is imperfect as if there is a new vendor, they are not included on the active form hidden sheets.

It also crashes sometimes. I don't believe this to be due to trying to pull too much data although it is possible. There are about 15k total vendors. The active report is only for one full year (12 months + year field)

Please let me know if there is:
a. a way to make the active form incorporate new dimensions
b. a better way to run an detailed report like this

Thanks!

[BigG]

have you tried using MDX in the RPTROW? Instead of referncing hidden sheets?

[whitej_d]

The other option which may be easier is to use a named subset for your rows in the Active Form, then the named subset can be a dynamic subset which will always include new elements.

If you have 15,000 rows and you're running over a WAN, I'm not surprised it sometimes hangs.

Try cutting it down by using named subsets in the TM1RPTRow formula and linking the named subset field to an Excel drop down:

Page 1 subset contains first 5,000 vendors, Page 2 subset contains 2nd 5,000 vendors, Page 3 contains the rest.