Search found 15 matches
- Fri Apr 21, 2017 7:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 WEB URL API - How to show navigation tree and banner with Logout?
- Replies: 0
- Views: 1733
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 everywh...
- Wed Oct 05, 2016 1:08 pm
- Forum: Useful code, tips and tricks
- Topic: Count dimensions in a cube via TIA
- Replies: 2
- Views: 8378
Re: Count dimensions in a cube via TIA
Thank you very much! This one helped me out
- Tue Sep 27, 2016 10:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX: Filter Parents but sort their Children
- Replies: 3
- Views: 3781
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...
- Tue Sep 27, 2016 9:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX: Filter Parents but sort their Children
- Replies: 3
- Views: 3781
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 Attri...
- Mon Jul 11, 2016 9:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pushing Data from Cube View to ODBC SQL - with custom SQL Statement (Convert,Cast?)
- Replies: 2
- Views: 2348
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 ...
- Mon Jul 11, 2016 7:10 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Pushing Data from Cube View to ODBC SQL - with custom SQL Statement (Convert,Cast?)
- Replies: 2
- Views: 2348
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...
- Thu Jul 07, 2016 7:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 and email (using SQL server)
- Replies: 3
- Views: 3603
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...
- Tue Jul 05, 2016 6:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ProcessError - How to output custom Error in the Logfile?
- Replies: 7
- Views: 7718
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!
I think ASCII Output is the only way to do this at the moment.
Like Wim Gielis suggested!
- Wed Jun 29, 2016 11:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ProcessError - How to output custom Error in the Logfile?
- Replies: 7
- Views: 7718
Re: ProcessError - How to output custom Error in the Logfile?
Ok, so you suggest to overwrite the log with ASCIIOutput?
Thanks
Thanks
- Wed Jun 29, 2016 8:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ProcessError - How to output custom Error in the Logfile?
- Replies: 7
- Views: 7718
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 automatic...
- Tue Jun 21, 2016 1:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drop Down Calendar Selection
- Replies: 21
- Views: 18543
Re: Drop Down Calendar Selection
Thanks for the information!
- Mon Jun 20, 2016 11:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drop Down Calendar Selection
- Replies: 21
- Views: 18543
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!
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!
- Wed May 25, 2016 1:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using "Level" Attribute from Performance Modeller in a TI Script
- Replies: 5
- Views: 3762
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 th...
- Wed May 25, 2016 1:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using "Level" Attribute from Performance Modeller in a TI Script
- Replies: 5
- Views: 3762
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!
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!
- Wed May 25, 2016 10:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using "Level" Attribute from Performance Modeller in a TI Script
- Replies: 5
- Views: 3762
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 ...