TM1 Forum

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

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.

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

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.

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

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

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

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

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

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

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

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

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

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.

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.

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

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.

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

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

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