All,
Work-around/Solution:
I moved this report to different book and copied back to existing book with different name.
** I am still interested to know how indexing plays. What was error about?
Thank You
Dharav
Search found 72 matches
- Wed Oct 05, 2022 5:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Quick Report - Refresh Sheet throws error
- Replies: 2
- Views: 574
- Wed Oct 05, 2022 5:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Quick Report - Refresh Sheet throws error
- Replies: 2
- Views: 574
Quick Report - Refresh Sheet throws error
Hi, All
I am getting following error while refreshing sheet. Except this report, I am able to refresh all other reports on the same workbook but on different worksheet.
Error:
Thank You for your Input.
Dharav
I am getting following error while refreshing sheet. Except this report, I am able to refresh all other reports on the same workbook but on different worksheet.
Error:
Anyone experienced this before? How could I resolve it?
Thank You for your Input.
Dharav
- Wed Feb 09, 2022 11:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Filter by Cube Value
- Replies: 4
- Views: 2981
Re: MDX Filter by Cube Value
@wim@declanr:
It is resolved.
@declanr: 100 % on Target. I applied all other dimensionality in filter except Employee dimension and it worked. It seems it takes some elements randomly if we have not spacified.
Thank You Fellas,
Dharav
It is resolved.
@declanr: 100 % on Target. I applied all other dimensionality in filter except Employee dimension and it worked. It seems it takes some elements randomly if we have not spacified.
Thank You Fellas,
Dharav
- Wed Feb 09, 2022 10:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Filter by Cube Value
- Replies: 4
- Views: 2981
MDX Filter by Cube Value
Hi, I have placed this statement in subset editor expression window. It saves but did not bring any values. It should bring two elements from Employee dimension based on FTE value in the cube. Where Measures_Plan_Employee dimension have both string and numeric elements in the dimension but FTE is nu...
- Sun Oct 31, 2021 7:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 MDX did not work in TI
- Replies: 6
- Views: 6200
Re: TM1 MDX did not work in TI
I think Mark RMBC correctly identified the issue. TM1FilterByPattern acts on the alias assigned to the subset. So if the wildcard searc on "*Hargrove,Chr*" relies on an alias then that is the reason. For something that will ALWAYS work then you need to get the attribute value with Current...
- Thu Oct 28, 2021 4:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 MDX did not work in TI
- Replies: 6
- Views: 6200
TM1 MDX did not work in TI
Hi, All Can someone assist with following MDX to work in TI process? sMDX = '{TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SubsetToSet([Employee], "Dyna_Existing")}, 0)}, "*Hargrove,Chr*")}'; I placed this MDX inside the subset editor expression window and it worked. Same MDX is no...
- Mon Oct 04, 2021 4:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Element Security
- Replies: 9
- Views: 6813
Re: TM1 Element Security
@Elessar@lotsaram:
You guys nailed it. It was turn on in the CFG file.
Thank You Guys
Dharav
You guys nailed it. It was turn on in the CFG file.
Thank You Guys
Dharav
- Sun Oct 03, 2021 2:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Element Security
- Replies: 9
- Views: 6813
Re: TM1 Element Security
@Wim@marenC@steve: 1) Dimension security is good that’s why user is able to see dimension 2) User checked in PAX & PAW. I also check with impersonate feature in Arc for different users 3) We have this dimension in place since 4 years. *** I create a rule on Admin DBA and feed Admin DBA rule. I p...
- Thu Sep 30, 2021 4:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Element Security
- Replies: 9
- Views: 6813
TM1 Element Security
Hello Everyone I updated a security for the version dimension and Element security cube for version dimension created. I applied rule for element security cube for version dimension. I opened the cube and see the security values applied correctly for each groups. I did security refresh. However, Non...
- Mon Feb 01, 2021 5:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Login Error: SystemServerConnectionWithCAMPassport failed
- Replies: 2
- Views: 1840
Re: Login Error: SystemServerConnectionWithCAMPassport failed
Hello, TM1.Login Login Error: SystemServerConnectionWithCAMPassport failed Recently I started seeing this message in TM1 Server log. It looks this error happens intermittently. Any ideas why this might be happening? Regards, Ask user to re-set the password and re-login to system. User must have rec...
- Wed Jan 27, 2021 6:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Syntax in PAW.ps1 to enable View Integration In PAX
- Replies: 2
- Views: 1647
Syntax in PAW.ps1 to enable View Integration In PAX
Hi, All Environment: PAW:2.0.59 pa local: 2.0.9.3 I want to enable View feature (see attached) in PAX for users to exchange PAW content space view from PAX. I follow ibm document and it describes to place Enable_View_Exchange parameter and set it to ture in PAW.ps1 file. I place following code in PA...
- Thu Dec 10, 2020 10:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Upgrade Admin Tool / Docker Error
- Replies: 0
- Views: 4936
PAW Upgrade Admin Tool / Docker Error
Hi, All While upgrading PAW 2.0.59, i found attached error on windows 2016 server. When i clean up using " .\WindowsContainerNetworking-LoggingAndCleanupAide.ps1 -Cleanup -ForceDeleteAllSwitches" then run docker surprise function to check docker health then it work. I was able to create se...
- Thu Oct 08, 2020 2:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Batch file with gpg4win is not executing from TI process
- Replies: 6
- Views: 3070
Re: Batch file with gpg4win is not executing from TI process
Guys, I figured it out. GPG4win installs private key in to their personal app data folder.[ C:/Users/Name/AppData/Roaming/gnupg/] If you copy this folder and assign in the different folder outside users folder and mentioned that path in to your batch then it works. Alternative is that you should ins...
- Wed Oct 07, 2020 7:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Batch file with gpg4win is not executing from TI process
- Replies: 6
- Views: 3070
Re: Batch file with gpg4win is not executing from TI process
Hello All, @tomok & @gtonkin Could be that gpg is not in your path for the TM1 service account. Try putting the full path to it in your batch file. I have added the path in system environment variable. Moreover, following is the code inside the batch file. E: cd "E:\Software\PGPWin\GnuPG\bi...
- Fri Oct 02, 2020 7:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Batch file with gpg4win is not executing from TI process
- Replies: 6
- Views: 3070
Re: Batch file with gpg4win is not executing from TI process
Hi, Tomok Thanks for prompt reply. All other batch files are working fine from TI. As GPG4WIN is third party exe program in command line in the batch file, something is related to it. I ran same batch file from Task Scheduler and it woks. Can you assist me what or where i should start looking for pe...
- Thu Oct 01, 2020 7:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Batch file with gpg4win is not executing from TI process
- Replies: 6
- Views: 3070
Batch file with gpg4win is not executing from TI process
Hi, All I have a command line code in batch file which decrypts encrypted file. We have many batch files which are being executed monthly from TI process. No issues at all. "Test.Bat" => I am able to execute it by double clicking and it works fine. When i run this process from TI process t...
- Fri Aug 28, 2020 6:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Icons under Planning Analytics ribbon (excel-addin) is grayed out
- Replies: 4
- Views: 2369
Re: Icons under Planning Analytics ribbon (excel-addin) is grayed out
I just got back to my computer. I can recreate what your screenshot shows. I tried this. What is strange => When i add elements from left pane to right, it got added. I click ok. Now i went to Planning Analytics ribbon but it did not change anything. I open customize ribbon to make sure all element...
- Thu Aug 27, 2020 5:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Icons under Planning Analytics ribbon (excel-addin) is grayed out
- Replies: 4
- Views: 2369
Icons under Planning Analytics ribbon (excel-addin) is grayed out
Hi, All I found strange behavior on one of our user machine. Icons under Planning Analytics ribbon are grayed out. Excel Error.PNG This user was able to use PAX till Monday. We did following to debug: 1) She has already set up compatibility settings in Excel 2) we tried to uninstall and install PAX ...
- Fri May 15, 2020 1:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 MDX
- Replies: 1
- Views: 1698
TM1 MDX
Hi, All We have a lookup cube where Fcst Value = FY2021 has mentioned. We have a dynamic subset called FcstYr which retrieves the vaelue based on lookup cube; MDX of this subset is: { FILTER( TM1SUBSETALL( [Time]), [Time].CurrentMember.Name = [Globals].([Globals].[Fcst Year], [Value_Msr].[ValueS]) )...
- Wed May 06, 2020 3:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to access control objects tree
- Replies: 1
- Views: 1826
Unable to access control objects tree
Hi, All In PAW, I can access control objects in the PAW but other user having same access as me (admin in PAW and admin in model), couldn't able to access it. When he expand the control objects tree then receives following error. Control Object Error.PNG Did anyone find the similar issue? Do we need...