TM1 Forum

You could write the whole dynamic subset in MDX to check the value of the "archive year" in a control cube but here is a very straightforward way to do what I think you are trying to achieve. 1/ In your year dimension create an attribute, let's call it "ArchiveYear" 2/ Hold the v...

Not only do we allow you to choose your font size, but also the font!

Eric, I'll put your question down to a temporary brain snap! The STET function essentially means that the rule does not apply. So ... ['Actual', 'GP Margin'] = C:STET; ... would be pointless as it would be the same as having no rule at all. Where there is no rule then of course standard consolidatio...

To check for case b as defined by Lukas you could also write a simple app to check tm1top log output. Where you have a thread with a long processing time and other threads start backing up with a wait status then something is up and you get the app to send the tm1 admins an email or SMS. I can remem...

Whatever the rule is for your actual version for the percentage measure needs to be extended to the snapshot version(s). Eg. your rule probably looks something like this: ['Actual', 'GP Margin'] = ['Gross Profit'] \ ['Revenue']; Modify the area statement (left hand side of the equation) to include y...

You need to make sure that DatasourceNameForServer is pointing to the right place! If you go to edit the process you will see that there are 2 boxes for an ASCII data source: - The first text box, "Data Source Name" holds the string for the TI variable DatasourceNameForClient - The second ...

Hi Rick, What exactly is the "GL Detail Lines" dimension? In the table structure of many GL systems the posting account for GL data might be something like ZZBBCCXXXX where ZZ is a company code, BB a location code, CC a cost centre code and XXXX the chart of accounts code. This is actually...

You might want to define what you mean by "compatibility issues." If you mean "will x64 TM1 and x86 Oracle 9i run on the same Win x64 server?" then the answer is yes, no problem. TM1 does not rely on any database platform, it is its own fully self contained and proprietary in-mem...

The usual approach is to - ABAP a flat file out of SAP - ftp the file to a network location accessible to the tm1 server (usually a folder on the tm1 server) - import the flat file via TI This can be scheduled and fully automated. Although it is technically possible to connect directly to the tables...

Hi Eric, In the old TM1 recommended practices look up "Documenting_Dimension_Usage_by_Cube" - both TI and rules approaches are explained. To improve on things a little I would recommend rather than using the control dims in the audit cube creating a replica of }Cubes and }Dimensions with a...

Every now and again there seems to be a request for generating hierarchy trees with explicitly named/fully qualified element paths. If a TM1 dimension has multiple top level hierarchies or elements appear several times within the same hierarchy then this can be quite tricky to do. My take on this is...

Hmmm Were talking TM1 here .... The answer is "IT DEPENDS" Depends on what? The complexity of the model, its purpose and the technical ability of the administrator left to maintain it after the implementation and their level of comfort with TI vs rules. I would also say the field should be...

... rules to generate security are the wrong way to approach it. Its so much slower to refresh security i wrote a suite of TIs to do the same job. The TIs were far more complex to write than the rules, but the impact was substantial. We went from a 20 min+ refresh down to 2s I don't know if I'd agr...

Overriding TM1's natural consolidation where averages are required is a classic problem. It is conveniently sidestepped in most training material and examples by giving the example already mentioned ['Sales'] = N: ['Volume'] * ['Cost']; ['Cost'] = C: ['Sales'] \ ['Volume']; However this conveniently...

Short answer is no. A security refresh is all or nothing. Maybe you could consider an "almost real time" solution where you have say for example 2 "batch processing" windows throughout the day and you append the security refresh at the end of these processes. If users add element...

I hate the save button too for what its worth .... Suggest you try using ASCIIOutput in a TI process. Yikes! :o I wouldn't be wanting to have to write the CellGetN or CellGetS statements for a 250 dim cube. I agree with Steve, I think you would be unique in having encountered this problem. The struc...

Yeon, If you look in the tm1server.log then you can see exactly what is taking the time. TM1 server loads in the order: - dimensions + element attribute cubes - data cubes + process feeders (per cube with feeders in the rule file) Loading data is extremely fast. The thing that takes the time is proc...

Eric, thanks for finding the needle in the haystack!

Knowing the best practices site's days were numbered I archived a copy of the site as of about mid-June 2008. If anyone would like a copy of everything in html just send me a pm

Gruess Herman, Perhaps the reason noone has answered this question already is that it is a little confusingly written and difficult to know exactly what you are asking. From my understanding of the question I'll attempt an answer. The drill through rule defines only the name(s) of the drill through ...

What version are you working on? From your description is sounds like 8.1 - 8.3 where custom formats for rule formatting were stored in .blb files. Rule formats being lost is quite a common occurrence/bug in these versions. I would suggest that you edit rules in the Excel rules editor (xru files) as...