TM1 Forum

The Go New Stores sample model you looked at was probably created through Performance Modeler. In contrast to the legacy/classic (or whatever you want to call them) development UIs, PM supports the concept of dimension types - like Time, Version and also Calculation. For elements of a Calculation di...

This seems the have been introduced with Fix Pack 1 for TM1 10.1.1 (i.e. TM1 10.1.1 FP1). The "undefined" checkbox when adding new planning server looks like an unfinished feature to disable checking for specific parameters in the new server's tm1s.cfg file. Main problem is, as you say, th...

I feel very, very dumb. Shosty, I should be the one feeling dumb as I put you on a wild goose chase by not reading you're question properly. You mentioned GO_New_Stores as well (which is a different server as the greatoutdoors one), its logfiles should be here: C:\Program Files\ibm\cognos\tm1_64\sa...

Perhaps not the same issue then - sorry if I put you on the wrong track. Sometimes a TM1 server appears to start as expected but fails later in the process. What are the last entries in the tm1server.log message file after start up? Mine say: FATAL ... TM1.Transaction TM1TransactionLog::ProcessTrans...

The Great Outdoors sample TM1 server regularly fails to start after a reboot of my VM - might be the same issue you're experiencing. In my case it seems the transaction logfile somehow gets corrupted. Try to delete the tm1s.log file (on my VM it's in C:\Program Files\ibm\cognos\tm1_64\webcontent\sam...

As far as I know taking ownership (or creating a sandbox) does not save a copy of the rules. However, opening an application node with Cognos Insight in Distributed mode will create a local copy of (a subset of) the model - including rules. Updates to the rules on the central server do not seem to b...

Alan Kirk wrote: How much time it has cost me to change variables from Ignore to Other since you can't set a default. You probably already know this but just in case: you can copy the Content setting from one variable and then paste it to multiple other variables in one go. Not as convenient as cho...

In case the applications reside in multiple TM1 servers, you may want to check if all of these server names are registered on the Application server (rightmost button in the toolbar of the TM1 Applications portal). If not, try if re-registering solves the issue. Alternatively, restore the fpmsvc_con...

I wasn't aware you could reference other dimensions in a dynamic subset expression - never to old to learn I guess:) It seems a reference to (an attribute of) another dimension without providing a specific element is resolved by taking the first member of that dimension. I.e. [SalesMan].[SPCode] wou...

I've not used DimensionTopElementInsert/DimensionTopElementInsertDirect myself either nor were they used to reproduce the issue. What these functions appear to do though, is consolidate multiple root elements (if any) into a single top element in one go; no need to add the existing root elements ind...

FYI: I managed to reproduce Lotsaram's issue both in CX 10.1 and in TM1 10.1 itself (on which CX 10.1 is based). It seems to be resolved in CX 10.1 FP1 and TM1 10.1.1/10.1.1.1.

What seems to work for me is attaching the following MDX expression to the subset:

{ORDER({TM1SUBSETALL( [Products] )}, MemberToStr([Products].CurrentMember), ASC)}

This may not work in all circumstances but is perhaps worth a try.