Search found 139 matches

by Paul-TM1
Thu Mar 20, 2025 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove the alias in MDX of dimension; show member ID
Replies: 8
Views: 57317

Re: Remove the alias in MDX of dimension; show member ID

Hi Wim,
Thanks for replying.
Saving the subset without the name seemed to help the day1, but when we opened the next day, or added the subset to another view, the name appears.
The list in the subset is created using MDX and I am looking for a MDX solution.

Thanks,
Paul.
by Paul-TM1
Mon Mar 10, 2025 8:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove the alias in MDX of dimension; show member ID
Replies: 8
Views: 57317

Re: Remove the alias in MDX of dimension; show member ID

Thanks Lotsaram. In the set editor in PAW, in the dropdown of caption when I select member Id, member ID is displayed. I saved the subset thinking it would keep the member Id, but it's not. When open the subset, alias is back. Any idea on what should be done to just get the member Id from the MDX? T...
by Paul-TM1
Wed Mar 05, 2025 8:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove the alias in MDX of dimension; show member ID
Replies: 8
Views: 57317

Re: Remove the alias in MDX of dimension; show member ID

Thanks Maren, it did not help.

"2 - FPA" is not an alias. It's ID.

Again, I want to remove name that comes with alias in the list after committing MDX.

Thanks,

Paul.
by Paul-TM1
Mon Mar 03, 2025 4:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove the alias in MDX of dimension; show member ID
Replies: 8
Views: 57317

Remove the alias in MDX of dimension; show member ID

Hi All, By default, when a dimension is opened, alias with name is coming and am trying to remove. In PAW, I was able to select "Member ID" from dropdown and it's static thought I saved. When I reopened the subset, the alias turned on. What MDX should be added to remove alias. I am sure th...
by Paul-TM1
Thu Feb 27, 2025 4:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Creating a new landscape
Replies: 7
Views: 14235

Re: Help on Creating a new landscape

Thanks for your inputs Tomok and Burnstripe.
Let's say we have a web server what components can we put on it to add PAW server configuration?

Thanks,
Paul.
by Paul-TM1
Tue Feb 25, 2025 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Help on Creating a new landscape
Replies: 7
Views: 14235

Help on Creating a new landscape

Hi All, We are upgrading from 2.0.9 to 2.1 and need help in getting the server requirements right. We currently have 3 servers in 2.0.9 and use contributor for data entry. PAW for reporting and analysis. Current Landscape: 1. App server --> where the TM1 admin server and all the databases (TM1 serve...
by Paul-TM1
Tue Feb 25, 2025 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to selectively add PAW applications
Replies: 2
Views: 6445

Re: How to selectively add PAW applications

Thanks Burnstripe.
I found something called "Lifecycle management" under administration where we can selectively add assets for exporting to another environment.

Thanks,
Paul.
by Paul-TM1
Mon Feb 10, 2025 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to selectively add PAW applications
Replies: 2
Views: 6445

How to selectively add PAW applications

Hi Gurus, I am upgrading from 2.0.9 to 2.1 (upgrading 6 TM1 servers databases and respective contributor applications.) I want to upgrade one database and it's contributor app at a time and move them to 2.1. Can I move just one application at a time to 2.1 and integrate with what's on 2.1 already? I...
by Paul-TM1
Mon Dec 02, 2024 4:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Global Profile settings
Replies: 2
Views: 2597

Re: PAW Global Profile settings

Thanks Wim.
by Paul-TM1
Wed Nov 27, 2024 5:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Global Profile settings
Replies: 2
Views: 2597

PAW Global Profile settings

Hi All,
I am looking for PAW Global Profile settings. Is there a place where we can set it globally? Attached is a pic for a user.

Thanks,
Paul.
by Paul-TM1
Fri Nov 22, 2024 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unsuppress Zero is not working in TI Process.
Replies: 3
Views: 5002

Re: Unsuppress Zero is not working in TI Process.

Thanks burnstripe and Alan. It worked like a charm.

Thanks,
Paul.
by Paul-TM1
Thu Nov 21, 2024 8:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unsuppress Zero is not working in TI Process.
Replies: 3
Views: 5002

Unsuppress Zero is not working in TI Process.

Hi All, I have looked for zero suppress in the forum and learnt that when a view is created, zero suppress is set. I am later turning off using the ViewSuppressZeroesSet and it does not work. ViewSuppressZeroesSet(SourceCube, SourceCubeView, 0 ); Can someone tell me where I am wrong? Thanks, Paul.
by Paul-TM1
Fri Jun 07, 2024 8:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Install PA2.1.0 Questions
Replies: 3
Views: 5180

Install PA2.1.0 Questions

Hi All, I am installing PA 2.1.1 and have a ton of questions and hope someone can answer them. 1. If PAW is going to replace Contributor, how are we going to open projects and how are access rights done? Is there a video demo? 2. I am unable to sync Excel sheets. 3. Is there a thread that I an follo...
by Paul-TM1
Wed May 15, 2024 5:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to open a PAW report in PAX?
Replies: 6
Views: 9799

Re: Is it possible to open a PAW report in PAX?

Hi Wim,
Thanks for responding.
We have a few PAW books created in PAW and want to open them from PAX. The reports have attributes displaying along with measures.

Thanks,
Paul.
by Paul-TM1
Wed May 15, 2024 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it possible to open a PAW report in PAX?
Replies: 6
Views: 9799

Is it possible to open a PAW report in PAX?

Hi,
Can someone let us know if PAW reports can be opened in PAX? I know we can open PAX reports published to PAW and can be opened.

Thanks,
Paul.
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: 3214

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

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

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

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

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