TM1 Forum

Hy guys, quick question here. Is it possible to log when a process / chore etc. is aborted by an Administrator? If so, could you tell me how to configure this? Currently we have the problem that a process stops without error or any other "in logfile visible reason". We wrapped the process ...

Reflecting, consolidations is the only way to go. From a performance perspective you're going to need to use consolidations and should you attempt to refer to a consolidation with all leaves it's going to cause a circular reference, alternate hierarchy or not. Other options to using consolidations ...

Nope the problem would have to do with a circular referencation. If I'd write: ["Element 3"] = N: ["All Elements"] - [!Element] TM1 would be kinda displeased :-D What is the cube structure you are working with and what are you trying to get a sum of? As long as you have a measur...

Hi, And I know that I could reference it on the right side of the rule with an exclamation mark, but how would that actually help in the given situation? The given situation you mentioned in your first post was to minus this value from the calculation, therefore because it is specifically reference...

Assuming that element 3 value can just be a calculation and doesn't need to be fed then you could maybe do this ['dim1':'dim1':'Element 3','Value']:N ['Dim 1':'hier','all elements'] - ['dim 1':'hier':'Element 3']; Where you're referring to an alternative hierarchy to pull back all elements and subt...

Hi, You didn't make it clear to me what current element means. If it means what is in the left side of the rule, then you could use the exclamation mark notation to specify the contextual element. But I guess that cant be what you mean, so what do you mean by current element? I could create a conso...

Hey guys, I need a calculation in my rules that sums up all elements except the current one. Something like this: ['Element 3','Value']:N ['Element 1'] + ['Element 2'] + ['Element 4'] The thing is... the Dimension changes constantly so I cant write a fixed statement and need some kind of logic. Sinc...

Hy guys, please allow me provide a short fix for ascheevels Code. It works like a charm but in a minuscle number of dates produces problems (yeah you guessed it we were lucky to test the code on such a date). The previous code does check wether a given date belongs to the ISO-week of the next year ....

This sounds like a bug that caused me to question my sanity last week: https://ibm.com/support/pages/apar/PH31597 IBM have stated its planned to be resolved in PA 2.0.9.6 LC and PA 2.0.9.1 IF 7 The incident and support team suggest that there are many potential causes of this which have not yet bee...

In what environment? If you're talking about the subset editor in classic Perspectives you would need to manually open the Expression Window from the View menu to see the MDX; it doesn't open automatically when you open the subset in Subset Editor. Hy Alan, nope I use the Subset-Editor in TM1-Archi...

Hy guys, another strange behaviour... I defined a dynamic Subset using MDX. It gets created and shows the filter icon. The subset "apparently" turns static after a few seconds though and the expression used to define it is lost as well if I open it in the Subseteditor. Looking into the SUB...

Hy guys, I am currently trying to monitor the amount of concurrent users in our system (I need this system to optimize our Batch and Patch timeframes for when there´s no one online). I am currently logging via the method described here: https://www.tm1forum.com/viewtopic.php?t=9247 And the Logfile l...

Thanks for posting the pic, I didn't realize you were using the same exact view. For your cube copy, you'll likely want to export to csv/txt first and then import the exported file instead of intra cube copy. With heavy rules as you say, you can expect slow performance trying to read and write from...

Hy ascheevel, I didnt post pics of different views, because I use the exactly same view in both cases (TextExport and TI) ... hence my utter confusion. Please find the picture of the view definition attached. Definition is really simple. "N-Elemente" are dynamic subsets containing all leaf...

Hy Wim Hy Lotsaram, thank you for your support. The bedrock processes are impressive! Still for my current task at hand even those seem not enough (I did mention that the element in question has a lot of active rules). I just had to abort the copy process after 2 hours runtime. The CPU usage was gre...

Hy lotsaram,

thanks for the links.

However I was hoping for a smaller solution than implementing a new dev-environment (Although this might be a good justification to look deeper into Cubewise & Bedrock, which I planned on doing anyway).

Regards Aerouge

Hello TM1 community. I am somewhat struggeling with a process automation. We have a cube with several rule calculated cells we wish to export. (Actually we want to write the data from an element where the rules are in effect to an element without rules (so a hardcopy of the rules results), so we can...

I knew it was something too obvious

Anyway thanks Paul Works like a charm.

Hello everybody, we are currently considering switching our TM1 servers to run as a service. Only problem we have encountered so far is this litle sentence from the IBM Operation Guide The SaveTime parameter is not available when running the TM1® server as a Windows® service. Currently we utilize th...