Search found 100 matches

by vladino
Fri Apr 13, 2018 6:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 527

Re: Exporting data from view to file consuming memory

Changing a value in a cube clears the cache for that cube and any 'downstream' cubes ie those which are linked back to that cube. Ok, let's try it this way... After each file is generated and the TI process goes to its Epilog part I will put a value somewhere to the source cube. Let's see what happ...
by vladino
Thu Apr 12, 2018 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 527

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 onl...
by vladino
Thu Apr 12, 2018 7:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 527

Re: Exporting data from view to file consuming memory

I think this is my problem here... All cells in the cube are calculated (and unfortunately not fed - the model is too complicated to be fed correctly but as far as I understand even exporting correctly fed cells won't solve the issue) so all memory is cunsumed by calculations and therefore not rele...
by vladino
Thu Apr 12, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 527

Re: Exporting data from view to file consuming memory

Once a TI process is finished (at least in 10.2.2 and above) this memory is released back to the OS unlike memory for calculation and view cache which stays in TM1's insternal garbage recycling. This was a surprise to me the first time I saw it. I think this is my problem here... All cells in the c...
by vladino
Thu Apr 12, 2018 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 527

Re: Exporting data from view to file consuming memory

If memory is really constrained you could clear the cache periodically by changing a value somewhere and changing it back again What do you mean by clearing the cache? Do you mean deleting stargate views? I'm afraid it won't release garbage memory which is what I need... Or am I wrong? The other wa...
by vladino
Thu Apr 12, 2018 2:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting data from view to file consuming memory
Replies: 13
Views: 527

Exporting data from view to file consuming memory

Hi guys, is there any difference when exporting data to files and importing it back to the target cube and moving data between cubes using CellPutN in regards of memory consumption? I'm exporting quite a huge amount of data to files but it consumes a lot of RAM and after the export is finished it''s...
by vladino
Wed Mar 28, 2018 11:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ForceReevaluationOfFeedersForFedCellsOnDataChange & no conditional feeders
Replies: 0
Views: 236

ForceReevaluationOfFeedersForFedCellsOnDataChange & no conditional feeders

Hi guys,
just a quick check - if we don't use any conditional feeders, we can safely turn off ForceReevaluationOfFeedersForFedCellsOnDataChange in cfg, right?

We need to leave it in the cfg because of PM but we can switch it off by setting it to "F".

Is it correct?

BR
Vladino
by vladino
Thu Mar 01, 2018 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 10
Views: 762

Re: Parallel run vs. ICX

If it's not the same cube then view names could be the same. If dimensions are common even if cubes aren't then the subsets need to be uniquely named if there is any manipulation (editing) of the subsets . You could use the same subset name where all the TI processes don't touch or edit the subset ...
by vladino
Thu Mar 01, 2018 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 10
Views: 762

Re: Parallel run vs. ICX

Drg wrote:
Thu Mar 01, 2018 1:51 pm
dear friend, let's imagine a situation where you open an architect and run one of your processes. after you run another architect and try to log in and execute the second process.
what result will you get?
I guess it depends on what is the purpose of both processes? :)
by vladino
Thu Mar 01, 2018 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 10
Views: 762

Re: Parallel run vs. ICX

All object names need to be unique. For parallel processing from/to the same cube it is important that all views and all subsets be uniquely named. Even if all views are using the same subset for products, measures etc? It's not the same cube, I'm just exporting the data from the cube to the text f...
by vladino
Wed Feb 28, 2018 10:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 10
Views: 762

Parallel run vs. ICX

Hi guys, I'm trying to run several TI processes in parallel - sometimes I'm successful but sometimes not. Here's the thing... I have one source cube and one target cube. The structure is nearly the same and I need to get the data out of the source cube and transfer it into the target one. For some p...
by vladino
Wed Feb 14, 2018 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 842

Re: TM1RunTI and number of cores/threads

Trying to run it from command line, from TM1 server "Data" folder. Hustle.exe is placed in the same folder as Data folder, so is HUSTLE.txt file. Hustle_batch.bat ..\Hustle.exe ..\HUSTLE.txt 10 HUSTLE.txt "C:/Program Files/ibm/cognos/tm1_64/bin64/tm1runti.exe" -adminhost tm1admin -server TM1 -user T...
by vladino
Wed Feb 14, 2018 12:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 842

Re: TM1RunTI and number of cores/threads

try https://github.com/cubewise-code/hustle it is a free utility which manages command line queues. All you need to do is tell the program how many threads to run at once and it will do the rest. Is there any logfile for Hustle? I'm trying to run it but I'm getting this output: Starting processes.....
by vladino
Wed Feb 07, 2018 7:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RunTI and number of cores/threads
Replies: 9
Views: 842

TM1RunTI and number of cores/threads

Hi guys, is there any way how to tell the TM1 instance how many cores can be used for parallel interaction via TM1RunTI and how many cores need to be "reserved" for users? Let's say I have 16 threads on TM1 server and I run 60 processes in parallel via TM1RunTI. How to tell TM1 that for TI execution...
by vladino
Tue Jan 16, 2018 7:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Unable to fetch data" in PAW book
Replies: 4
Views: 292

Re: "Unable to fetch data" in PAW book

macsir wrote:
Tue Jan 16, 2018 5:04 am
Have you setup session limit for that user? You need to use 0 which is unlimited, otherwise it will reach the upper limit quickly. :D
I don't think we have updated any session limit for PAW. Could you please navigate me where to find this setting?

BR
Vladino
by vladino
Mon Jan 15, 2018 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Unable to fetch data" in PAW book
Replies: 4
Views: 292

"Unable to fetch data" in PAW book

Hi guys,
for some views in our PAW books we are getting "Unable to fetch data" error, see attached.

What exactly does this mean? I'm able to open the same view in PM or in TM1 apps web.

Thanks for any suggestion!

BR
Vladino
by vladino
Wed Jan 10, 2018 12:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset and rule execution
Replies: 2
Views: 287

Dynamic subset and rule execution

Hi guys, I'm wondering how the rule is executed when dynamic subset is used within a cube view. If my understanding is correct the rule is always executed only for cells within a view, not for the whole cube. So if I use a static subset then only members within the subset are evaluated/calculated - ...
by vladino
Tue Jan 09, 2018 6:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Stargate views questions
Replies: 1
Views: 250

Stargate views questions

Hi guys, I have some questions regarding stargate views creation. 1. When using dynamic subsets in the view (ie. dynamically selected products by an attribute) - is stargate view generated only for specific products that meet the condition in the MDX or for all products? 2. Is VMM parameter in bytes...
by vladino
Tue Jan 02, 2018 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reset views and tabs in TM1 applications web
Replies: 11
Views: 1028

Re: How to reset views and tabs in TM1 applications web

tomok wrote:
Thu Dec 28, 2017 12:48 pm
You have to delete the files AND restart the TM1 service.
Bullseye!