Search found 1364 matches

by Steve Rowe
Fri Apr 20, 2018 8:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeding a C Level Calculation
Replies: 4
Views: 171

Re: Feeding a C Level Calculation

I'm not 100% sure but I think you have to have a non-zero value under the C, either as the result of a rule and a feeder or a value.

For me your design is off, why not just have an N level rule?
by Steve Rowe
Thu Apr 19, 2018 8:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct version of dimension updates
Replies: 5
Views: 218

Re: Direct version of dimension updates

Thanks for the input.

So if you were looping over a SQL source and doing direct inserts it would make sense to do a DimensionUpdateDirect in the Epilog of the master TI or the data load TI after ever read.
by Steve Rowe
Wed Apr 18, 2018 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct version of dimension updates
Replies: 5
Views: 218

Direct version of dimension updates

Hi, The benefits of the direct version of dimension updates are well known, i.e. you only need to process the datasource once. Has anyone encountered any disbenefits? i.e. increased lockiness or slower processing than doing it twice? Just curious and haven't the time to set up so clear tests. Cheers,
by Steve Rowe
Mon Apr 16, 2018 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 493

Re: Exporting data from view to file consuming memory

Gratz on your 100th post. You have two options (probably). 1. Feed your rules, this is the right solution. 2. Export your data in even smaller chunk, this is a workaround to not doing the above. Maybe if you explain why your rules are so hard to feed you'll get a solution, you are currently trying t...
by Steve Rowe
Thu Apr 12, 2018 8:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 493

Re: Exporting data from view to file consuming memory

If your dataset is not fed then the RAM consumption on exporting will be much larger than it needs to be, how much bigger depends on the level of sparsity. How many zero values are in the flat file (assuming you don't filter them out on export). Every zero will cost just as much as a value. The only...
by Steve Rowe
Mon Mar 26, 2018 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Do you want to update dimension worksheet?
Replies: 1
Views: 243

Re: Do you want to update dimension worksheet?

I'd always believed it to be the local data directory path in perspectives.
just too lazy to pursue
Not sure if this should be added to our FAQ.....lol
by Steve Rowe
Tue Mar 20, 2018 11:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTQ Question - Not using more CPU
Replies: 6
Views: 353

Re: MTQ Question - Not using more CPU

A complete guess from your screen shot.. The view and cube you are working with is rule based and the rule dependency with the attribute cube was not built at the time the view was requested. This forces the system single threaded when the dependency is added. Does anything show in the logs? You can...
by Steve Rowe
Tue Mar 20, 2018 9:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTQ Question - Not using more CPU
Replies: 6
Views: 353

Re: MTQ Question - Not using more CPU

Hi,
Difficult to answer this exactly but unless you are on a very current release then MTQ does not work on views that are the datasource for a TI, you need to pre-calculate the view first (ViewConstruct) and then use it as the source.
by Steve Rowe
Fri Mar 16, 2018 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 10
Views: 735

Re: Parallel run vs. ICX

Hi PeteB,

Please don't use other posts to drum up support for your RFE, we have a specific forum to post details of RFE in (http://www.tm1forum.com/viewforum.php?f=19).

If we allow this behaviour posts will become a mess of the OPs topic and people boosting their RFEs.

Many thanks,
by Steve Rowe
Thu Mar 08, 2018 1:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tool to detect overfeeding?
Replies: 16
Views: 6129

Re: Tool to detect overfeeding?

My two p. There's two kinds of overfeeding. [Left]=>[Right]; If you overfeed on the right then you end up with slower calculation performance and slower starter up times. This can be detected by the rule approach outlined above. If you overfeed from the left only then you end up with slow start ups ...
by Steve Rowe
Thu Mar 08, 2018 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - number of elements in a dimension
Replies: 4
Views: 515

Re: Planning Analytics - number of elements in a dimension

Pretty sure this gives the minimum amount of looping. If you want to work with all N levels irrespective of hierarchy then you can work with the automatically created Leaves hierarchy, this is supposed to contain all the N levels from all the hierarchies. C levels exist independently in each hierarc...
by Steve Rowe
Fri Mar 02, 2018 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: High Memory Consumption by TM1 Web application server on AIX Server
Replies: 2
Views: 354

Re: High Memory Consumption by TM1 Web application server on AIX Server

RAM consumption of TM1 web is driven by the size of the reports being consumed. You need to check the excel sheets published for large amounts of white space (ctrl+end in excel), TM1 Web will try and render the white space and this drives up RAM consumption. The more users you have and the larger th...
by Steve Rowe
Thu Mar 01, 2018 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Crash Due To Page File
Replies: 8
Views: 484

Re: Server Crash Due To Page File

Have you by any chance got any CA reports looking at (the new) hierarchies? The issue should be relatively easy to diagnose just by monitoring the DB and the stats cube, you have a repeatable issue. You'll need to monitor what's going on inside the DB, the external stat you list don't really help ot...
by Steve Rowe
Thu Mar 01, 2018 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 467

Re: Exporting changed data only - flag?

HyunaHyuna and tomok, Just to head off a flame war, I'd just like to say that both your last two posts contain valid points. tomok, you'll know that we have a policy and standard to follow if you are not happy with the approach a poster is taking. I'll lock this thread if there are any further off-t...
by Steve Rowe
Wed Feb 28, 2018 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 467

Re: Exporting changed data only - flag?

As kangkc implies but doesn't actually say a better approach to this would be to output a flat file that can be imported by the DB. I'd also support tomok, if you wanted to just move data changes the transaction log should be fine, assuming logging is on for the cubes concerned. It would be a pretty...
by Steve Rowe
Wed Feb 21, 2018 5:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using {AR01} functionality in a slice rather than Active Form
Replies: 6
Views: 362

Re: Using {AR01} functionality in a slice rather than Active Form

I'm not convinced there is any of doing this without having the relevant subset (really consolidation) present. Depending on the size of the problem could you create all the consolidations you could possibly require in the dimension in a TI process? I'm still not that clear on your use case to be ho...
by Steve Rowe
Thu Feb 15, 2018 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count the number of children and store it as an attribute for the parent
Replies: 5
Views: 394

Re: Count the number of children and store it as an attribute for the parent

Ok, then the rule is the way to go.

['Customer Count']=N:If ( Customer is active=1 , 1 , 0);
by Steve Rowe
Wed Feb 14, 2018 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count the number of children and store it as an attribute for the parent
Replies: 5
Views: 394

Re: Count the number of children and store it as an attribute for the parent

I wouldn't use an attribute as this stops the measure adding up. If you create a 2d cube of Customer and a Measure dimension with an element "customer count". Then either Just fully expand the customer dimension and spread a 1 into all cells "r|1" if you have customers on rows. or more dynamically u...
by Steve Rowe
Tue Feb 13, 2018 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Evaluation of DBRW Formula in VBA
Replies: 7
Views: 456

Re: Evaluation of DBRW Formula in VBA

Like most of the TM1 functions you can use Application.Run("DBRW" , Arg1 , Arg2, etc)
by Steve Rowe
Wed Feb 07, 2018 12:02 pm
Forum: Bugs
Topic: HierarchySubset functions don't work
Replies: 2
Views: 635

Re: HierarchySubset functions don't work

Did you try the old version of the function but using dimname:hiername for the dimension argument?