Search found 513 matches

by gtonkin
Mon Dec 11, 2017 7:00 pm
Forum: Cognos TM1
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 548

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

"worksheet scoped named ranges" relate to named ranges that are valid only on the sheet you define them. For example, If you have a workbook with multiple sheets and each of them had a Business Date cell for example, you could reference that cell using the cell reference e.g. $B$6 or alternatively, ...
by gtonkin
Fri Dec 08, 2017 7:36 am
Forum: Cognos TM1
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 548

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

I would recommend using worksheet scoped named ranges for the process and parameters references. This way, column and rows changes do not affect the Action button. I have also found that between office versions, the Action Button properties seem to change/break, especially the server reference - dou...
by gtonkin
Wed Dec 06, 2017 10:31 am
Forum: Cognos TM1
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 146

Re: MDX to Filter on Numeric Attribute

Steve Rowe wrote:
Wed Dec 06, 2017 10:24 am
...Personally I rarely use them since they behave like strings and I can't write rules versus them...
Thanks Steve, agree on the strings and the usage of another cube as you can secure better as well as use picklists to populate the text "attribute".
by gtonkin
Wed Dec 06, 2017 9:56 am
Forum: Cognos TM1
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 146

Re: MDX to Filter on Numeric Attribute

Thanks for the response and info Lotsa - will be using option 3 for the foreseeable future as many clients are still on 10.2.2 FP4.
by gtonkin
Wed Dec 06, 2017 6:15 am
Forum: Cognos TM1
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 146

Re: MDX to Filter on Numeric Attribute

Hi TM123, it does indeed give me the results-too long looking at a problem from one angle. Thanks for the assistance!
FYI - my initial MDX seems to work fine on PAX 2.0.1 - something must have been fixed.

Still curious though about the answers to some of the other questions posed in my initial post.
by gtonkin
Tue Dec 05, 2017 6:00 pm
Forum: Cognos TM1
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 146

MDX to Filter on Numeric Attribute

I am trying to find a better way to filter on a Numeric Attribute (contains 0/1) where the name of the Attribute also happens to be the name of one of the Members. Using the standard syntax to filter on an attribute returns the context error as the MDX is ambiguous. Using the following code does not...
by gtonkin
Fri Dec 01, 2017 5:18 am
Forum: Cognos TM1
Topic: unwinding certain elements issue
Replies: 9
Views: 368

Re: unwinding certain elements issue

Will refer you to the search function as this has been covered many times over the years - your basic problem is that you are creating fragments by unwinding from the top down-you need to work backwards through the dimension/hierarchy in most cases. Edit: Could you not use MDX to create a subset wit...
by gtonkin
Tue Nov 28, 2017 6:24 pm
Forum: Cognos TM1
Topic: Active Form formatting calculated rules
Replies: 3
Views: 172

Re: Active Form formatting calculated rules

I have previously added attributes to the dimension used in column B and read these in to column A to drive the formatting-depends on your needs but may work. You could obviously create composite values and format accordingly.
by gtonkin
Sat Nov 25, 2017 5:29 pm
Forum: Cognos TM1
Topic: MDX Help needed: rollup recursively from element to root level?
Replies: 2
Views: 286

Re: MDX Help needed: rollup recursively from element to root level?

Try something like this:

Code: Select all

HIERARCHIZE({Ascendants([<dim>].[<element>])})
If the elements exists in multiple hierarchies, only the first is returned.
by gtonkin
Tue Nov 14, 2017 4:48 pm
Forum: Cognos TM1
Topic: after Cube optimization -> TI won't run
Replies: 7
Views: 342

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

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

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

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

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

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

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

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

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

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

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.