Search found 15 matches

by Ptec
Fri Apr 21, 2017 7:42 am
Forum: Cognos TM1
Topic: TM1 WEB URL API - How to show navigation tree and banner with Logout?
Replies: 0
Views: 255

TM1 WEB URL API - How to show navigation tree and banner with Logout?

Hey there! Im currently struggling with the problem, that when a user uses a TM1 Web URL to a specific websheet, he can't see the navigation tree and "banner header" . Therefore we would need to set a Hyperlink for Logout on every Websheet so the user has easy access to Logout from everywhere. Secon...
by Ptec
Wed Oct 05, 2016 1:08 pm
Forum: Useful code, tips and tricks
Topic: Count dimensions in a cube via TIA
Replies: 2
Views: 2618

Re: Count dimensions in a cube via TIA

Thank you very much! This one helped me out ;)
by Ptec
Tue Sep 27, 2016 10:25 am
Forum: Cognos TM1
Topic: MDX: Filter Parents but sort their Children
Replies: 3
Views: 330

Re: MDX: Filter Parents but sort their Children

Does it make a difference because how could I sort the children? The "ORDER" MDX Command just uses the "Filtered" Elements which are the parents, so the Ordering takes no effect on the children... I tought of using a Subset Drilled down all Elements so I get the correct Attribute Order. That works a...
by Ptec
Tue Sep 27, 2016 9:11 am
Forum: Cognos TM1
Topic: MDX: Filter Parents but sort their Children
Replies: 3
Views: 330

MDX: Filter Parents but sort their Children

Hey there, I have a "Problem" Im working on for 2 days now but couldn't find a solution till now. I have a Dimension with a Top Node, 2 Parent Elements with several Childs. All Elements have a numeric Attribute like 10,11,13... We now need the Children to be sorted ascending to their Attributes BUT ...
by Ptec
Mon Jul 11, 2016 9:47 am
Forum: Cognos TM1
Topic: Pushing Data from Cube View to ODBC SQL - with custom SQL Statement (Convert,Cast?)
Replies: 2
Views: 353

Re: Pushing Data from Cube View to ODBC SQL - with custom SQL Statement (Convert,Cast?)

Ive found the solution! For putting the datetime format into an SQL Table it has to be exact: "YYYY-MM-DD hh:mm:ss“ so as string: „2016-07-11 14:30:23“ So far i changed my timestamp to: vNow=NOW(); vTimeStamp=TimSt (vNow, '\Y-\m-\d \h:\i:\s\'); I changed my "Insert" script on the End to: '''|vTimeSt...
by Ptec
Mon Jul 11, 2016 7:10 am
Forum: Cognos TM1
Topic: Pushing Data from Cube View to ODBC SQL - with custom SQL Statement (Convert,Cast?)
Replies: 2
Views: 353

Pushing Data from Cube View to ODBC SQL - with custom SQL Statement (Convert,Cast?)

Hey there, I'm struggling with following TI Process: We want to push data from an cube view to an SQL Table - everything works fine except the "Timestamp" from Tm1 to SQL datetime field. Code - Im generating an Timestamp (String): vNow=NOW(); vTimeStamp=TimSt (vNow, '\Y\m\d\h\i\s\'); So as far is I ...
by Ptec
Thu Jul 07, 2016 7:51 am
Forum: Cognos TM1
Topic: TM1 and email (using SQL server)
Replies: 3
Views: 1409

Re: TM1 and email (using SQL server)

First post, hopefully useful to some of you. 2. The TI process inserts a "getdate()" value into a specifically created table (with one column for datetime). Hey mike, that point is very interesting for me! Im currently struggling with passing a generated Timestamp : vNow=NOW(); vTimeStamp=TimSt (vN...
by Ptec
Tue Jul 05, 2016 6:37 am
Forum: Cognos TM1
Topic: ProcessError - How to output custom Error in the Logfile?
Replies: 7
Views: 832

Re: ProcessError - How to output custom Error in the Logfile?

Thanks for your suggestions.

I think ASCII Output is the only way to do this at the moment.

Like Wim Gielis suggested!
by Ptec
Wed Jun 29, 2016 11:17 am
Forum: Cognos TM1
Topic: ProcessError - How to output custom Error in the Logfile?
Replies: 7
Views: 832

Re: ProcessError - How to output custom Error in the Logfile?

Ok, so you suggest to overwrite the log with ASCIIOutput?

Thanks
by Ptec
Wed Jun 29, 2016 8:37 am
Forum: Cognos TM1
Topic: ProcessError - How to output custom Error in the Logfile?
Replies: 7
Views: 832

ProcessError - How to output custom Error in the Logfile?

Hey there! I've (maybe) a simple question. We have several TI Processes with " Processerror ;" in IF Statements. We now need , that if ProcessError is executed, a custom String Text will be written to the "TM1ProcessError_Timestamp_Processname.log" is written, which are automatically generated in th...
by Ptec
Tue Jun 21, 2016 1:46 pm
Forum: Cognos TM1
Topic: Drop Down Calendar Selection
Replies: 16
Views: 4878

Re: Drop Down Calendar Selection

Thanks for the information!
by Ptec
Mon Jun 20, 2016 11:31 am
Forum: Cognos TM1
Topic: Drop Down Calendar Selection
Replies: 16
Views: 4878

Re: Drop Down Calendar Selection

Hey ,

Our customer has the same Request! He wants a calendar (month view) like in the Cube Viewer but in an web application or in TM1 Web.

Sorry that i haven't any good web dev skills but any hints how I can archive this would be very helpful!

Thanks!
by Ptec
Wed May 25, 2016 1:53 pm
Forum: Cognos TM1
Topic: Using "Level" Attribute from Performance Modeller in a TI Script
Replies: 5
Views: 470

Re: Using "Level" Attribute from Performance Modeller in a TI Script

I've found a solution . I'm counting the Elpar's of an Element in a while loop. Also I set a counter for the amount of Parents of an Element - this counter represents the "Level Name" in PM. So I can set the counter Number as Attribute for the requested Attribute "LevZahl". At the End of the put ATT...
by Ptec
Wed May 25, 2016 1:36 pm
Forum: Cognos TM1
Topic: Using "Level" Attribute from Performance Modeller in a TI Script
Replies: 5
Views: 470

Re: Using "Level" Attribute from Performance Modeller in a TI Script

So far so good but my customer needs the "Level" Strings as own Attribute in the Dimension.

He wants to use the String "Ebene x" as separate Number in an Attribute (see "LevZahl").

I've attached it visually for better understanding...

Thanks!
by Ptec
Wed May 25, 2016 10:32 am
Forum: Cognos TM1
Topic: Using "Level" Attribute from Performance Modeller in a TI Script
Replies: 5
Views: 470

Using "Level" Attribute from Performance Modeller in a TI Script

Hey there, I have a request with i cant find information about: In a Dimension in Performance Modeller (10.2.2.0) i want to use the "Level" Attribute in a TI Process. I know that with ELLEV i can use the Level from an Element but with ELLEV I get the Level from Architect with is different to the one...