Search found 22 matches

by jwafro
Tue Jun 12, 2018 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 798

Re: How to reference data lines as variables in TI?

Truncation to do with using Expand https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_expand.html That string has a fixed minimum length of 10 characters. If the converted number is too small to fill 10 characters, it is padded with le...
by jwafro
Tue Jun 12, 2018 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 798

Re: How to reference data lines as variables in TI?

Having discovered Expand function, it certainly is very helpful.

Any suggestions on how to get around the truncation issue? my values are all decimal places eg 0.00123456, the process requires a higher degree of accuracy :D
by jwafro
Tue Jun 12, 2018 12:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues with new instance
Replies: 9
Views: 551

Re: Issues with new instance

Someone stop me if I'm wrong, but I believe you can only have one local server running on a machine? Can you check both config files for both versions to check that you have different values for PortNumber= HTTPPortNumber= I know HTTPPortNumber needs to be different in 10.3 Is the main model on a di...
by jwafro
Tue Jun 12, 2018 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues with new instance
Replies: 9
Views: 551

Re: Issues with new instance

Ok, so the config file hasn't been overwritten when you copied the original db folder.
Your File locations have been changed as well, I presume?

Is your client - eg Architect/Perspectives looking at local server or have you specified the admin host IP address?
by jwafro
Tue Jun 12, 2018 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What can cause variability in recalculation times?
Replies: 2
Views: 637

Re: What can cause variability in recalculation times?

Hi Duncan Yes, I write a cell in the cube to clear it prior to each refresh of the calculation. (and then delete that value) I didn't determine what happened to the cube, however though rebuilding the model's design and removing a dimension, Ive brought the recalc speeds down to around 2 min, so hap...
by jwafro
Tue Jun 12, 2018 10:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues with new instance
Replies: 9
Views: 551

Re: Issues with new instance

have you copied the original config file over from the original model?
by jwafro
Tue Jun 12, 2018 10:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 798

How to reference data lines as variables in TI?

Hi All I am attempting to automate a data load of curves into my model, which has potentially hundreds of columns of data. Aside from initial data points, the naming convention TI has selected works for me ; eg Coll1 Coll2 .. Coll500 etc. The cube I am loading to has a dimension with '1','2' .. etc....
by jwafro
Thu Mar 29, 2018 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What can cause variability in recalculation times?
Replies: 2
Views: 637

What can cause variability in recalculation times?

Hi All I have been challenged to improve the performance of our budgeting model. It is very slow ~ over 15 minutes for a system recalc on average. I have also been required to set challenging SLA's for system performance, which I will be held to and have to report against. As such I have been workin...
by jwafro
Wed Jan 03, 2018 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Does it have rules tracer?
Replies: 5
Views: 841

Re: PAX - Does it have rules tracer?

Thanks, I'll write my presentation assuming use of Perspectives then.

Ta
Josh
by jwafro
Wed Jan 03, 2018 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX - Does it have rules tracer?
Replies: 5
Views: 841

PAX - Does it have rules tracer?

Hi All

My business is considering updating from 10.2.2 to 10.3.

We use perspectives via Citrix for user interaction, because our users need access to Rules Tracer.

I couldn't find a specific mention of rules tracer being available in PAX.

Ta
Josh
by jwafro
Wed Oct 04, 2017 10:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

Thanks Paul It is time consuming, but to avoid network as a variable I've run the initial tests 1 at a time on the server itself, so should be direct, with at worst one or two other processes running (ive capped the MTQ to 25% of server capacity to help prevent that sort of related variability while...
by jwafro
Tue Oct 03, 2017 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

Thanks, I thought as much about the 64bit. I totally understand that the model is a factor, its incredibly complex, legacy and I've been tasked with migrating it to a new accounting standard. It absolutely is overfed, poorly designed and all that. But it works, and I don't have time to fix and test ...
by jwafro
Tue Oct 03, 2017 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

Ok, thanks. The base issue, regardless of model performance, is a material time differential between the two access methods for the same view refresh. So what I am hearing is that there should be minimal/immaterial lag/time variance between excel/Perspectives plugin and TM1. There are no settings I ...
by jwafro
Tue Oct 03, 2017 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

Ok, thanks for the clarification.

To clarify, the issue is a view created in perspectives (within the GUI, not a slice) takes longer then Architect.
by jwafro
Tue Oct 03, 2017 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

ive read somewhere on the forum this: "Architect seems to go tcp/ip direct to the Server whereas Perspectives is using the WebServer IIS. Tomcat etc (ours is IIS) so it will always run more slowly." http://www.tm1forum.com/viewtopic.php?t=1081 Is there anyway to tweek Tomcat (which I am using) to im...
by jwafro
Tue Oct 03, 2017 10:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

Yes, MTQ is set to 6, and the view creation in Excel is run through perspectives rather then a data pull through excel

J
by jwafro
Tue Oct 03, 2017 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Re: Performance of Architect Vs Perspectives

Hi Wim

Its a test view of several years consolidated data. I can acknowledge the model is lacking performance optimization/overfeeding certainly, but I am limited with time as my users are having to budget..
by jwafro
Tue Oct 03, 2017 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 1500

Performance of Architect Vs Perspectives

Hi I am testing my model and am noticing different times to recalculate a standard view between Architect and Perspectives on my server. I have spun up the same model twice on two instances and have the loggers recording view opening details, so I get precise times. I restart the instances once the ...
by jwafro
Tue Sep 19, 2017 10:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to purge a stargate view?
Replies: 4
Views: 624

Re: Is it possible to purge a stargate view?

I note that Right-Clicking on Architect 'Unload Cube' also forces a reevaluation of feeders, does the TI script approach perform the same function?

J