TM1 Forum

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...

Thank you very much! This one helped me out

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...

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...

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 ...

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...

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...

Thanks for your suggestions.

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

Like Wim Gielis suggested!

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

Thanks

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...

Thanks for the information!

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!

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...

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!

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 ...