TM1 Forum

Do you have a backup that was taken before the server migration you could test? This line: The TM1 service may not have been shut down completely prior to copying the model really sounds like it could be the cause. If you don't have a backup to test with, then calling IBM may be your best bet (unles...

Not entirely sure, but sounds like this *could be* related:

https://www-01.ibm.com/support/docview. ... wg21654717

What if you create a new process while the server is running? Right click the "Processes" node and create a new one with a random name. Is that process visible? I'm out of ideas at this point, so just trying to isolate what works and what doesn't.

Are you admin on the dev server? If not, login with an admin account and update your }ProcessSecurity cube to provide READ access to the new processes.

You will probably need to kill the process on the SAP side. In my experience, 9 times out of 10 this is a hang up on the SAP side (especially with HANA... ).

I really think you may want to involve an "IT person" in this particular case. Can you clarify what exactly you are trying to accomplish? You mentioned hosting Perspectives on a shared drive, which you definitely should not do. Perspectives creates configuration files per user... If you wa...

My preferred way of working around this during the development phase is the following: Write your SQL query outside of the ODBC connection (i.e. SQL Developer for Oracle, pgAdmin III for PostgreSQL, etc.) When you're positive the data coming out of your DB is correct, export it from the database to ...

Try to ensure that the tm1p.ini file (their personal configuration file for the tm1p.xla) is not getting wiped. This sounds like a fairly common issue with the Citrix profiles being "reset". You can confirm that this is happening by comparing the contents of the tm1p.ini before and after t...

Hi Ashleigh, Try this one out: Sub open_files() Dim path As String Dim file As String path = "\\(your_server)\(admin_host_name)\(path_to)\}Externals\" file = Dir(path & "\*.xlsx") Do While file <> "" Workbooks.Open Filename:=path & "\" & file ' Add...

I'm sorry, but I'm really having a hard time understanding what you're trying to accomplish here. Firstly, (as per Jim's comment) you should have your "CurrentDate" attribute created as an alias, in your screenshot you have it listed as "Text". My second question would be regardi...

A few things to watch out for from my experience: Do you have different versions of Perspectives that will be used? If so, SupportPreTLSv12Clients=T If you have VBA worksheets and want to use them in PAW, be prepared to gut them and start over with the logic Docker is nothing to be afraid of, but if...

'excel crashes here... what name / string do i pass here for strBlobName You pass in the blob file name (i.e. Test/Budget_Sampe.blob) to your excel report. As Paul stated above, you can get these names from the }ApplicationEntries dimension. If you want to work off of the }Externals folder, pass in...

I have also noticed this same issue in Excel only. Another option (dare I say :shock: ) is to use the E_PICK macro. This would ultimately make it incompatible with web, more of a pain to update, and obfuscated for no real benefit, BUT it will work. :D Just don't blame it on me if you decide to go th...

In regards to the question: Please i request your help in starting with the change in Rules, i do not know how and where to begin. Start here: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rul.2.0.0.doc/c_componentsofacalculationstatement_n91157.html#Component...

I agree with Mark for the most part with one small exception: the Measures dimension SHOULD be renamed. The only time I could ever see reusing a measures dimension from another cube is if the cube is strictly for testing (and even then I never like that approach i.e. test becomes permanent ;) ). Bes...

Hi Wim, Unfortunately my PS version is too outdated to run any fancy Rest calls :( , but from what I can tell your output looks like a typical return except for the fact that it is getting truncated for some reason. I'm not sure if this is an issue with writing to a .txt, but could you maybe pass it...

Hi Mayank, By default, the tm1server.log file shows only the user ID (AFAIK there is not a way to make it show anything else). There is a file called tm1s-log.properties that configures the logging details for the TM1 server. You can set the level of detail and include different properties to log to...

This goes for most languages (mostly c based, but will apply here as well), try to avoid extra conditionals when possible. Depending on the case, this is sometimes unavoidable, but in your situation the extra calls in option 2 would be considered more "expensive" than the first (i.e. more ...

Both ELLEV and ISLEAF will work. The key is how you structure the left side of your rule. Use the open brackets ( [] ) to test every cell.

If the question is "has anyone configured PAX to use https", I can assure you the answer is yes. ;) If there is something you're having difficulty with and would like help, you would need to provide some more details about what you have tried, current environment, etc., as per Steve's comm...