Search found 42 matches

by Rtel
Mon Jun 10, 2019 3:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating cubes across different applications with TI
Replies: 3
Views: 620

Re: Updating cubes across different applications with TI

Hello All, Thanks for your responses. I will explore the direction provided.

Hi Wim, by 'Application' I meant a TM1 server modal.

Thanks

Rtel
by Rtel
Thu Jun 06, 2019 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating cubes across different applications with TI
Replies: 3
Views: 620

Updating cubes across different applications with TI

Hi, I am writing a TI to update data in a cubes in one application. This needs to be followed by change data in a cube in another application also. So is it possible to write a TI process to update values in a cube in a different application ? or How can I have a TI process from one application call...
by Rtel
Mon Jun 03, 2019 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: At Wits' End: "File not found: tm1xl.ocx"
Replies: 11
Views: 11573

Re: At Wits' End: "File not found: tm1xl.ocx"

Correction..

I believe path to tm1p.xla should point to 'C:\Program Files\ibm\cognos\tm1_64\bin' folder since my MS Excel is 32 bit. If that's true, how do I change the TM1 perspective to look at 'C:\Program Files\ibm\cognos\tm1_64\bin' folder for Tm1p.xla
by Rtel
Mon Jun 03, 2019 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: At Wits' End: "File not found: tm1xl.ocx"
Replies: 11
Views: 11573

Re: At Wits' End: "File not found: tm1xl.ocx"

Hello, I am getting Tm1.ocx error 53. I tried registering all the DLLs (tm1xl.ocx, tm1prc.dll,tm1dasrv.dll ) but still getting error. I checked the path of tm1.xla from VBA and its pointing to C:\Program Files\ibm\cognos\tm1_64\bin64 I believe path to tm1p.xla should point to 'C:\Program Files\ibm\c...
by Rtel
Mon Jun 03, 2019 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 193

Re: display Dimension dialog box from TI process

Hi Tomok and Paul, thank you for your help.

Rtel
by Rtel
Fri May 31, 2019 3:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 193

display Dimension dialog box from TI process

Hello, Q 1) I want to create an action button to invoke a TI that takes an Element name as an argument. Can we create this form with action button from Architect or we need Perspective ? Q 2) Lets say we have a Dimension named Product and one of the element in it is Electronics. Can we display produ...
by Rtel
Wed May 29, 2019 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 595

Re: Getting all the children of an element

Hello All, thanks for all your help. Following is the working code that I would like to share. From the responses I understand that there are 1) two diff MDX to create subset 2) two way to create Dynamic subset ( I will try both to understand the difference) Thanks, Rtel ----------------------------...
by Rtel
Tue May 28, 2019 10:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 595

Re: Getting all the children of an element

To add to my previous question

how to use this MDX from TI to iterate through all the elements in the subset

{TM1DRILLDOWNMEMBER( {[Dimension].[Element]}, ALL, RECURSIVE )}

Thanks
by Rtel
Tue May 28, 2019 10:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 595

Getting all the children of an element

Hi, In a TI, I want to loop through all the child elements of an element passed as an argument. For eg if Element name argument to TI is 'Element 1' , TI should iterate through Element 1.1 Element 1.2 Element 1.3 Element 1.3.1 Element 1.3.2 I tried ElementCount function, but it is throwing error as ...
by Rtel
Tue May 28, 2019 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 11
Views: 1020

Re: issues with moving TI processes

Hi Lotsaram, thanks for sharing. I will take a look at new library. We are now moving to PA and PAW in windows 2016.

Thanks

Rtel
by Rtel
Thu Apr 11, 2019 9:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 910

calculating WTD, YTD and QTD with rules

Hello,I am looking to calculate WTD, MTD and YTD for sales for a business. The cube will have standard Dim such as Dept, Acct etc. Time dimension is at week level and all the sales data are provided at week level. WTD is calculated as last week sale MTD is calculated as sum of all the weeks beginnin...
by Rtel
Wed Apr 10, 2019 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error launching PAW 2.0.6
Replies: 13
Views: 704

Re: Error launching PAW 2.0.6

Hello , I ran PAW.ps1 STOP followed by PAW.ps and it worked !

Thanks

Rtel
by Rtel
Tue Apr 09, 2019 9:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error launching PAW 2.0.6
Replies: 13
Views: 704

Re: Error launching PAW 2.0.6

Please see the results below. PS E:\scripts> .\paw.ps1 ps The IBMCognosGatewayURL variable is not set. Defaulting to a blank string. The SAVE_VERSION variable is not set. Defaulting to a blank string. The TM1PROXY_VERSION variable is not set. Defaulting to a blank string. The system cannot find the ...
by Rtel
Tue Apr 09, 2019 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error launching PAW 2.0.6
Replies: 13
Views: 704

Error launching PAW 2.0.6

Hello, I have installed PAW 2.0.6. and It worked fine for 3 days. I could see TM1 DB model. Browse cubes,dim etc Suddenly now after logging it waits for some time and shows blank white screen with { } on top left of the screen. Windows 2016 TM1 server and PAW installed on same machine Native TM1 log...
by Rtel
Tue Apr 09, 2019 3:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GL application and Alternate Hierachies
Replies: 6
Views: 401

Re: GL application and Alternate Hierachies

Hi Lotsaram and Mark for your comments and suggestions In this scenario, 1) This central TM1 cube (with all client) will be source to Cognos analytics for visualization and reporting. 2) Client can access only their data based on security. 3) Accounts Hierarchy is same for all clients. Measures I am...
by Rtel
Mon Apr 01, 2019 7:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GL application and Alternate Hierachies
Replies: 6
Views: 401

Re: GL application and Alternate Hierachies

Hi Wim, Thank you very much for all the details and your time. I am still learning to create alternate H. Via TI or manually. I will work on your suggestions and will get back. Also please let me know your thoughts for following approach. 1) have a cube where it shows start and end date of Calendar ...
by Rtel
Fri Mar 29, 2019 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: GL application and Alternate Hierachies
Replies: 6
Views: 401

GL application and Alternate Hierachies

Hello, can some direct me to a good tutorial/video for Alternate Hierarchies. I want to build a GL app using Alt H where I have multiple clients with different calendar start and end For eg Client1 Calendar Start- Jun 2018 and Calendar End May 2019 Client2 Calendar Start- Oct 2018 and Calendar End S...
by Rtel
Fri Feb 08, 2019 4:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PA 2.0.6
Replies: 4
Views: 572

Re: IBM PA 2.0.6

Thanks Derezed for the information

I was wondering if the port number range used in TM1 config file is same for 2.0.6 as it was for 10.2

Thanks

Rtel
by Rtel
Fri Feb 08, 2019 4:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 583

Re: Missing object access after copy from Prod to Dev

Hello all, after some experiments I found the answer' Issue 2 different kind of authentication method on 2 diff environments Solution 1) Copying files from Prod (with TM1 native login) to Dev --Keep TM1.cfg from Dev 2) Change original Config file on Dev to set up TM1 native login (IntegratedSecurity...
by Rtel
Thu Feb 07, 2019 7:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PA 2.0.6
Replies: 4
Views: 572

IBM PA 2.0.6

Hello,

1) what is the difference between

IBM Planning Analytics Local 2.0.6
IBM Planning Analytics Advanced 2.0.6
IBM Planning Analytics Express 2.0.6

2) What are the Valid port numbers to use in IBM PA ?

Thanks

Rtel