Search found 124 matches

by Paul-TM1
Tue Feb 27, 2024 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 368

Re: RAM and PVU licensing

Thanks again.
by Paul-TM1
Mon Feb 26, 2024 6:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 368

Re: RAM and PVU licensing

Thanks Gtonkin.
Is the 2 TB machine on Cloud?
We have reordered our dimensions and got it to an ideal memory position. We have to add more applications and will eventually run into that situation.


Thanks,
Paul.
by Paul-TM1
Fri Feb 23, 2024 7:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 368

RAM and PVU licensing

Hi All, We are on PA 2.0.9.15 version and have a server with 200 GB HD and 128 GB RAM with 8 cores (max PVU license for processor.) Lately we are seeing about 80% of RAM used want to add more models to the server and want to know the best approach. Our IT says the server is huge on RAM and can't add...
by Paul-TM1
Mon Jan 22, 2024 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives Report
Replies: 6
Views: 1328

Re: Perspectives Report

Thanks Wim, I created another cube and a dimension (for level 4 for proj dim - idea from you) and it works like a charm.
Could we go without a cube? maybe we could, but in a cube form, it data looks good for verification.

Thanks for that idea.
Paul.
by Paul-TM1
Fri Jan 19, 2024 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives Report
Replies: 6
Views: 1328

Re: Perspectives Report

Hi Wim, Yes, Project dimension hierarchy is in place and attached the image. can you give me a hint on getting the data at level 2? Hope I was able to explain. Depending on the level 4 of the project, we report at level 2. All Ending With A - Uniform All Ending With B - Supplies All Ending With C - ...
by Paul-TM1
Thu Jan 18, 2024 9:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives Report
Replies: 6
Views: 1328

Perspectives Report

Hi All, I have a requirement to develop a perspectives report. The report has a complexity to report at a lower level depending on the last level (char) of the Project. I will attach sample data. Like you see in the full data sheet, all projects end with an alpha char which implies to what expense t...
by Paul-TM1
Tue Jul 18, 2023 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access pmpsvc from a public URL - Setup question
Replies: 1
Views: 681

Re: Access pmpsvc from a public URL - Setup question

Hi all,
Here is what I did to resolve.

I configured the External Server URI in the TM1 Application server. The External Server URI points to https://[portalname]. Afterwards, I restarted the service and it worked.

Thanks,
Paul.
by Paul-TM1
Thu Jul 13, 2023 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access pmpsvc from a public URL - Setup question
Replies: 1
Views: 681

Access pmpsvc from a public URL - Setup question

Hi All, I have a question on setting up pmpsvc to access remotely. We have setup a public url https://tm1.abcd.com and it directs it to http://tm1WebServer.fullyQualifiedName:9510 - internal url. After hitting the public URL, gets redirected to internal URL then goes to Cognos BI for authentication ...
by Paul-TM1
Fri May 26, 2023 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove duplicate elements in MDX subset build
Replies: 6
Views: 1047

Re: Remove duplicate elements in MDX subset build

Thank you for your responses. I could not get the union work with Lotsa's expression. I instead used SubsetElementExists function and finished it.
I did like to know how to add union to the mdx in the case. Can someone please let me know?

Thanks,
Paul.
by Paul-TM1
Tue May 23, 2023 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove duplicate elements in MDX subset build
Replies: 6
Views: 1047

Remove duplicate elements in MDX subset build

Hi all, I am trying to build an MDX subset in the following way. I want 'Jan Forecast' and 'Mar Forecast' always included in the subset. 'PriorMonthSnapshot_1' refers to a snapshot taken 2 months ago and 'PriorMonthSnapshot_2' refers to a snapshot taken 3 months ago. There is a chance that the eleme...
by Paul-TM1
Fri May 12, 2023 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Licensing - AD and users in the model
Replies: 2
Views: 1020

TM1 Licensing - AD and users in the model

Hi All, I have a question about Termed users. We have AD users coming from Cognos into TM1. For termed termed users, the AD groups associated are deleted in AD but the user names still are in the TM1 model. Should we delete them in the model too and will not deleting them in TM1 model cause any issu...
by Paul-TM1
Tue Mar 07, 2023 3:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help with a feeder
Replies: 9
Views: 1335

Re: Need Help with a feeder

Thanks for all your advices. I told the business and they wanted to see the rate no matter what. I got the idea now.

Thanks again,
Paul.
by Paul-TM1
Wed Mar 01, 2023 6:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help with a feeder
Replies: 9
Views: 1335

Need Help with a feeder

Hi All, I have a feeder and want to combine the two feeder statements into one and write it more efficiently. Can someone please help? Cube 1: RateCodes Dimensions: Months PLCCode Rate Type Cube 2: Labor Dimensions: Employee LaborMsrs Months Projects Versions Cubes Rule in Labor cube [{'Bid', 'Prici...
by Paul-TM1
Wed Jan 04, 2023 9:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives End User Training
Replies: 1
Views: 415

Perspectives End User Training

Hi All,
I am looking for some material on TM1 Perspectives that can be used for end user training. Can someone please share a resource that can help me prep?

Thanks,
Paul.
by Paul-TM1
Wed Oct 26, 2022 6:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Postman SSL Cert
Replies: 5
Views: 3211

Re: Postman SSL Cert

Hi Burnstripe,
I tried to extract the TM1 cert (ibmtm1.arm) that we loaded loaded into the Cognos key store and it gave a .arm file and not cer file with key. Can you please try on your side once? I am stuck here.

Thanks,
Paul.
by Paul-TM1
Tue Oct 25, 2022 5:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Postman SSL Cert
Replies: 5
Views: 3211

Re: Postman SSL Cert

Thanks Burnstripe for the reply. We are using the default SSL cert and so I used the "ibmtm1.arm" like you said and actually renamed it to .pem and get this error. SSL Error: Hostname/IP does not match certificate's altnames What should be my next steps? Renaming was an idea from this link...
by Paul-TM1
Mon Oct 24, 2022 6:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Postman SSL Cert
Replies: 5
Views: 3211

Postman SSL Cert

Hi all, I am trying REST API and was able to work disabling "SSL certificate verification." To enable "SSL certificate verification", we have to import SSL cert and am looking for those steps. In the link "https://www.ibm.com/support/pages/node/6620979" point 5, "i...
by Paul-TM1
Tue Sep 13, 2022 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spreading - Stop after certain months
Replies: 3
Views: 816

Re: Data Spreading - Stop after certain months

Thanks Wim Gielis. We were trying to accomplishn in Contributor.
Thanks Declnar! That works.


Paul.
by Paul-TM1
Fri Sep 09, 2022 10:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Spreading - Stop after certain months
Replies: 3
Views: 816

Data Spreading - Stop after certain months

Hi All, We have an issue with data spreading. When we try to spread, it spreads to all available cells to the left or right. Is there a way to prevent from spreading after certain months? Example, put a stop after say 5 months or is there a way to limit spreading on a rule like period of performance...