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.
Search found 139 matches
- 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
- 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...
- 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.
"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.
- 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...
- 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.
Let's say we have a web server what components can we put on it to add PAW server configuration?
Thanks,
Paul.
- 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...
- 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.
I found something called "Lifecycle management" under administration where we can selectively add assets for exporting to another environment.
Thanks,
Paul.
- 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...
- 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.
- 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.
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.
- 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.
Thanks,
Paul.
- 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.
- 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...
- 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.
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.
- 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.
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.
- 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.
- 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.
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.
- 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...
- 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.
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.
- 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 - ...