Search found 459 matches

by mattgoff
Tue Jun 04, 2019 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 5428

Re: Method for handling Rules for Actuals/Forecast periods

I'll throw my hat in the ring with our solution. Our model is middle-sized, maybe up to 30 GB in RAM depending on how long it's been since the last restart and how recently we've scrubbed out old saved snapshot versions. We handle actuals in the forecast version with rules. We have a control cube wi...
by mattgoff
Mon Jun 25, 2018 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with feeders
Replies: 7
Views: 5004

Re: Issue with feeders

Two suggestions: Stop server, delete .feeders files (if you use persistent feeders), restart server. Even if you're not using persistent feeders I've seen this resolve weird rule anomalies. Post or attach complete rule file, not an excerpt, which can help us rule out a problem elsewhere that's killi...
by mattgoff
Tue Feb 20, 2018 4:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading server with big-sized Cube and MaximumCubeLoadThreads
Replies: 2
Views: 2870

Re: Loading server with big-sized Cube and MaximumCubeLoadThreads

I don't believe MaximumCubeLoadThreads does much, if anything, to improve stored data loads from disk. Its performance advantage is that it multithreads rule computation and feeder firing after stored values are loaded.

Matt
by mattgoff
Tue Dec 12, 2017 10:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyway to prevent Files to Accidentally DBSW ?
Replies: 8
Views: 6063

Re: Anyway to prevent Files to Accidentally DBSW ?

I'm unclear with their =SUBNM("local:actvsbud","","SendW01") statement. What is this formula really doing? https://www.ibm.com/support/knowledgecenter/en/SSHM9K_10.2.2/com.ibm.swg.ba.cognos.ug_cxr.10.2.2.doc/r_cxr_subnmfunction.html =IF($D$4="YES",DBSWStage!C...
by mattgoff
Mon Dec 11, 2017 4:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyway to prevent Files to Accidentally DBSW ?
Replies: 8
Views: 6063

Re: Anyway to prevent Files to Accidentally DBSW ?

I meant to say DBSW. I updated topic title. I'm new to this. You're new to TM1 and you just made a mistake that caused you a lot of heartache. But the root cause is your inexperience with TM1, not TM1's design. Everything in TM1 happens instantly by default, by design. This ensures that, with few e...
by mattgoff
Mon Sep 18, 2017 5:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is an Element really? And, why the heck is an Element Type not an Element Type?
Replies: 4
Views: 3901

Re: What is an Element really? And, why the heck is an Element Type not an Element Type?

You're encountering the hardest part of OLAP systems which is that they do not work the way you would intuitively think they would coming from an Excel or relational database background. Your brain wants to relate (pun intended) back to those mental models, and it just will not fit. It's a steep lea...
by mattgoff
Fri Jun 16, 2017 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionDeleteAllElements failover
Replies: 14
Views: 10274

Re: DimensionDeleteAllElements failover

At present I just use a generic process for this. I would have written my own but since I already have the Bedrock processes installed Bedrock.Dim.Hierarchy.Unwind.Consolidation and Bedrock.Dim.Hierarchy.Unwind.All work well enough, so I just use those. Bedrock is awesome (with the caveat that a hu...
by mattgoff
Fri Jun 16, 2017 3:24 pm
Forum: Enhancements
Topic: RFE 106604: DimensionDeleteAllHierarchy
Replies: 2
Views: 14772

RFE 106604: DimensionDeleteAllHierarchy

https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=106604 What a better way to celebrate my 500th post than via documenting an RFE which will never be done.... It would be very handy to have a DimensionDeleteAllHierarchy command available in TI to be used when rebuilding a dim...
by mattgoff
Fri Jun 16, 2017 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionDeleteAllElements failover
Replies: 14
Views: 10274

Re: DimensionDeleteAllElements failover

Alan Kirk wrote:You may need to strip down the consolidation tree but you don't need to strip out the N elements..
Sounds like a good enhancement request. It would be handy to have a DimensionDeleteAllHierarchy as a easier alternative than coding it up yourself.

Matt
by mattgoff
Wed Jun 14, 2017 7:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Understanding Tm1 Rules
Replies: 4
Views: 3962

Re: Understanding Tm1 Rules

A couple of general comments: Why are the IF statements necessary in any/all of these rules? e.g. if Current AR is zero, the division is going to result in zero anyway. The element names here are pretty distinct, but it can be risky to use implied dimension names in rules as they can become ambiguou...
by mattgoff
Wed May 31, 2017 5:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: FIFO in TM1
Replies: 2
Views: 2912

Re: FIFO in TM1

I don't see why you need to do any specific accounting to match interest accrual and payment periods at all. I'm attaching a little model that shows how I would do it in Excel-- is this what you're trying to accomplish or am I missing it?

Matt
by mattgoff
Thu May 25, 2017 9:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Latency Dilema
Replies: 5
Views: 5060

Re: Latency Dilema

IanB wrote:Educating users where to save remote local files, however provides endless fun!
Have you investigated RemoteApp? It uses RDP but allows access to local resources (drives, printers, etc).

Matt
by mattgoff
Thu May 25, 2017 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Latency Dilema
Replies: 5
Views: 5060

Re: Latency Dilema

Moving this to a single global instance will not work well over a WAN - latency over 50ms compromises the user experience Interestingly, the ISB does work extremely well over WAN connections with latency of over 300ms 50 ms is pretty dang fast, and you're not going to have any usability problems wi...
by mattgoff
Wed May 24, 2017 1:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Data folder backup
Replies: 9
Views: 6520

Re: Server Data folder backup

In our case I separate the Save data and Zip in separate process with a window of 30 mins in between. Possible that the Save Data actually takes a long time ? Quite common though. I assume this means you are using a scheduled task in the OS to do the zip. Have you considered using ExecuteCommand in...
by mattgoff
Tue May 23, 2017 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Data folder backup
Replies: 9
Views: 6520

Re: Server Data folder backup

I do however never back up the live folder. I always copy the live folder to another and then zip from there. Maybe worthwhile trying this approach. Do you mean that copying the data directory and then 7zip using executecommand on that folder takes less time than not copying and 7zip on the data di...
by mattgoff
Thu Apr 27, 2017 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication:transaction log file
Replies: 6
Views: 5156

Re: Replication:transaction log file

The Replication/Synchronization feature in TM1 is not the most robust feature of the product and I don't think anything about is has changed in quite a few years. I'm at the point now where I think it is reliable if you set everything up right. I do agree that it should be used with great caution, ...
by mattgoff
Thu Apr 27, 2017 1:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication:transaction log file
Replies: 6
Views: 5156

Re: Replication:transaction log file

What I see when I analyze the replication log files is that on some day I had a replication error on the "A" cube, let's assume rollback was triggered. Then by logic At the next replication, if the data in the "A" cube did not change the replication again will not work and roll ...
by mattgoff
Wed Apr 26, 2017 5:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication:transaction log file
Replies: 6
Views: 5156

Re: Replication:transaction log file

Most of your questions are answered in the documentation: https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_op.10.2.2.doc/c_synchronizationprocess_n1106bb.html#SynchronizationProcess_N1106BB. Traversal of multiple tx log files is handled automatically-- doesn't matt...
by mattgoff
Wed Apr 05, 2017 2:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Large Cube to Cube advice
Replies: 5
Views: 4916

Re: Copy Large Cube to Cube advice

I find it a bit strange that no one has mentioned parallelising the load by breaking the view into multiple slices along one dimension. In 10.2.2 with parallel interaction this is an easy and foolproof way to reduce end to end processing time. Is this any faster than performance under 10.2.2 FP6 wh...