In my company we just had our TM1 (9.5.2 FP2) go live a few weeks ago and so far it works pretty well. However occasionally we've users ticking all dimenions in the "Websheet Export" window when creating an Excel or PDF export:
Depending on the amount of dimension elements this sometimes - more or less - crashes / blocks our server. That raises following questions for me:
Is there a way to disable the window to appear?
If not is there a way to limit / define the number of combinations / reports?
Is there a way to adjust / influence the appearance of this pop up window and the dimensions?
I coudn't find any relevant threads in this forum, even google didn't find anything helpful. Many thanks in advance for your support!
beckersbest wrote:
1/ Is there a way to disable the window to appear?
2/ If not is there a way to limit / define the number of combinations / reports?
3/ Is there a way to adjust / influence the appearance of this pop up window and the dimensions?
1/ Not without looking into what call is made when the export button is clicked and hacking around with the java script itself
2/ Yes. Look in the web.config file. You can limit the export to a maximum number of sheets.
3/ See answer to 1.
We have export limited to maximum 15 sheets and give our users very explicit instructions to never check any dimensions and "ONLY CLICK OK". I wish there was a configurable way to suppress the popup dialog altogether (as well as a configurable option to disallow export as slice and only allow snapshot or pdf). But unfortunately there isn't. I haven't really looked into customizing the code as this then adds much extra complexity into maintaining the application around upgrades and patches.
Many thanks for your fast reply! Too bad that there's no customizing option for the pop up window. However I've limited the export to 10 and will have a look how our server is now performing.
I forgot to mention it before but depending on the nature of the report you can potentially replace the SUBNMs to pick title elements with cell validation dropdown or a picklist. If there are no SUBNM formulas then no popup.
That's a good hint, especially for dimensions like language ...
However we pretty often use the subnm to retrieve the technical id of an element. And all these subnm related dimensions are also provided in this pop up window. Any idea how to retrieve technical name without using subnm?
beckersbest wrote:Any idea how to retrieve technical name without using subnm?
Technical name? There is no such terminology in TM1. Are you talking about an alias you have created? If so, then you can use the DBRA function to pull back any attribute or alias. Combine that with a data validation range and you have a drop-down with "technical name".
Element | description
--------------------------------
201201 | January 2012
201202 | February 2012
...
What I'm looking for is a functionality to retrieve the element name (201201, 201202). Usually we provide the real name (January 2012, February 2012) for selection but then would like to use the element name for further steps and calculations. In many cases we've adequate aliases or attributes, but some times it would be very helpful to just get the element name.
beckersbest wrote:What I'm looking for is a functionality to retrieve the element name (201201, 201202).
You can use DIMNM(DIMIX()) combination to do this. For example
DIMNM("server:d_Period",DIMIX("server:d_Period","January 2012"))
would return 201201
(obviously in Excel or a websheet you can replace the literal strings with cell references)
beckersbest wrote:
What I'm looking for is a functionality to retrieve the element name (201201, 201202). Usually we provide the real name (January 2012, February 2012) for selection but then would like to use the element name for further steps and calculations. In many cases we've adequate aliases or attributes, but some times it would be very helpful to just get the element name.
You don't really need to return the actual element name. Aliases will do the same thing. If January 2012 is an alias for 201201 then you can pass January 2012 to any TM1 function that you would pass 201201 to and you will get the same result.
That sounds good, first time that I see this option! I'll give it a try tomorrow (as our German business day is coming to an end now ).
@tomok: From time to time we need to use the element name, e.g. if we just want to extend '201201' to '201201_YTD'. Especially if we work with parts of the element name, e.g. increasing the month by calcualting, e.g. 201201+1 or year 201201+100 ... therefore it's sometimes very helpful to have access to the element name.
).