Search found 132 matches
- Fri Nov 17, 2023 6:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18774
Re: REST API Dimension Clone
I clearly need some help, so if someone can share a powershell script that does something similar, i would really appreciate it I'm willing to dig into this to see what programmatic solution is possible. Can you give me a definition of "hot promote" in this context, that's one that's not ...
- Thu Nov 16, 2023 2:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18774
Re: REST API Dimension Clone
Can you provide some details about your Powershell Script you use to hot promote TI Processes? I am trying to do the same thing but I cant find any help online Where are you in your TM1 REST api journey ? Do you use a tool like Postman to execute requests and capture the response ? Do you use Pytho...
- Wed Nov 15, 2023 6:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18774
Re: REST API Dimension Clone
Hello, We have a simple Powershell script to hot promote TI processes, and am looking to implement something similar for dimension metadata. I'm looking to replicate a dimension between 2 services using the REST API as opposed to TI. It should be an exact copy, including attributes. Does anyone kno...
- Thu Jun 23, 2022 7:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Modify default TM1web layout
- Replies: 8
- Views: 2226
Re: Modify default TM1web layout
I also have a requirement to add a new Icon which will launch another site. The requirement is to add the Icon on the Top Banner, just after Log Out
Not sure which files need to be updated for 2.0.9.4
Thanks
Not sure which files need to be updated for 2.0.9.4
Thanks
- Wed Jun 15, 2022 3:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rest API as a specific user
- Replies: 2
- Views: 1062
TM1 Rest API as a specific user
Hello, I am trying use TM1 Rest API in order to allow users to extract some data/metadata stored in a TM1 model (Cubes, dimensions) and display that data into a web interface. We have SecurityMode=1 with LDAP, and I would like to have a delegated User ID that has all the required access to the TM1 C...
- Mon Feb 01, 2021 2:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Issue when Multiple Hierarchies of the same dimension are used in a PAW View
- Replies: 1
- Views: 1358
Rule Issue when Multiple Hierarchies of the same dimension are used in a PAW View
Hi guys, I have a Cube with following dimensions: Scenario Time Period Product Location Account Measures We have a some elements in the Scenario Dimension that are populated with Rules as a combination of Actual data and Forecast Data, so for each scenario, in a COntrol Cube, we keep the First Forec...
- Thu Jan 14, 2021 3:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Content Store
- Replies: 4
- Views: 3022
Re: PAW Content Store
Thank you,
I have seen MongoDB in the list of PAW Services, but is there any client tool that can be used to read this type of Database?
I have seen MongoDB in the list of PAW Services, but is there any client tool that can be used to read this type of Database?
- Thu Jan 14, 2021 1:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Content Store
- Replies: 4
- Views: 3022
PAW Content Store
Hey guys, Does anyone here know where are the Views, Books and other Workspace Content stored physically? In IBM Documentation, they talk about Workspace Content Store, but I could not find any information about what this Content Store is. Is it in file system, or is it something buried into docker ...
- Fri Dec 18, 2020 5:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Add an Admin into Planning Analytics Workspace
- Replies: 1
- Views: 1667
Add an Admin into Planning Analytics Workspace
Hi Guys, I installed Planning Analytics Workspace in a brand new server. I have also installed TM1 in the same server and I created a TM1 Database. Everything works fine. I can connect to PAW, I can also access Cubes and other Objects from PAW, but it looks like I am just a regular user on PAW How d...
- Thu Oct 08, 2020 9:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Asymmetric Views with MDX
- Replies: 1
- Views: 1282
Asymmetric Views with MDX
Hi Guys, I have a cube with following DImensions: Version Time_Period Location Customer Product Account Measures I want to build a View in PAW, and in the Columns I have the Version and Time Period Nested: If the Current Month ( stored in a cube) is September 2020, In my view, I want to show only Ac...
- Tue Sep 15, 2020 10:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics / Cognos Analytics Dependency
- Replies: 1
- Views: 1125
Planning Analytics / Cognos Analytics Dependency
Hi guys, We are looking to upgrade Planning Analytics to the latest version ( 2.0.9.2 ) and also upgrade PAW and PAX to the latest versions. Do we need to upgrade also Cognos Analytics? We use Security Mode 5 but we do not use Cognos BI ( Cognos Analytics ) for anything else, so I am not sure what i...
- Fri Aug 21, 2020 10:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Point Workspace Views to different TM1 Server
- Replies: 1
- Views: 1308
Point Workspace Views to different TM1 Server
Hi, I need some help in regards to object migration from one server to another, in PAW: I have both databases ( Dev and Test) on the same server, one called FnP_Dev and the other one FnP_QA I created all the books and views in DEV and now when I try this Lifecycle Management to migrate them to QA, y...
- Fri Aug 21, 2020 10:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copy your PAW book design to another TM1 server
- Replies: 9
- Views: 11137
Re: Copy your PAW book design to another TM1 server
Hi, Thanks for sharing this. I have both databases ( Dev and Test) on the same server, one called FnP_Dev and the other one FnP_QA I created all the books and views in DEV and now when I try thing Life Cycle Management to migrate them to QA, yes the package gets created and it gets migrated, but all...
- Tue Aug 04, 2020 10:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security in Planning Analytics Workspace
- Replies: 4
- Views: 3032
Re: Security in Planning Analytics Workspace
I don't know if it was available in 2.0.41 like you have, but recent releases of PAW definitely have user groups. https://quebit.com/askquebit/IBM/planning-analytics-workspace-security/ Thank you, yes I also came across the link you provided, and but what I cannot find anywhere is if there is a con...
- Tue Aug 04, 2020 7:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Security in Planning Analytics Workspace
- Replies: 4
- Views: 3032
Security in Planning Analytics Workspace
Hello, It looks like the Folder Security / Book Security in PAW has to be specified by user ( instead of User Groups ). Is there a way for configure PAW so that the Security Access to a certain Folder / Book in PAW can be granted for a Group instead of individual users? The version of PAW we gave is...
- Wed Jul 15, 2020 5:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error while trying to build a Named Hierarchy in a TI process
- Replies: 4
- Views: 3045
Re: Error while trying to build a Named Hierarchy in a TI process
Hi guys, It looks like Paul Simon has experienced the same issue, and I found something online regarding this. He also provided a workaround, but before coming across his thread, I deleted the Dimension and re-created it. When i recreated the dimension, on the same time I did what Paul suggested and...
- Wed Jul 15, 2020 12:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error while trying to build a Named Hierarchy in a TI process
- Replies: 4
- Views: 3045
Re: Error while trying to build a Named Hierarchy in a TI process
Thanks for the reply: #== Code in Prolog Tab HierName = 'By Product Category' ; IF ( HierarchyExists ( dimName, HierName ) = 0 ) ; HierarchyCreate ( dimName, HierName ) ; ELSE ; HierarchydeleteAllElements ( dimName, HierName ) ; ENDIF ; HierarchySortOrder ( dimName, HierName , 'ByInput' , 'Ascending...
- Wed Jul 15, 2020 12:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Error while trying to build a Named Hierarchy in a TI process
- Replies: 4
- Views: 3045
Error while trying to build a Named Hierarchy in a TI process
Hi, I am facing an issue while I am trying to build a new hierarchy in a TI Process. I have a dimension which has multiple ALternate Hierarchies ( what we used to call Alternate Hierarchies), and I am trying to convert them into Named Hierarchies. I am able to convert them all, without any issues, b...
- Mon Jul 13, 2020 4:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web Websheet Snapshot to Excel taking too long
- Replies: 2
- Views: 1830
TM1Web Websheet Snapshot to Excel taking too long
Hi Guys,
We have a websheet with an Active Form ( which has a few thousand lines ). The websheet opens fine and refreshes quickly, but when user tries to Snapshot it to excel, it takes way too long, more than an hour.
We are using PA 2.0.5 so has anyone experienced this?
Thanks
We have a websheet with an Active Form ( which has a few thousand lines ). The websheet opens fine and refreshes quickly, but when user tries to Snapshot it to excel, it takes way too long, more than an hour.
We are using PA 2.0.5 so has anyone experienced this?
Thanks
- Tue Aug 14, 2018 6:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1RPTRow with MDX Expression that Returns zero elements
- Replies: 8
- Views: 5973
Re: TM1RPTRow with MDX Expression that Returns zero elements
If Excel is crashing if the set is null then you could quite easily work around this by doing a Union with a dummy employee (e.g. +{[employee].[no employee]} ) at the end of your existing MDX. If you don’t have a dummy element in the dimension you could create it. You could even then apply special ...