Search found 1372 matches

by Steve Rowe
Sun May 20, 2018 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ordering of Dimensions
Replies: 1
Views: 107

Re: Ordering of Dimensions

So the rule of thumb is shortest sparsest to longest and most dense. I don't think that density is as simple as (No of populated cells/ No of N level cells), it is more "if Element 1 is populated, if I keep all the other cell references the same, what is the likelihood of Element 2 being populated a...
by Steve Rowe
Wed May 16, 2018 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Access Flag not being Deployed
Replies: 6
Views: 157

Re: Security Access Flag not being Deployed

Not sure if this has changed at some point but I've always had to do this since this bit of logic was introduced. Not sure where the security access state of a TI is stored, I would have though there ought to a }Process_Properties cube somewhere but I've never spotted where. AFAIK the security state...
by Steve Rowe
Tue May 15, 2018 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 6
Views: 182

Re: Filtered by string measure in a 3 dimension cube

Hi Wim, I do this a lot to get the base form of the MDX that I want to use in active forms or elsewhere so it is very much possible. Maybe one of those things that was not available on first release and you've not revisited? That happens to me, small change that I've not picked up on, or maybe just ...
by Steve Rowe
Tue May 15, 2018 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filtered by string measure in a 3 dimension cube
Replies: 6
Views: 182

Re: Filtered by string measure in a 3 dimension cube

If you still have access to the Perspectives subset editor then you can record the MDX for what you want by turning the recorder on and then using the filter dialogue.
by Steve Rowe
Thu May 10, 2018 8:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube ViewTo Excel/CSV
Replies: 8
Views: 5158

Re: Export Cube ViewTo Excel/CSV

Hmmm, you need to convert each field/column/variable to a string independently, so if you have 5 numeric variables then you'll need to write. AsciiOutput( 'WhyIsThisFunctionNameSoLong.cma' , NumberToString( v1) , NumberToString( v2) , NumberToString( v3) , NumberToString( v4) , NumberToString( v5) )...
by Steve Rowe
Wed May 09, 2018 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 291

Re: stored values in tm1

This issue comes up fairly often and is caused by the floating point arithmetic used by computers in general to store values, simply put not all decimal numbers can be stored exactly in binary leading to very small rounding issues. https://en.wikipedia.org/wiki/Floating-point_arithmetic In this mann...
by Steve Rowe
Thu May 03, 2018 8:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 1640

Re: PAW installation help

We found that there was a step up in RAM required for PAW to launch in a recent release, previously 8GB was sufficient for the OS and PAW but no longer. We got it to run up on 9 just but would suggest spec'ing a PAW box at 16GB for comfort. We found that installs on W16 with sufficient RAM for docke...
by Steve Rowe
Tue Apr 24, 2018 2:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 6
Views: 581

Re: Server Locked after save data process and save data is running for a long time .

I'd have a think about how those views are used and created. Going from the naming I'd guess they are part of the data load. How are they created (i.e. permanent, old style built in a TI view, new temporary views built in a TI) How are they deleted (no need, at the end of the job, we don't bother as...
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: 320

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: 324

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: 324

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: 19
Views: 874

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: 19
Views: 874

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: 275

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: 457

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: 457

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: 841

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: 6259

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: 572

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: 393

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...