Search found 1577 matches

by declanr
Wed Mar 25, 2020 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List of subsets created
Replies: 8
Views: 1918

Re: List of subsets created

I can’t remember the exact version when it was introduced but for quite a while now there have been standard system dimensions that list all of the subsets for each dim and views for each cube. The dimension name would be }subsets_<yourdimname> and it just contains all of the subset names as element...
by declanr
Fri Mar 20, 2020 10:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DatasourceUsername and DatasourcePassword
Replies: 2
Views: 134

Re: DatasourceUsername and DatasourcePassword

At 1 of my previous clients the DSN we used was set to use windows authentication (somehow not quite sure how) so with that 1 we just provided the DSN name without user or password and it took it from the system account that was running the service. Sounds like the set up you have could be similar?
by declanr
Wed Mar 18, 2020 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Modeler and security
Replies: 6
Views: 543

Re: Performance Modeler and security

If you create an element security cube for any dimension then the default assumption is that every group has no access to an element unless you specify otherwise. If you have a multi group environment we normally get around this by having 1 or 2 base groups in addition to the more detailed groups. E...
by declanr
Tue Mar 17, 2020 5:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hold and Proportional Spread
Replies: 6
Views: 214

Re: Hold and Proportional Spread

Like the others have said actual code would be could but assuming the pseudo code you have provided is correct then I expect your data source is the problem. As I understand it: 1/ You clear out holds on the cell (so that the proportional spread doesn't fail) 2/ You proportionalspread a data cell 3/...
by declanr
Thu Feb 13, 2020 8:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 551

Re: RunProcess, parameters and NOW bug

I've edited the above post a few times already as I keep thinking of extra steps to test. If I pass 1.2344567778 * 1000000 from the parent process it gets truncated in the child's asciioutput. So its as if the runprocess seems to back trace any numeric value to its starting point and assess whether ...
by declanr
Thu Feb 13, 2020 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess, parameters and NOW bug
Replies: 6
Views: 551

Re: RunProcess, parameters and NOW bug

It's an interesting one and I thought that gtonkin was on the right path so I did a test myself with below processes: Parent: cProcChild = 'Child'; nNow = Now; AsciiOutput ( 'c:\Parent.txt', NumberToString ( nNow ) ); nNowMega = nNow * 1000000; RunProcess ( cProcChild, 'pnNow', nNow , 'pnNowMega', n...
by declanr
Sun Feb 02, 2020 7:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 409

Re: String size limit of a parameter in a TI

For the strings you are passing I wonder if there are any special characters? The sizes don’t seem likely to be a problem but maybe the content is doing something spurious.
by declanr
Sun Feb 02, 2020 7:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter with IIF and Count MDX
Replies: 3
Views: 485

Re: Filter with IIF and Count MDX

At the moment the MDX primer is a great starting point. Once you’ve got your head around that and the basics I find you have an idea of what you are looking for googling tends to take you to the standard Microsoft MDX docs which can then be a pointer in the right direction - for example I guessed th...
by declanr
Fri Jan 31, 2020 10:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Filter with IIF and Count MDX
Replies: 3
Views: 485

Re: Filter with IIF and Count MDX

First thing to consider when using IIF is what type of result we will get from the THEN and ELSE. I'm sure you've looked at the MDX Primer for this (as I did a while ago when having a similar requirement) and found the example relating to the IIF being used to decide whether to filter by the top 5 o...
by declanr
Sat Jan 25, 2020 7:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Sets to Cloud Integration
Replies: 3
Views: 805

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: 659

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: 558

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: 558

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: 278

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: 4563

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: 4563

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: 20
Views: 13570

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: 2275

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: 1415

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: 8200

Re: Export list of System Names

You can get them from the }externals folder in your data directory.