TM1 Forum

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

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:

IBM PAX Error.PNG (6.48 KiB) Viewed 569 times

Anyone experienced this before? How could I resolve it?

Thank You for your Input.
Dharav

@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

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

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

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

@Elessar@lotsaram:

You guys nailed it. It was turn on in the CFG file.

Thank You Guys
Dharav

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

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

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

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

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

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

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

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

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

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

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

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

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