Search found 504 matches

by gtonkin
Tue Nov 14, 2017 4:48 pm
Forum: Cognos TM1
Topic: after Cube optimization -> TI won't run
Replies: 7
Views: 264

Re: after Cube optimization -> TI won't run

Should you be suppressing zeroes - you don't appear to be [ViewExtractSkipCalcsSet (sCube, sqView, 0); ]-this could be using too much memory - anything in your tm1server.log or tm1processerrors?
by gtonkin
Tue Nov 14, 2017 3:45 am
Forum: Cognos TM1
Topic: Installation of TM1 Perspectives: Excel crash
Replies: 3
Views: 251

Re: Installation of TM1 Perspectives: Excel crash

Hi Wim,
Just updated to same release, no issues on my side-I do however load Perspectives via a macro as I switch between 10.2.2 and PAL.
Not sure if that would make any difference in behaviour i.e. Add-in vs Open after launching Excel.
by gtonkin
Mon Nov 13, 2017 3:07 pm
Forum: Useful code, tips and tricks
Topic: Inspecting views
Replies: 3
Views: 256

Re: Inspecting views

Thanks Wim-still trying to find time to digest the previous processes shared-will add to my backlog!
by gtonkin
Wed Nov 01, 2017 6:39 pm
Forum: Cognos TM1
Topic: Unusual Problems with Text Files in TI Processes
Replies: 3
Views: 136

Re: Unusual Problems with Text Files in TI Processes

When you say that a CSV file loads with no problems, but the TXT does not, I get confused, unless you are generating two different files from the ERP.

The file extension should have no impact. What are the field separators in both the CSV and TXT files, for clarification?
by gtonkin
Tue Oct 31, 2017 4:24 pm
Forum: Cognos TM1
Topic: Unwinding specific elements in GLobal Customer diension
Replies: 1
Views: 99

Re: Unwinding specific elements in GLobal Customer diension

Why not use a subset as the basis for your unwinding with only the elements you want to unwind otherwise use ELISANC to check if an element is part of the rollups to skip?
by gtonkin
Sat Oct 28, 2017 2:39 pm
Forum: Cognos TM1
Topic: Undo after save in Excel 2016 with TM1 add in
Replies: 15
Views: 626

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

Can also concur with the above-just updated to Build 1709 (8528.2147) and the pre-halloween gremlins have gone, for now!
by gtonkin
Fri Oct 27, 2017 11:39 am
Forum: Cognos TM1
Topic: TM1 upgrade to Planning Analytics
Replies: 3
Views: 175

Re: TM1 upgrade to Planning Analytics

If you do install PAW, you would need to buy licenses on a 1 to 1 ratio for existing users.
Once upgraded, you cannot downgrade: http://www.ibm.com/support/docview.wss? ... SS9RXT-_-E
by gtonkin
Tue Oct 24, 2017 11:29 am
Forum: Cognos TM1
Topic: ExecuteCommand Copy file
Replies: 10
Views: 284

Re: ExecuteCommand Copy file

As soon as I save the file, seems to lose the char(150) and substitutes with a regular hyphen-cannot really do much more. Hopefully they will rename and you can move forward. I have had similar filenames in the past for Unix environments but managed to work with them by simply surrounding names in d...
by gtonkin
Tue Oct 24, 2017 10:31 am
Forum: Cognos TM1
Topic: ExecuteCommand Copy file
Replies: 10
Views: 284

Re: ExecuteCommand Copy file

Having a problem creating a file with the char(150) in the name-tried Excel VBA, File explorer etc. and it keeps replacing with a normal dash.
Could you upload a sample file, without the data of course.
by gtonkin
Tue Oct 24, 2017 4:31 am
Forum: Cognos TM1
Topic: ExecuteCommand Copy file
Replies: 10
Views: 284

Re: ExecuteCommand Copy file

Hi Mark, not seeing the same issue on my side - char 150 is emdash (AFAIK in office/windows and extended ascii in command line, u with circumflex), not a hyphen. I also notice that you are copying from a list using a wildcard, to one file i.e. last file copied remains-is this what you need or are yo...
by gtonkin
Thu Oct 19, 2017 6:27 pm
Forum: Cognos TM1
Topic: Chore Details
Replies: 7
Views: 243

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: 7
Views: 243

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: 7
Views: 243

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

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

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

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

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

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

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

Re: Performance of Architect Vs Perspectives

Have you at least got MTQ configured?
Is Excel definitely set to manual calculation?