Search found 1630 matches
- Thu Feb 25, 2021 10:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dynamic Subsets turning static
- Replies: 2
- Views: 53
Re: Dynamic Subsets turning static
This sounds like a bug that caused me to question my sanity last week: https://ibm.com/support/pages/apar/PH31597 IBM have stated its planned to be resolved in PA 2.0.9.6 LC and PA 2.0.9.1 IF 7 The incident and support team suggest that there are many potential causes of this which have not yet been...
- Tue Feb 23, 2021 10:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: copying element security data from one element to another
- Replies: 8
- Views: 251
Re: copying element security data from one element to another
Personally, if this is a one off job I would be inclined to just do it manually in PAX/perspectives with simple lookups to decide where you want to paste the values into.
- Mon Feb 22, 2021 8:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: preventing automatic restart of databases after monthly maintenance
- Replies: 14
- Views: 200
Re: preventing automatic restart of databases after monthly maintenance
Assuming that you are running on IMB's cloud offering? If so, I would imagine just raising a ticket to IBM asking them to change the service from automatic to manual start-up mode would suffice. IBM are normally very responsive with such tickets but this is not a request I have ever made of them bef...
- Tue Feb 16, 2021 4:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Dynamic Subset with Value from other Cube
- Replies: 4
- Views: 442
Re: MDX Dynamic Subset with Value from other Cube
The CurrentMember method as you have suggested should work but you need those dimensions to be in the Title Elements/Context area, it won't work if you have them as rows or columns.
- Tue Feb 16, 2021 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using parameter to specify CellPutN/S
- Replies: 4
- Views: 100
Re: Using parameter to specify CellPutN/S
You are using a parameter in your cellputn - this is controlling which cells you write into. However, you have made no filter on your datasource. So the CellPutN runs for every line of your source data, so it has loaded each row into the same target cells of "Version 9". The last row of data is "Dec...
- Fri Feb 05, 2021 7:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating Subset MDX with Alias
- Replies: 9
- Views: 909
Re: Creating Subset MDX with Alias
So breaking down the MDX you already have: sMDX = '{TM1drilldownmember( {TM1FILTERBYpattern( {TM1SUBSETALL([ '| Dim1 |' ] )},'| pat |' )}, ALL, RECURSIVE )} ' ; You are finding all elements in Dim 1 that contain the text "pat" and then drilling down to show them and all of their descendants. What I ...
- Thu Feb 04, 2021 6:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Prevent Consolidation Sums for an Element
- Replies: 5
- Views: 384
Re: Prevent Consolidation Sums for an Element
When you add an element under a consolidation you apply a weighting to it. Usually this weighting is 1 and if all children of a consolidation have a weighting of 1 then it just sums them up. For this element you can just give it a 0 weighting, if you are using dimensionelementcomponentadd or similar...
- Thu Feb 04, 2021 8:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating Subset MDX with Alias
- Replies: 9
- Views: 909
Re: Creating Subset MDX with Alias
My guess is that you are using FilterByExpression to return members that match based on their name. The problem is that when you apply an alias, it will search the alias that is selected to match it against FilterByExpression. So when you do that sort of thing you need to break the link between what...
- Wed Feb 03, 2021 8:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Architect & Web are not responding when trying to login
- Replies: 9
- Views: 563
Re: TM1 Architect & Web are not responding when trying to login
Since all of your servers are inaccessible, have you tried killing all of them at the same time before restarting? It suggests that you could have an issue with the admin server so I would try: 1/ Stop/Kill all tm1 services 2/ Restart the Admin Server 3/ Start the services 1 by 1 to see if they are ...
- Thu Jan 28, 2021 1:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Deleting even elements from dimension with process
- Replies: 5
- Views: 312
Re: Deleting even elements from dimension with process
Thanks, I solved it by this. Is there any more efficient way to do this? Thanks. The way you have done it is pretty efficient and will work quickly. However due to your specific requirement, you could have just started at 2 and worked in increments of 2. DimName = 'A_VNO_G_Rada'; LoopCounter = 2; W...
- Wed Jan 27, 2021 8:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Syntax in PAW.ps1 to enable View Integration In PAX
- Replies: 2
- Views: 218
Re: Syntax in PAW.ps1 to enable View Integration In PAX
You don't actually need to stop the services manually. But Ajay is correct that you need to run the paw.ps1 script after you make any changes to the config parameters. When you run ./scripts/paw.ps1 it will find any changes you have made and then restart only the services that are required for it to...
- Tue Jan 26, 2021 11:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to use Websheet in PAW
- Replies: 2
- Views: 148
Re: Unable to use Websheet in PAW
What are your configuration settings in PAW? Since TM1 Web has been split out you need to have the paw.ps1 variable below set to point to your TM1 Web Service: $env:TM1ApplicationsLocation=<WebServer:Port> If you use the admin tool this is the setting that is deceptively called "TM1 Application Serv...
- Wed Jan 20, 2021 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Actionbutton with more than one line
- Replies: 4
- Views: 275
Re: Actionbutton with more than one line
Just a thought on this, in Perspectives can't you add an image as the background of an action button? Create what you want the button to look like in Excel, take a screenshot and save it as an image and then try using that for the Action Button background. I think it might still require you to put t...
- Wed Jan 13, 2021 2:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Function Like TM1RPTROW to create Dynamic Columns
- Replies: 7
- Views: 380
Re: TM1 Function Like TM1RPTROW to create Dynamic Columns
Or you can go back to the original requirements and ask whether it needs to be a custom report at all or would a dynamic Exploration View in PaFE meet the requirement.
- Fri Dec 18, 2020 5:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Add an Admin into Planning Analytics Workspace
- Replies: 1
- Views: 361
Re: Add an Admin into Planning Analytics Workspace
Workspace automatically assigns the very first account that logs in as the admin account.
You will need to log in with that account and then change your main account (and any others) to the admin role. The default role for all users after that first one is Analyst.
You will need to log in with that account and then change your main account (and any others) to the admin role. The default role for all users after that first one is Analyst.
- Fri Dec 04, 2020 9:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: non-admins edit permission to 1 dimension via PAW ?
- Replies: 7
- Views: 418
Re: non-admins edit permission to 1 dimension via PAW ?
The user probably has Analyst permissions in Workspace. To gain access to the modelling capabilities they need to be set up as a modeler or admin (workspace groups not tm1 groups.)
- Thu Dec 03, 2020 7:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding attributes only to newly created elements
- Replies: 6
- Views: 503
Re: Adding attributes only to newly created
Or create a temporary static subset in the prolog of all Products that exist when the process starts.
Then in the data tab use SubsetElementGetIndex and if it returns a zero then it is a newly added Product.
Then in the data tab use SubsetElementGetIndex and if it returns a zero then it is a newly added Product.
- Wed Dec 02, 2020 1:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: scan/substring
- Replies: 2
- Views: 451
Re: scan/substring
Something like below where you work out how many characters are to the right of your character should get you there. If you start having the possibility for multiple ":" characters you would then need to look at loops to find the further right one perhaps. nPosition = Scan ( ':', sString ); sNewStri...
- Sun Nov 29, 2020 10:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Omitted data when importing to cube
- Replies: 2
- Views: 402
Re: Omitted data when importing to cube
You have already narrowed down the issue here to being on records that are on the same intersections. Your TI code generated by Performance Modeler will be using a CellPutN function, this function just overwrites the cell with the value you provide each time. So your cube gets updated each time but ...
- Fri Nov 27, 2020 2:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Refresh subnm mdx subset in pax
- Replies: 7
- Views: 506
Re: Refresh subnm mdx subset in pax
Hi, If you select the SUBNM cell and go to "Data Validation" you will see that the drop down list that you are seeing (as shown in your SUBNM.png image) is an Excel generated list rather than one generated by PAX. It will have a source called something along the lines of "Cafe_Validation_Temp". I be...