Search found 72 matches

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: 9175

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: 5494

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: 5494

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: 5494

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: 5494

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: 5494

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: 5494

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

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: 7798

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 dimensio...
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: 5
Views: 3682

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: 5
Views: 3682

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: 7798

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...
by dharav9
Wed Jan 08, 2020 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 7798

Re: TM1 MDX in TI Process

Thank You All for your time and input. @lotsaram: Thank You for the following extension of the function. It works as expected. SubsetCreatebyMDX( 'SubName', 'MDX_Expression', '[DimName]', [AsTemp] ) The last 2 arguments are optional - DimName (string) blank unless supplied. If supplied then the subs...
by dharav9
Tue Jan 07, 2020 8:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 7798

TM1 MDX in TI Process

Hi, All I have placed following MDX in dimension and created subset. I did not find any issue. When i place same MDX in TI process then receiving an error - dynamic subset cannot be created. '{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( ['|DimEmp|'] )}, 0)}, ( (['|cubPlanEmp|'].(['|DimEmp|'].CurrentMem...
by dharav9
Thu Nov 14, 2019 8:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to copy paste book from content space (PAW)?
Replies: 1
Views: 1497

Is there a way to copy paste book from content space (PAW)?

Hi, All Is there a way to copy paste the existing book in PAW? or is there a way to save as existing book to different name and path? We want our user to copy book from shared folder and save it to their personal folder. Once they save it to their personal folder, they can do their customization the...
by dharav9
Mon Oct 21, 2019 3:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to export User Workspace without Life Cycle Manager
Replies: 0
Views: 11158

How to export User Workspace without Life Cycle Manager

Hi,

We have upgraded Planning Analytics PAW to version 2.0.43. In Production, we have PAW 2.027 - It doesn't have life cycle manager.
I want to migrate all work space from shared folder. What is the best practice to export all the workspace (.gz without life cycle manager)?

Thank You
Dharav
by dharav9
Tue Oct 15, 2019 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Personal subset of users to a clone dimension
Replies: 1
Views: 3526

Copy Personal subset of users to a clone dimension

Hi, All I would like to copy the personal subset of users for company dimension to clone_company dimension. We have 500 users. I know we can do it manually by following steps as below: Data Directory => AD=> User Profile=> company}sub => copy this folder and paste it with clone_company}sub =>Copy su...
by dharav9
Tue Sep 10, 2019 5:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PickList is not visible with IFERROR formula
Replies: 1
Views: 2449

PickList is not visible with IFERROR formula

Hi, All While creating input sheet for the users, i found that if i use DBRW formula along with IFERROR formula then my cells does not show picklist drop down. If i just write the DBRW formula then it shows picklist. If i just apply the DBRW formula then all cells without having corresponding value ...
by dharav9
Tue Aug 20, 2019 1:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Directory Connection Error
Replies: 1
Views: 11366

Active Directory Connection Error

Hi, All We have integrated Mode = 5(CAM BI Security). We recently moved from physical server to AWS cloud set up. Our networking team opened 389 port from Active Directory domain server to AWS server. Do we need to open 389 port from AWS server to Active Directory domain server? While validating AD,...
by dharav9
Fri Jul 12, 2019 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Save MDX based Subset for Clone Dimension
Replies: 3
Views: 2751

Re: How to Save MDX based Subset for Clone Dimension

@declanr and @Emixam : Thank You guys for quick turn around. It works. I have to bring private subset as well from Data Folder=> AD => User Profile. How the logic would work here? I created a folder called Source_Clone}Sub inside their AD Profile and paste the private subset from Source}Sub folder. ...