Search found 447 matches

by macsir
Tue Nov 21, 2017 1:54 am
Forum: Cognos TM1
Topic: Questions for Code editor (TI/Rule)
Replies: 6
Views: 325

Re: Questions for Code editor (TI/Rule)

Thank you, Wim. Recently I just study on how to create self-defined grammars for Atom since it has version control function. Is there a possible way to convert UDL(User Define Language) from Notepad++ to Atom's grammars and CSS coloring? :D :D :D Atom is good and I use it as my default programming ...
by macsir
Mon Nov 13, 2017 9:54 pm
Forum: Cognos TM1
Topic: after Cube optimization -> TI won't run
Replies: 7
Views: 256

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

Please upload some images to prove that. It is hard to analyse from your words.
by macsir
Mon Nov 13, 2017 3:32 am
Forum: Cognos TM1
Topic: Why is excel report name in TM1 applications showing grey?
Replies: 1
Views: 82

Re: Why is excel report name in TM1 applications showing grey?

Found the root cause. It is obsolete parameter ExcelWebPublishEnabled which is causing this.
by macsir
Fri Nov 10, 2017 5:39 am
Forum: Cognos TM1
Topic: Why is excel report name in TM1 applications showing grey?
Replies: 1
Views: 82

Why is excel report name in TM1 applications showing grey?

like this Image
All files with xlsx are showing grey. All xlsm/pdf files are showing black. The TM1 version is 10.2.2 FP4. Any idea?
by macsir
Fri Nov 03, 2017 1:32 am
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 22
Views: 1869

Re: View Extract with TM1 API

This clause is known to me. And I try to use it like this: SELECT { TM1SUBSETALL([}Clients]) } ON COLUMNS, { TM1SUBSETALL([}Groups]) } ON ROWS FROM [}ClientGroups] where ([}Clients].[Admin], [}Groups].[ADMIN]) However when I use: TM1V hExtractList = TM1ViewExtractCreate(hPool, hObject) and hExtract...
by macsir
Thu Nov 02, 2017 4:44 am
Forum: Cognos TM1
Topic: MDX Subsets & BI
Replies: 2
Views: 130

Re: MDX Subsets & BI

What do you mean BI? Is it cognos report/query/analysis studio?
by macsir
Thu Nov 02, 2017 4:42 am
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 22
Views: 1869

Re: View Extract with TM1 API

You need WHERE clause after FROM.
by macsir
Tue Oct 31, 2017 12:42 am
Forum: Cognos TM1
Topic: AddGroup for Active Directory Groups
Replies: 1
Views: 95

Re: AddGroup for Active Directory Groups

There is no easy way to grab CAMID unless you look at Cognos BI SDK to do it for you https://www.ibm.com/developerworks/data ... ge565.html.
If it is not massive, then manually copy them from cognos server.
by macsir
Mon Oct 30, 2017 1:26 am
Forum: Cognos TM1
Topic: When to use Security Mode 4?
Replies: 2
Views: 139

Re: When to use Security Mode 4?

Thanks, tomok. So, in Security 4, any user in TM1 native groups can't see anything even if they are granted with proper rights on some tm1 objects. But in 5, they can see objects when login if they are with proper rights and even if they are only in TM1 native groups. Am I right?
by macsir
Sun Oct 29, 2017 12:44 pm
Forum: Cognos TM1
Topic: When to use Security Mode 4?
Replies: 2
Views: 139

When to use Security Mode 4?

Any specific scenario?
by macsir
Fri Oct 27, 2017 10:19 am
Forum: Cognos TM1
Topic: TM1 upgrade to Planning Analytics
Replies: 3
Views: 175

Re: TM1 upgrade to Planning Analytics

I don't think it is a problem. Most of your current sheets would be fine.
The most advantage is planning analytics workspace, which is accessible via web browser as well. You should install and use that definitely.
by macsir
Fri Oct 27, 2017 1:49 am
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 22
Views: 1869

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 Thanks, Dav...
by macsir
Thu Oct 26, 2017 9:41 am
Forum: Cognos TM1
Topic: tm1runti on Planning Analytics
Replies: 1
Views: 113

Re: tm1runti on Planning Analytics

Basically, clients in each major version change won't be compatible. You can have tm1runti from version 11 to let it work.
by macsir
Thu Oct 26, 2017 12:45 am
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 22
Views: 1869

Re: View Extract with TM1 API

I am planning to wrap rest api with JAVA and possibly publish it via github too. :D
by macsir
Wed Oct 25, 2017 4:51 am
Forum: Cognos TM1
Topic: Chore Details
Replies: 7
Views: 241

Re: Chore Details

What I have done in the past is using Perl to extract chore details info from chore files into a summary file. Since Perl is good at regular expression, it is kind of easy to program based on that and in that way, it is not depending on any TM1 version.
by macsir
Tue Oct 24, 2017 11:44 pm
Forum: Cognos TM1
Topic: ExecuteCommand Copy file
Replies: 10
Views: 282

Re: ExecuteCommand Copy file

of course, mine is printable keyboard dash, just let you know. :lol:
by macsir
Tue Oct 24, 2017 11:38 pm
Forum: Cognos TM1
Topic: View Extract with TM1 API
Replies: 22
Views: 1869

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 macsir
Tue Oct 24, 2017 5:02 am
Forum: Cognos TM1
Topic: ExecuteCommand Copy file
Replies: 10
Views: 282

Re: ExecuteCommand Copy file

Are you merging multiple files into one? I tried file names with both characters ( - and ^) , they are all fine.
by macsir
Tue Oct 24, 2017 4:53 am
Forum: Cognos TM1
Topic: TM1 instances are running in cognos configuration but not appearing in TM1 architect.
Replies: 3
Views: 192

Re: TM1 instances are running in cognos configuration but not appearing in TM1 architect.

also check your admin host address is right or not or ports are open on the server or the server has multiple IP addresses or not.
by macsir
Tue Oct 24, 2017 4:51 am
Forum: Cognos TM1
Topic: MDX expession
Replies: 3
Views: 222

Re: MDX expession

{TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 406],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 407]}, ALL, RECURSIVE )}, 3)} + {TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 409]}, ALL, RECURSIVE )}, 4)}