Search found 1212 matches

by David Usherwood
Mon Dec 11, 2017 4:45 pm
Forum: Cognos TM1
Topic: PAW questions
Replies: 5
Views: 258

Re: PAW questions

The current version is supported under Docker for Windows (Server 2016) but I have not heard positive reports about it so you are better off installing on Linux (IBM push Red Hat but Ubuntu is fine) I have now heard from the InfoCat team that the latest release of PAW for Windows is stable and reco...
by David Usherwood
Mon Dec 11, 2017 12:00 pm
Forum: Cognos TM1
Topic: PAW questions
Replies: 5
Views: 258

Re: PAW questions

PAW is a separate SKU. Also, it requires Docker to run. The current version is supported under Docker for Windows (Server 2016) but I have not heard positive reports about it so you are better off installing on Linux (IBM push Red Hat but Ubuntu is fine). This can be virtualised. It is a new set of ...
by David Usherwood
Fri Dec 08, 2017 4:53 pm
Forum: Cognos TM1
Topic: .cma a .csv
Replies: 2
Views: 121

Re: .cma a .csv

There isn't any. (Well, only the extension 8-) )
For strange historical reasons TM1 exports files as CMA. You can parse them into Excel or just rename them to .CSV .
by David Usherwood
Thu Oct 26, 2017 12:52 pm
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 23
Views: 2151

Re: View Extract with TM1 API

I am planning to wrap rest api with JAVA and possibly publish it via github too. :D
What a good idea :)
Hubert Heijkers, who 'owns' the REST API, has some routines for Google's Go language, but when I last looked they weren't as comprehensive as TM1PY:
https://github.com/Hubert-Heijkers
by David Usherwood
Wed Oct 25, 2017 8:39 am
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 23
Views: 2151

Re: View Extract with TM1 API

Re: View Extract with TM1 API by macsir » Tue Oct 24, 2017 11:38 pm David Usherwood wrote: ↑ Tue Oct 24, 2017 3:13 pm Re: View Extract with TM1 API Yes, that's good idea but basically TM1py is still built on rest api. If you are experienced with programming and want to learn things, better to start...
by David Usherwood
Tue Oct 24, 2017 3:13 pm
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 23
Views: 2151

Re: View Extract with TM1 API

Re: View Extract with TM1 API Unread post by macsir » Tue Oct 24, 2017 4:47 am I would recommend to achieve this via REST API which is the future. I'd second this. As an example, using Marius Wirtz' TM1PY libraries: """ Create MDX View on }ClientGroups cube and query data through it. IMPORTANT: MDX...
by David Usherwood
Wed Oct 11, 2017 2:32 pm
Forum: Cognos TM1
Topic: is python is used in Planning analytics
Replies: 6
Views: 917

Re: is python is used in Planning analytics

I have been working with Marius and with Jason Kapp to adjust TM1PY to work with TM1 SaaS. Marius has released a new version which should handle this but I have not yet tested it myself. I suggest you download it and try, and let him know at https://github.com/cubewise-code/TM1py how you get on - we...
by David Usherwood
Fri Sep 15, 2017 10:40 am
Forum: Cognos TM1
Topic: Create hierarchy by attributes in PA
Replies: 3
Views: 231

Re: Create hierarchy by attributes in PA

I'm not convinced you will be able to see the hierarchy in TM1 Web, pretty sure it is only available in PAW and PAX. The "old" clients won't be able to see them, I'm slightly hesitant as I know they refreshed TM1 Web a little in the last release and I have not directly checked. Just checked on PA 2...
by David Usherwood
Tue Sep 12, 2017 1:03 pm
Forum: Cognos TM1
Topic: Threads on TM1RunTI
Replies: 2
Views: 193

Re: Threads on TM1RunTI

Running TM1Top plus Windows (or similar) Task Manager should tell you the answer to this - but might tell you about some locking in your TIs. Don't think using the same user is a problem though check the login count in }ClientProperties.
by David Usherwood
Thu Aug 24, 2017 5:18 pm
Forum: Cognos TM1
Topic: HierarchySize Function
Replies: 4
Views: 347

Re: HierarchySize Function

Digging in somewhat it turns out that DIMSIZ is a rules function (which can be used in TI like almost all of them) - clue is that it is short and cryptic. This can be done with Marius Wirtz' TM1py libraries: from TM1py.Services import TM1Service with TM1Service(address='', port=8045, user='', passwo...
by David Usherwood
Wed Aug 02, 2017 8:56 am
Forum: Cognos TM1
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 974

Re: Finding out which Views a Subset belongs to?

I've just done this using Marius Wirtz' TM1PY libraries for Python (https://github.com/MariusWirtz/TM1py) in 24 lines, 6 of which are near duplicates to cover private and public subsets which I should have put in a function.
by David Usherwood
Tue Jul 25, 2017 8:22 pm
Forum: Cognos TM1
Topic: Concatenated string with Expand Function
Replies: 16
Views: 1417

Re: Concatenated string with Expand Function

If you can write or specify your own SQL I find UNPIVOT (https://technet.microsoft.com/en-us/lib ... .105).aspx) to be a handy way to unpack lots of data columns into rows to save CELLPUTNs.
by David Usherwood
Fri Jul 21, 2017 1:55 pm
Forum: Cognos TM1
Topic: Securing dilemma
Replies: 4
Views: 415

Re: Securing dilemma

I've done it on the shared partner cloud so I would suggest yes.
by David Usherwood
Fri Jul 21, 2017 11:09 am
Forum: Cognos TM1
Topic: Securing dilemma
Replies: 4
Views: 415

Re: Securing dilemma

It's not that hard to write a TI which creates a group for each project manager, then assigns rights on (eg) name or attribute. Generally TM1's use of groups for security is efficient and flexible and (with the above) can cope with the use case you have.
by David Usherwood
Wed May 17, 2017 4:44 pm
Forum: Cognos TM1
Topic: External access to TM1 cube via MDX
Replies: 9
Views: 1095

Re: External access to TM1 cube via MDX

There is no IBM supplied ODBC driver for TM1 - but there are tools (for $) which effectively provide one. However, I suggested you should look at ODBC via TI. TM1 supports writing to relational databases using the keywords ODBCOPEN and ODBCOUTPUT. For the latter, despite the 'OUTPUT' term, this just...
by David Usherwood
Wed May 10, 2017 8:26 pm
Forum: Cognos TM1
Topic: External access to TM1 cube via MDX
Replies: 9
Views: 1095

Re: External access to TM1 cube via MDX

The products are to be found on the first page of the commercial forum - you should get there pretty quickly.
But from what you have since said, why don't you use ODBC via TI? You can read and write through this route.
by David Usherwood
Wed May 10, 2017 3:23 pm
Forum: Cognos TM1
Topic: External access to TM1 cube via MDX
Replies: 9
Views: 1095

Re: External access to TM1 cube via MDX

For some strange reason IBM don't spend time or effort supporting third party access to TM1 - baffling I know. You have spotted that the (new-ish) REST/ODATA API is one option, and there are a number of third party tools which I am reluctant to name in the main forum which will do this. I have exper...
by David Usherwood
Wed Apr 05, 2017 9:30 am
Forum: Cognos TM1
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 1432

Re: Wildcard Search in a Dimension

Did you try inserting some debugging code into your script? Always a good idea. Note that 10.2.2 FP7 (and PA2 = TM1 11) include a TI debugger. I've not spent a lot of time with it yet as it doesn't play well with enlarged fonts on Dell laptops, but it's got to be a major step in the right direction...
by David Usherwood
Wed Apr 05, 2017 9:21 am
Forum: Cognos TM1
Topic: Planning Analytics ( TM1 V11 ) new Service ?
Replies: 9
Views: 1100

Re: Planning Analytics ( TM1 V11 ) new Service ?

Ah... I do my best to avoid Cognos Configuration because it does hardly anything, very slowly. (Also because IBM have several versions for (eg) BI and Framework Manager and don't bother to distinguish them. :evil: ) The two services you see are (as suggested) the Application Server, and the Admin se...
by David Usherwood
Mon Apr 03, 2017 10:58 am
Forum: Cognos TM1
Topic: Planning Analytics ( TM1 V11 ) new Service ?
Replies: 9
Views: 1100

Re: Planning Analytics ( TM1 V11 ) new Service ?

Not in our Planning Analytics Local environment:
PA Services.jpg
PA Services.jpg (20.18 KiB) Viewed 898 times