Search found 1630 matches

by declanr
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...
by declanr
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.
by declanr
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...
by declanr
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.
by declanr
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...
by declanr
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 ...
by declanr
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...
by declanr
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...
by declanr
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 ...
by declanr
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...
by declanr
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...
by declanr
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...
by declanr
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...
by declanr
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.
by declanr
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.
by declanr
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.)
by declanr
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.
by declanr
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...
by declanr
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 ...
by declanr
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...