TM1 Forum

Thank you dr.nybble...!
I tried the steps you mentioned, it worked.

Hi everone, I setup Planning Analytics Workspace in windows server 2016. I checked all the services are up and running. But I am getting below error when connecting to PAW from web browser. Error: planning analytics workspace is unavailable. Try again in a few minutes. Let me know if anyone has face...

Hello Everyone, I am upgrading TM1 10.2.2 to Planning Analytics 2.0. As a part of that I am converting worksheets from TM1 perspectives to PAx (Planning Analytics for Microsoft Excel). But we can use "Upgrade action buttons" utility in PAx only if the reports/worksheets are already uploade...

Hello Everybody, I am facing any issue with SUMIF function in one of my reports. The function is working properly in PAx where as it is throwing #ERR! while opening on TM1 web. I tried several posts/blogs to get the solution for this issue unfortunately I couldn't able to find the reasonable answer....

Thanks all for your valuable response!

Now I am able to achieve my requirement with TM1PRIMARYDBNAME() function.

Hi, If you are on PAL 2, you can use "TM1PRIMARYDBNAME()" worksheet function to get the instance name: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_wrk_primarydbnamefunction.html If this is for migrating purpose, another met...

Hello Everybody, I am trying to call DBRW function in excel. I know it is simple to call. But my question here his can we call DBRW function from excel without mentioning instance name in the first argument (cube argument) in the function. I want to return instance name from the cube (where the inst...