Search found 60 matches

by dharav9
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: 333

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...
by dharav9
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: 333

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\bin\" gpg -...
by dharav9
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: 333

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...
by dharav9
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: 333

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 through fol...
by dharav9
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: 320

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...
by dharav9
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: 320

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 ...
by dharav9
Fri May 15, 2020 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX
Replies: 1
Views: 721

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]) )...
by dharav9
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: 298

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...
by dharav9
Wed Feb 19, 2020 4:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 16
Views: 3054

Re: Temp View difference to Perm Views

As every the most right thing is to give the developer the tools to make the choice themselves of the scope of the object. Flag values of 0 - Permanent object 1 - Temp and local to the creating TI only. 2 - Temp and global to the entire TI chain. Hi, Steve I just want to confirm for my understandin...
by dharav9
Wed Feb 19, 2020 2:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 1868

Re: Drill Through to ORACLE ODBC

Mark RMBC wrote:
Tue Feb 18, 2020 7:43 pm
Just ruling out anything obvious, you haven't applied any case sensitivity to any of your table columns have you?

@MARK: Thank You so much. I just assigned Upper() and test it. It worked.
by dharav9
Tue Feb 18, 2020 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 1868

Re: Drill Through to ORACLE ODBC

Hi, Tomok I removed single quote purposefully to see the error. I have mentioned that in my previous post. Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = '?sTime? and LEDGER <>'CHC Consolidation Ledger' and Department = '?vDept?' and Company = '?vCo?' and Account ='?vAcct?' and Di...
by dharav9
Tue Feb 18, 2020 6:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 1868

Re: Drill Through to ORACLE ODBC

Hi, Wim Query BOX: Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = ?sTime? => I removed Single quote purposefully to see the error and LEDGER <>'CHC Consolidation Ledger' and Department = '?vDept?' and Company = '?vCo?' and Account ='?vAcct?' and Division ='?vDiv?' Prolog: sTime = ...
by dharav9
Mon Feb 17, 2020 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 1868

Re: Drill Through to ORACLE ODBC

Wim Following is the code in my Query Window: Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = concat(Concat(Concat(concat(substr('''?pTime?''',5,2),'-'),substr('''?pTime?''',1,3)),'-'),substr('''?pTime?''',9,2)) and LEDGER <>'CHC Consolidation Ledger' and Department = '?vDept?' and...
by dharav9
Mon Feb 17, 2020 10:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 1868

Re: Drill Through to ORACLE ODBC

Wim, I tried these two statements one by one but both sent me the empty records window. I tried to edit the SQL in query window of TI Process: Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name = 'FY-NOV-20' LEDGER <>'Consolidation Ledger' and Department = '?vDept?' and Company = '?vCo?...
by dharav9
Mon Feb 17, 2020 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Through to ORACLE ODBC
Replies: 11
Views: 1868

Drill Through to ORACLE ODBC

Hi, All Part 1: Work as Expected I have to create drill through to Oracle Database. I placed SQL query in query box and and set up drill rules. It works as expected. Select * from xxchc.xxgl_acc_analysis_det_tbl where Period_Name ='FY-NOV-20'; Part 2: Our Time dimension has element called "NOV FY202...
by dharav9
Thu Jan 09, 2020 6:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 2072

Re: TM1 MDX in TI Process

Hi, Mark So you have the dimensions category, company, department, division, employee and measure in your cube and your MDX refers to only the employee and measures dimension? Also your Action measure is a string. I am surprised the MDX returns the correct values under those circumstances. Yes, thos...
by dharav9
Thu Jan 09, 2020 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 2072

Re: TM1 MDX in TI Process

Hi, Steve & Reddington 1) My view contains data at leaf levels only and having non-rule derived values 2) Before i put the post, i already tried consolidation function with "0" flag (just to make sure i am not missing any basic) It seems the MDX driven subset which process the dimension elements bas...
by dharav9
Thu Jan 09, 2020 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 3
Views: 679

Re: Asciioutput Data Export is not working

Hi, Paul Am I correct in understanding that when you open the view that was created in a Perspectives Cube Viewer that you are seeing data? I created that view through TI process. View has been created with MDX statement on employee dimension. Basically, this MDX statement pulls the employee id havi...
by dharav9
Wed Jan 08, 2020 6:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asciioutput Data Export is not working
Replies: 3
Views: 679

Asciioutput Data Export is not working

Hi, All I just tried to export the data in asciioutput from the view created through SUBSET HAVING MDX BASED ON CUBE Values (sMDX - See below). I am not able to export data either manually (right click on view and export - it generates unknown error) or through TI (it does not generate output. When ...
by dharav9
Wed Jan 08, 2020 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 2072

Re: TM1 MDX in TI Process

Hi, All I just tried to export the data in asciioutput from the view created through MDX as we communicated. I am not able to export data either manually (right click on view and export - it generates unknown error) or through TI (it does not generate output. When i open the view then i do able to s...