Search found 32 matches

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

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: 12
Views: 505

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: 12
Views: 505

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: 12
Views: 505

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

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

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

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

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

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

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
by Rtel
Thu Jan 10, 2019 7:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 512

Re: Missing object access after copy from Prod to Dev

Hi, I tried copying the files as suggested but server is not starting at all. I reversed the files and server still can not start

I am puzzled.

Any suggestion ?

Thanks
by Rtel
Wed Jan 09, 2019 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 512

Re: Missing object access after copy from Prod to Dev

Hi Tomok, thanks for the reply.

In such case, if we delete }Client dimension and }ClientGroups cube from existing data directory and restart the server , will these 2 objects be recreated ? or what should be the approach.

Thanks

Rtel
by Rtel
Wed Jan 09, 2019 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 512

Re: Missing object access after copy from Prod to Dev

HI Steve, thanks for your response. I checked and the folder path is correct pointing to all data files. Also i am not able to create any new cubes since that option is disabled. I am thinking I may have to change Cognos LDAP authentication on Dev to Native TM1 and add users appropriately and change...
by Rtel
Tue Jan 08, 2019 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing object access after copy from Prod to Dev
Replies: 8
Views: 512

Missing object access after copy from Prod to Dev

Hi there, I have system A that have: 1) TM1 native login in Prod 2) Cognos authentication method in Dev (I have access to Prod and Dev both as a user not admin) Once system A is copied (by network engineer) from prod to Dev (keeping original Tm1.cfg file in Dev) and when I log back in to the System ...
by Rtel
Thu Jan 03, 2019 5:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders
Replies: 2
Views: 657

Re: Feeders

Hello Wim, thank you very much for the information/education. This helps a lot understanding the concept.

Regards,

Rtel
by Rtel
Wed Jan 02, 2019 10:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule shows syntax error on Commented line !
Replies: 4
Views: 2819

Re: Rule shows syntax error on Commented line !

Thanks everyone for your suggestions.

I removed few blocks of large comments even though they were commented on each lines !! This seems to have solve the issue.

I will recreate the Rule just to see if I can replicate the error again with some large comments.

Thanks

Rtel
by Rtel
Wed Jan 02, 2019 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders
Replies: 2
Views: 657

Feeders

Hello I am trying to understand how Feeder work and I have reads many articles and guides but not sure if anywhere it explains at cell level what actually happens between rules and feeders. Please see the scenario below and the follow up question. Lets for e.g. say In Account Cube there are 3 dimens...
by Rtel
Thu Dec 27, 2018 4:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule shows syntax error on Commented line !
Replies: 4
Views: 2819

Rule shows syntax error on Commented line !

Hello, I am facing really tricky situation. I have enabled enhanced Rules editor. 1) A Rule was working fine. 2) I cut all the code from this rule file and pasted in a notepad file. 3) pasted back all the code back in the rule file Now while saving or checking Syntax it throws error on Commented lin...
by Rtel
Mon Dec 24, 2018 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subsets on Time dimension
Replies: 5
Views: 1426

Re: Dynamic subsets on Time dimension

Thank you Win for the suggestions. It helps me improve of solution designs. I will try some of those methods Thank you Howard, I have generalized your MDX statement. I hope i understood them correctly. ------------------------------------------------------------------------------------------ Hardcod...