TM1 Forum

Hi jrizk, thank you for your approach. :) I somehow solved it myself with the following MDX-Expression. Regards UNION( {[<Dimension>].[total]}, { ORDER( { {TM1DRILLDOWNMEMBER( {TM1SubsetBasis()}, ALL, RECURSIVE )} } , MemberToStr([<Dimension>].CurrentMember), ASC)} )

Sorry to open this old Thread,

the mdx-expression is working, but somehow it sorts the elemnts from this:

total
-c
--ad
--cf
--bd
-a
--ed
--af

to this

a
-af
-ed
c
-ad
-bd
-cf
total

Any ideas? :/

Hello everybody, we're currently testing TM1 10.2. Every client using the contributor isnt working. Here is the error log of the following url. http://server:9510/tm1web/Contributor.jsp type Exception report message description The server encountered an internal error () that prevented it from fulfi...

Hi Tomok, thank you for your answer. :) We also thought of that! But the request time would take to long. In the meantime we inspected the new TM1 10.2 Application Web Interface. The data is called by these two requests: https://www.dropbox.com/s/zymse7r6f07lmcy/Screenshot%202013-11-11%2018.54.34.pn...

Hello everybody, we're testing TM1 10.2 to create custom dashboards together with a web-developer. (10.2 is not a must for us.) Ist it somehow possible to get views as raw-csv files from the TM1 Application Web-Api? We found the following link, but we couldnt find an equivalent for 10.2. http://goo....

Thanks for your answers. :idea: @David Usherwood: Thats exactly what i want to do. Create a report as admin in insight and publish it with insight. Afterwards the report on the ipad should access ~real-time Data from the TM1-Server. (The Data is updated daily. ~3am) Another question: Im very new to ...

Hello everybody, since you helped me out to get my server running, i hope you can help me out one more time. :) We want to use Insight to build Reports. But the Insight Client is barely usable. Symptoms: First connection after insight startup takes very long (~3min.) Importing a cube to the workshee...

Thank you for your quick support.

I just had to check the box "Daten".

Thank you very much and Greetings from Germany!

Hello guys, something is wrong with my code: Sparte_PK='FALSCH'; pos=SCAN('HUS', Team); if(pos>0); Sparte_PK='HUS'; EndIf; When i import my csv file via turbo integrator, the element "FALSCH" is the only one what gets filled with data. Although the example value displays "HUS": h...

I set SSL to false in the Tm1s.cfg for the server. (See my first post.) I dont have a SSL cerrificate yet. The whole certificate thing is new to me and i couldnt found a any hints in the guides provided by IBM. Do i have to generate a specific certificate and pass it to the client, so that architekt...

Hi Jim, thank you. Yes, i'm able to log in to the test server with the architect on the remote server. (see screenshot) Might the deletion of the security control objects help though? Do i have to get some certificates from the server? I attached my IBM Cognos Configuration File. Maybe theres someth...

Hello, i set up a tm1 Server. The IP is: 192.168.0.111 in the local network. The Server is running Windows Server 2008 R2 64bit All TM1 ports are opened. The executables are allowed to use the network. When i set up my Architect to the IP 192.168.0.111, the server is showing. But after the double cl...

Thanks again for your answers. :) I will definitely have a deeper look in the Guides provided by IBM. I got it by editing the elements of the Dimension "Standort". Some Elements are consolidated under "Gesamt>Berlin" and again under "Laufend" I'm not sure, if its good t...

Hi Tomok, thanks for your reply. :) TX_TF_RSM_Standort is not a Dimension of the cube i want to fill with data. (I think that is the reason your snippet triggers an error. Syntax-Error) What do you mean with "don't forget you'll need to feed Output lfd. Geschäft."? This works fine: ['Input...

Hello everyone, im new to TM1, but i have experience in web-development coding. I've got a short question, which bothers me for quiet a few hours. :( I want to get the values cumulated for all elements with the Attribute "Laufend". ['Output lfd. Geschäft'] = N:DB('TX_TF_RSM_OI','Output',!T...