Search found 479 matches

by gtonkin
Mon Sep 18, 2017 5:50 pm
Forum: Cognos TM1
Topic: CubeProcessFeeders - when to use?
Replies: 6
Views: 400

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

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

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

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

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.
by gtonkin
Wed Sep 06, 2017 6:57 pm
Forum: Useful code, tips and tricks
Topic: TM1Web Websheet Charts / Graphs not rendering
Replies: 9
Views: 459

Re: TM1Web Websheet Charts / Graphs not rendering

Did You check If the Hidden options are selected on Select Data option on the chart setup?like the atachment Hi Rafaewolie, thanks for the suggestion but unfortunately this is one of the things I tried without success. For now I am making sure that I delete "unused" rows and columns then hide the c...
by gtonkin
Wed Sep 06, 2017 5:35 am
Forum: Cognos TM1
Topic: Filter a cube view based on the dimension element
Replies: 1
Views: 80

Re: Filter a cube view based on the dimension element

The problem is that you are going to have combinations of Department and Item and by filtering on only item, you will end up with a list of items where and Employee may be marked as New but not for that department. If you are only ever working with one department then the below may work for you: Try...
by gtonkin
Mon Sep 04, 2017 6:19 pm
Forum: Cognos TM1
Topic: TM1RPTROW Repeat Problem
Replies: 19
Views: 360

Re: TM1RPTROW Repeat Problem

As a first step, try replacing {TM1SubsetBasis()} with the relevant element that you want to start with e.g. {[GRL.D.Contas_Contabeis].Members} - TM1SubsetBasis() in my opinion will create problems. If all you want to do is select the root element and expand it once, you could try: { DRILLDOWNMEMBER...
by gtonkin
Sun Sep 03, 2017 6:14 pm
Forum: Useful code, tips and tricks
Topic: Managing the PAW VM (VirtualBox)
Replies: 0
Views: 73

Managing the PAW VM (VirtualBox)

The VM is created as a Headerless machine. VBoxManage.exe can be found in “C:\Program Files\Oracle\VirtualBox”. This gives you various commands to help manage the VM - run from Administrator:Command Prompt VBoxManage list vms Will return a list of VMs configured within Oracle Virtualbox e.g. "paw" {...
by gtonkin
Thu Aug 31, 2017 5:38 am
Forum: Cognos TM1
Topic: PAW installation help
Replies: 6
Views: 279

Re: PAW installation help

Found a SysInternals app called VMMap - Allows you to find out a lot more detail on the memory usage of each of the VMs running: VMMap.PNG The above on my machine is pretty much a vanilla install with one Book with one Sheet and one small view-not sure as to how this will grow as more workspace obje...
by gtonkin
Wed Aug 30, 2017 5:22 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 281

Re: ASCIIOUTPUT to csv to show data in different columns

Wim Gielis wrote:
Wed Aug 30, 2017 4:16 pm
I did a quick test George and TEXTOUTPUT seems to use the datasourceasciidelimiter.
Thanks Wim-noted.
by gtonkin
Wed Aug 30, 2017 3:32 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 281

Re: ASCIIOUTPUT to csv to show data in different columns

Have not had the time to test it but would TextOutput also apply the DatasourceASCIIDelimiter & DatasourceASCIIQuoteCharacter or do comma delimited?
by gtonkin
Wed Aug 30, 2017 3:29 pm
Forum: Cognos TM1
Topic: PAW installation help
Replies: 6
Views: 279

Re: PAW installation help

Can confirm too that it is happy with Win 8.1 - running on my laptop - it is an antique but has 16GB RAM, a huge SSD and a 32GB Swap file on that SSD. With a basic model on the VM running through virtualboxheadless (and other bits and bobs) I am running at about 12GB for now.
by gtonkin
Mon Aug 28, 2017 1:46 pm
Forum: Cognos TM1
Topic: VBA Macro errors in Excel 2016
Replies: 17
Views: 481

Re: VBA Macro errors in Excel 2016

Just out of curiosity, do you have the same behaviour when you run the macro after opening the workbook from applications vs opening from your local drive/network? My own experience (but could be my machine) is that when I open a workbook from Applications and work with it, I have some inexplicable ...
by gtonkin
Mon Aug 28, 2017 1:04 pm
Forum: Useful code, tips and tricks
Topic: Delete method of Worksheet class failed
Replies: 0
Views: 70

Delete method of Worksheet class failed

Had a template that I needed to run TM1 Print Report on, but kept failing with "Print Report-Delete method of Worksheet class failed" - turned out to be a sheet that was flagged as Visible:=2-xlSheetVeryHidden. Changed to visible and deleted in my case-all fine now. Seemed fine if set to 0-xlSheetHi...
by gtonkin
Thu Aug 24, 2017 4:44 pm
Forum: Cognos TM1
Topic: VBA Macro errors in Excel 2016
Replies: 17
Views: 481

Re: VBA Macro errors in Excel 2016

Do you disable events and screen updating as one of the first commands when the button is clicked?
by gtonkin
Mon Aug 21, 2017 5:42 am
Forum: Cognos TM1
Topic: Trouble setting up integrated login in TM1 10.2
Replies: 16
Views: 858

Re: Trouble setting up integrated login in TM1 10.2

HI Kaz, I have not been down the road of Method 2-Integrated Login using the DevWorks method (I like what little sanity I have) I would however make sure that Method 1 is configured and works. From the error logs, what comes to mind is SSL certificate updates i.e. the ones replaced last year-did you...
by gtonkin
Fri Aug 18, 2017 8:38 am
Forum: Cognos TM1
Topic: Trouble setting up integrated login in TM1 10.2
Replies: 16
Views: 858

Re: Trouble setting up integrated login in TM1 10.2

I think you are going to require lots of patience if you head down this road. There are two options AFAIK: 1) Single Signon 2) Integrated login The two are not synonymous - Single Signon allows you to authenticate with your windows credentials i.e. type in your userid and password. Integrated Login ...
by gtonkin
Thu Aug 17, 2017 1:03 pm
Forum: General
Topic: Upcoming server migration
Replies: 15
Views: 1434

Re: Upcoming server migration

HI Martin- saw this link Re: having email notification contain post body? Not sure if you have all the details on what to change but thought I would post in case you don't have them to hand.
by gtonkin
Thu Aug 17, 2017 8:48 am
Forum: Cognos TM1
Topic: Trouble setting up integrated login in TM1 10.2
Replies: 16
Views: 858

Re: Trouble setting up integrated login in TM1 10.2

...And, do you know the preferred format of user & domain name for setting SPN for tm1s? I say that because I have different formats;... Hard to say for sure but I generally use the domain returned from a plain whoami without any parameters. ...Means, I need to import them into TM1 using ETLDDAP? I...