Search found 1568 matches

by declanr
Sat Jan 25, 2020 7:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Sets to Cloud Integration
Replies: 2
Views: 515

Re: Private Sets to Cloud Integration

Yes. Private subsets are stored in the data directory in folders for the username. Generally when migrating you want to take the opportunity to clean up some clutter from the data directory anyway. Copy all the users folders out to a separate location and Copy that to your cloud server. After you ha...
by declanr
Fri Dec 13, 2019 7:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AsciiOutput element order different from subset
Replies: 12
Views: 500

Re: AsciiOutput element order different from subset

Assuming it is only the dimension cbm_hybrid_program_project that you care about being ordered; you can keep the source view as you have it but with that dimension instead just having a single element in its assigned subset which is the total of all relevant elements. Make sure consolidations are in...
by declanr
Wed Dec 11, 2019 7:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 to PA Upgrade - Web Report Not Showing Last Line
Replies: 7
Views: 461

Re: TM1 to PA Upgrade - Web Report Not Showing Last Line

Only active form reports having the issue. Must of inserted the lines incorrectly as that did not work. Delete all rows apart from the first in the active form (the one that actually contains the tm1rptrow formula. A few rows below that type a word into a cell, something visible. Update the file on...
by declanr
Wed Dec 04, 2019 11:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 to PA Upgrade - Web Report Not Showing Last Line
Replies: 7
Views: 461

Re: TM1 to PA Upgrade - Web Report Not Showing Last Line

Insert a few extra rows under the active form area and add a border to the cells a few rows down then reupload the sheet and it will be fine.
by declanr
Sun Nov 24, 2019 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW visualization feature
Replies: 3
Views: 190

Re: PAW visualization feature

That’s just a case of selecting a given cell from an existing cube view and right click - Add to Sheet. Or similar wording to that effect.
by declanr
Sun Nov 03, 2019 6:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: access control objects
Replies: 25
Views: 3601

Re: access control objects

and the value in tm1 web view looks in blue color. Is the user using a sandbox ? no he is not using any sand box.test_process1.PNG The blue colour means that the user is using a sandbox.This could either be a manually created and selected sandbox - or very likely the user has the Personal Workspace...
by declanr
Sun Nov 03, 2019 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: access control objects
Replies: 25
Views: 3601

Re: access control objects

As an admin go into the }processsecurity cube and find that TI process - then put READ in the cell that corresponds with a security group that the user belongs to.
You can also right click on processes and go to security that way for the same purpose.
by declanr
Sun Oct 13, 2019 11:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and Process Ends msg
Replies: 16
Views: 10953

Re: RunProcess and Process Ends msg

I handle this by having the master process create a text file in a folder and pass the name of that file to the sub process (doing this for ever sub process it runs.) The last line of the sub process deletes the file. At the end of the master process it loops the folder counting the files that exist...
by declanr
Sun Sep 15, 2019 8:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 2118

Re: adding button to pax sheet and publish in paw

Also one omre question in perspectives i am able to edit the action button properties by right clicking the button and properties .But in PAX once I add the button ,I am not able to edit to change any settings. I checked in design mode and also right clicking not giving the same option For buttons ...
by declanr
Thu Sep 05, 2019 8:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make a server instance available in Tm1 web
Replies: 3
Views: 1291

Re: How to make a server instance available in Tm1 web

It sounds like you have used the server parameter in the web config file. If you remove it (leave it blank) then the drop down box will appear. You will need to restart the web service after changing the config file.
by declanr
Fri Aug 23, 2019 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export list of System Names
Replies: 4
Views: 7944

Re: Export list of System Names

You can get them from the }externals folder in your data directory.
by declanr
Thu Aug 22, 2019 10:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading fields from csv without knowing the type of value
Replies: 6
Views: 7673

Re: loading fields from csv without knowing the type of value

You could completely automate this but it becomes risky in case the CSV comes in as complete garbage one time and you could end up with it creating the measures etc anyway. But create a process to handle however many columns you expect plus an extra 10 or so (all set as string - other) Have a new pr...
by declanr
Fri Jul 26, 2019 7:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace an element with same name and different case
Replies: 7
Views: 921

Re: Replace an element with same name and different case

If that element is not at the lowest level then should i back up the data . I am renaming Region 1. Will I be able to delete Region1 with out deleting the customer data under it ? So hierarchy is like All Regions-> Region 1 ->Agency ->Customer Numeric data is stored at the lowest level and consolid...
by declanr
Fri Jul 19, 2019 6:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Workspace Conditional Formatting Leaf level
Replies: 2
Views: 766

Re: PA Workspace Conditional Formatting Leaf level

Some people on here may be horrified by the thought of this but I have been able to apply pretty much any formatting I want by adding additional measure elements to the cube and applying rules to those elements - in this case I would make it 0 if either the condition is achieved or it’s not n-level....
by declanr
Tue Jul 16, 2019 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Button does not give RUN Process option
Replies: 5
Views: 709

Re: PAW Button does not give RUN Process option

To add to Wim's point - the ability to run processes from buttons in Workspace only got added in PAW 39 which was released in March. In earlier versions you will still need to add an action button to a websheet via PAX and then load that into your PAW book. https://www.ibm.com/support/knowledgecente...
by declanr
Mon Jul 15, 2019 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw - Synchronise Sandboxes
Replies: 3
Views: 824

Re: Paw - Synchronise Sandboxes

Hi, Done a quick test myself and it seems ok - I must admit that sandboxes are something that haven't often been used in models I have developed/worked on - the functionality seems ok in my set up that I have at the moment though. What version of PA and PAW are you on? Also does the synchronisation ...
by declanr
Sat Jul 13, 2019 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw - Synchronise Sandboxes
Replies: 3
Views: 824

Re: Paw - Synchronise Sandboxes

If they are on different tabs you need to also set the synchronisation scope to book instead of sheet.
by declanr
Thu Jul 11, 2019 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Save MDX based Subset for Clone Dimension
Replies: 3
Views: 726

Re: How to Save MDX based Subset for Clone Dimension

Have a TI process loop through the subsets in the source dimension. For each subset use the MDXGet functionality; if it returns something then use scan/substring to replace the dim name references (1 subset might reference it multiple times) then create subset in the target with a createbymdx. If th...
by declanr
Wed Jul 10, 2019 6:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Cannot see the dimension or processes
Replies: 3
Views: 601

Re: PAW Cannot see the dimension or processes

You need to be defined as a modeler or administrator in Workspace. This is above and beyond and security set in tm1 for the model. The workspace administrator who set you up can do this.
by declanr
Mon Jul 01, 2019 9:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO Process
Replies: 11
Views: 1549

Re: ODBO Process

Bit difficult to sort this kind of thing out without access to the system and a bit of trial and error. But one “workaround” solution would be that if your account dimension is always a certain number of characters then to use a substring which feeds the cellputn. This can also work if it’s not a se...