Search found 7 matches

by hemheman
Mon Sep 10, 2018 1:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: planning analytics workspace is unavailable
Replies: 2
Views: 995

Re: planning analytics workspace is unavailable

Thank you dr.nybble...!
I tried the steps you mentioned, it worked.
by hemheman
Wed Sep 05, 2018 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: planning analytics workspace is unavailable
Replies: 2
Views: 995

planning analytics workspace is unavailable

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...
by hemheman
Wed Aug 08, 2018 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade action buttons
Replies: 2
Views: 508

Upgrade action buttons

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 uploaded to TM1 s...
by hemheman
Tue Jul 24, 2018 10:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SUMIF results in #ERR! on TM1 web
Replies: 1
Views: 340

SUMIF results in #ERR! on TM1 web

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....
by hemheman
Tue Jul 24, 2018 10:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 6
Views: 616

Re: Calling DBRW function without mentioning instance name in the first argument

Thanks all for your valuable response!

Now I am able to achieve my requirement with TM1PRIMARYDBNAME() function.
by hemheman
Tue Jul 24, 2018 10:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 6
Views: 616

Re: Calling DBRW function without mentioning instance name in the first argument

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 method is dis...
by hemheman
Fri Jul 20, 2018 12:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 6
Views: 616

Calling DBRW function without mentioning instance name in the first argument

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