Search found 494 matches

by gtonkin
Thu Oct 19, 2017 6:27 pm
Forum: Cognos TM1
Topic: Chore Details
Replies: 6
Views: 94

Re: Chore Details

Pleasure-I guess if you were so inclined, you could build a TI to run through the *.cho and build your own "}Chores" cube with the necessary detail.
by gtonkin
Thu Oct 19, 2017 4:56 pm
Forum: Cognos TM1
Topic: Chore Details
Replies: 6
Views: 94

Re: Chore Details

C:\TM1 Data\BBPS>type "User Group Extract.cho" 534,10 535,"User Group Extract" 530,20140425023148 537,0 531,001061218 532,1 ... Control code 531 relates to the schedule-format dddhhmmss in my example, run every 1 day , 6hours, 12 minutes and 18 seconds-(changed the details for purposes of postin...
by gtonkin
Thu Oct 19, 2017 4:00 pm
Forum: Cognos TM1
Topic: Chore Details
Replies: 6
Views: 94

Re: Chore Details

Hi Tom, the schedule details are against a control code if you look in the .cho file-the frequency, hour, minute etc. are in one string-I can try unpack a bit later for you if you don’t find it-on my mobile at the moment
by gtonkin
Tue Oct 10, 2017 3:57 pm
Forum: Cognos TM1
Topic: Help on Active Form
Replies: 4
Views: 114

Re: Help on Active Form

Please post the formulas for Test1 and Test2.
Do they reference the cube or the TM1RptView cell?
by gtonkin
Tue Oct 10, 2017 12:22 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheets - Scroll to bottom not showing all rows
Replies: 0
Views: 66

TM1Web Websheets - Scroll to bottom not showing all rows

Had an issue today with and ActiveForm in a websheet. Websheet would build about 100 rows or so requiring the user to scroll down on the vertical scroll bar, page down or down arrow to get to off screen detail. The problem was that scroll to the bottom ended prematurely and by zooming out, you could...
by gtonkin
Fri Oct 06, 2017 7:29 am
Forum: Cognos TM1
Topic: Improve TI process time for cubes with heavy rules
Replies: 11
Views: 358

Re: Improve TI process time for cubes with heavy rules

Similar models I have running at clients are instantaneous and also handle joiners, leavers, transfers, annual increases, performance increases (based on tenure), benefits based on role,grading etc. etc. Everything is rule based and a change e.g. termination date, override in salary, change to benef...
by gtonkin
Thu Oct 05, 2017 6:56 pm
Forum: Cognos TM1
Topic: Median in tm1 using mdx sort
Replies: 4
Views: 126

Re: Median in tm1 using mdx sort

...Is there a way to directly get the 5 th and 6th order value in the set ? ... Maybe not the exact values as you are dealing with a list of elements and not cells. However this may at least narrow your list: HEAD( TAIL( { ORDER( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECU...
by gtonkin
Tue Oct 03, 2017 5:52 pm
Forum: Cognos TM1
Topic: TM Error CAM-CRP-1116
Replies: 2
Views: 126

Re: TM Error CAM-CRP-1116

Wild guessing here-Is this a fresh install? Have you applied all the SSL updates?
Anything else you can add in terms of changes in environment etc. if not a fresh install? Can you see the server as ready in the logs? Can you see it in Architect? Does security mode 1 allow access?
by gtonkin
Tue Oct 03, 2017 1:30 pm
Forum: Cognos TM1
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 369

Re: Performance of Architect Vs Perspectives

Perspectives does NOT use IIS/Tomcat or other Web server. Perspectives is an add-in to Excel and talks directly to the admin server and relevant tm1 server. TM1 Web and Contributor investigations are not relevant for your issue relating to a slice being slower than a view refresh.
by gtonkin
Tue Oct 03, 2017 10:07 am
Forum: Cognos TM1
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 369

Re: Performance of Architect Vs Perspectives

Have you at least got MTQ configured?
Is Excel definitely set to manual calculation?
by gtonkin
Thu Sep 28, 2017 9:38 am
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 12
Views: 380

Re: Undo after save in Excel 2016 with TM1 add in

I have loaded a service request for this issue: 69715-689-864 Not sure who will be able to access but it has been logged.
Will post updates as I receive.
by gtonkin
Fri Sep 22, 2017 12:01 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 12
Views: 380

Re: Undo after save in Excel 2016 with TM1 add in

Same Office build as Wim, can confirm disappearing with either 10.2.2 FP4 Perspectives or PA 2.0.1 Perspectives addin.
If I Step into Macro Code and repeat the steps, whatever event is being triggered is no longer triggered and my values remain.
Will play a bit more later...
by gtonkin
Fri Sep 22, 2017 4:14 am
Forum: Cognos TM1
Topic: Unable to launch TM1 Perspective
Replies: 4
Views: 142

Re: Unable to launch TM1 Perspective

I had this issue with a client a while ago and sent my colleague this link to try and resolve. He seemed to fix it but not sure exactly what he did in the end. Have a read and see if any of the suggestions work for you.
by gtonkin
Thu Sep 21, 2017 7:35 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 12
Views: 380

Re: Undo after save in Excel 2016 with TM1 add in

@Alan, any difference in behaviour when loading as an addin vs opening TM1P.xla? My laptop is on PAL 2.0.1 with Office 365, 64-bit -has the new auto save-will run some tests in the morning and reply if I find any similarities. BTW, the issue my colleague is having does not seem to be limited to savi...
by gtonkin
Thu Sep 21, 2017 5:00 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 12
Views: 380

Re: Undo after save in Excel 2016 with TM1 add in

I have a colleague who narrowly escaped being committed for saying the same thing. He is running Office 365 (2016 64-bit) and Planning Analytics as the TM1 server, TM1 adding for PAL-think he is on 2.0.2 but will need to confirm. What versions of TM1 and Client are you running? If you create a basic...
by gtonkin
Mon Sep 18, 2017 5:50 pm
Forum: Cognos TM1
Topic: CubeProcessFeeders - when to use?
Replies: 6
Views: 498

Re: CubeProcessFeeders - when to use?

... Some feeders are based on a reference to an attribute value and after restart those feeder will not re-fire (If I check the source cells with "Trace feeders..." shows that the target cell is feed but still the target values are "zeroed-out"). After re-save of the rule file or running a TI proc ...
by gtonkin
Sat Sep 16, 2017 6:15 pm
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 284

Re: Creating Cube Generates "Cell type is string" error

Glad we could help and happy that you got there. I think you nailed it when you realized that the variable type relates to the type of data to be stored in the cell!
by gtonkin
Sat Sep 16, 2017 10:00 am
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 284

Re: Creating Cube Generates "Cell type is string" error

My two cents worth on this as it was explained to me in a similar manner as what Alan, Lotsaram and Wim have said but at the time it made no sense and seemed to contradict. This is basically what I tell new starters (trimmed down version): Dimensions contain elements. Elements are the things that gi...
by gtonkin
Thu Sep 14, 2017 5:59 pm
Forum: Cognos TM1
Topic: TM1 License Question
Replies: 3
Views: 207

Re: TM1 License Question

Hi Jim, my logic tells me NO as this is not a user, modeler or data server and have never seen a part no. for it or any other reference to licensing the Excel service. The architecture has also always positioned web away from the data server (and in my mind licensing). As with all things licensing r...
by gtonkin
Wed Sep 06, 2017 7:46 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheet Charts / Graphs not rendering
Replies: 9
Views: 569

Re: TM1Web Websheet Charts / Graphs not rendering

Thanks for testing this out-Will try it again but did not seem to work whether I left 5, 50, 100 or more rows before hiding.