Search found 1496 matches

by declanr
Wed Apr 11, 2018 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"
Replies: 6
Views: 175

Re: prevent the user from reading the machine name when calling "tm1web" and "pmpsvc"

You can change the hosts file on the users PCs. Assuming the security is quite locked down that could easily be done by IT en masse and the users wouldn’t be able to access the file to see the contents. If you haven’t worked with a hosts file before it’s simple and just has an address for what you t...
by declanr
Fri Mar 30, 2018 9:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 service restart times
Replies: 2
Views: 544

Re: TM1 service restart times

Haven’t seen this in a while but the transaction logs used to be a big culprit of this. Obviously when a server goes down unexpectedly it may not have saved transactions to disk so when it starts back up it searches through the transaction logs - if you have some beastly files in there it can take a...
by declanr
Wed Mar 28, 2018 3:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1TOP not working - Planning Analytics -2.0
Replies: 4
Views: 380

Re: TM1TOP not working - Planning Analytics -2.0

Must admit I’ve not used tm1 top in a while but if you’ve copied from an old version I would guess that your ssl certs could be out of sync.
by declanr
Fri Mar 23, 2018 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Date held as number but formatted as date
Replies: 5
Views: 648

Re: Date held as number but formatted as date

TM1s default date starts I think in 1960 whereas Microsoft is 1900 or something like that.
TM1 introduced a CFG a while ago called UseExcelSerialDate (I think) that will make the two align.
by declanr
Wed Mar 21, 2018 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Restrict non-admin users to create public views and public subsets
Replies: 2
Views: 230

Re: Restrict non-admin users to create public views and public subsets

By default they should already be restricted, a non admin user should only be able to create private subsets/views.
by declanr
Mon Mar 19, 2018 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 524

Re: MDX filter on cube values for different dimension

Noticed this again this morning and realised that PavoGa was on to something, the below will work and be more efficient that generate if your dimensions are large.

Code: Select all

{Filter(
	{[dim2].members},
	[cub1].( StrToMember ( "[dim1].[" + [dim2].[attr_dim1_elm_name] + "]" ),[cub1_measure].[value])>1
	)}
by declanr
Sun Mar 18, 2018 4:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to add validation error message for users?
Replies: 3
Views: 278

Re: How to add validation error message for users?

If the mapping will never change you can put an attribute on dimension B saying which element it maps to from A (this is really a mapping dive anyway) and/or you can have consolidations of element A in dim b but without really understanding the relationship of what these dims are it’s hard to say wh...
by declanr
Fri Mar 16, 2018 8:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help
Replies: 11
Views: 665

Re: TM1 Active Form is returning Zeros even when suppress zero is set to True/1. Please help

Apologies to ask a basic question but it is actually something Willi has asked twice in this thread and unless I am missing it I can't see an answer... is the issue that a row containing all zeroes is still showing? Or are you expecting a column containing all zeroes to be hidden? If its the latter,...
by declanr
Fri Mar 16, 2018 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }CellSecurity
Replies: 8
Views: 610

Re: }CellSecurity

Wim Gielis, thank you for the hint about TI. I understand the purpose, but not sure how it works. Is the functionality the same as if it was a CellSecurity cube without "}", and security from it should be ruled to the other cubes (I don't see any rules that refer to it), or it actually automaticall...
by declanr
Fri Mar 16, 2018 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter on cube values for different dimension
Replies: 6
Views: 524

Re: MDX filter on cube values for different dimension

The below code first filters to get all the elements in dim1 that match your criteria of exceeding a value of 1 in the cube. It then uses the generate to do a while loop of those elements and for each of those; dim2 is filtered to where the attribute matches the dim1 element name. Note that due to t...
by declanr
Wed Mar 07, 2018 5:05 pm
Forum: Useful code, tips and tricks
Topic: Using Dates And Times In TM1
Replies: 24
Views: 46220

Re: Using Dates And Times In TM1

Do you mean create 2 numeric measures in tm1 and format these as dates? I did mean that - you would format them using the element attributes. If so I am not holding the start and end dates in TM1 I am just using the start and end date to drive some logic in the TI process. So these dates only exist...
by declanr
Wed Mar 07, 2018 2:48 pm
Forum: Useful code, tips and tricks
Topic: Using Dates And Times In TM1
Replies: 24
Views: 46220

Re: Using Dates And Times In TM1

Incidentally I got round the problem of validating the dates by validating them on the websheet, so I have a new parameter, pValidDate and if a cell on the websheet shows invalid the process errros saying the dates are invalid! You could just have them input to a numeric cell that is formatted as a...
by declanr
Wed Feb 21, 2018 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add CAM Users
Replies: 5
Views: 302

Re: Add CAM Users

Hi Jim, When you go to add users and the CAM screen comes up there should be a tick box in the top left that says "Show users in the list", if you tick that then you should be able to find the CAM users. Its annoying that this isn't ticked by default since you have already told it that you are wanti...
by declanr
Mon Dec 18, 2017 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web 10.3. - Date Picker?
Replies: 1
Views: 245

Re: TM1 Web 10.3. - Date Picker?

10.3 was the first PA cloud offering. So it’s available in cloud or any on premise PA version.
Simple to set up; it just automatically makes any date formatted numeric cell in TM1 Web a date picker.
by declanr
Wed Dec 13, 2017 6:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 687

Re: Change in Element Name of a frequently used Dimension

I have never had a problem with swapping the alias in as long as you do it carefully. You start with an element called “sprouts” and give it an alias called “turkey”... for TM1 to allow this in the first place you know that there can’t have been any other elements named either Sprouts or Turkey so t...
by declanr
Sat Dec 09, 2017 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 918

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

One more option is that the work in excel could be a red herring.
I believe if a user pressed an action button when they don’t have access to run the TI; you don’t see any messages in the log... would be nice to see a “Bob can’t run TI x” but at the moment I don’t believe we get that.
by declanr
Tue Dec 05, 2017 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create view consisting of C elements
Replies: 4
Views: 324

Re: Create view consisting of C elements

It’s also worth noting that by default TIs skip consolidated records as normally we don’t want to use them as a source.

On the occasions that you do want to use consolidations, you need to let the TI know by using code as below:

Code: Select all

ViewExtractSkipCalcsSet ( <MyCube>, <MyView>, 0 );
by declanr
Wed Nov 22, 2017 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sum on TM1 Cube
Replies: 5
Views: 483

Re: Sum on TM1 Cube

Create a cube (as Paul suggested) with an extra dimension for "client" - this cube can contain all the same other dimensions as the cube in your screenshot and then is simply update by rules that say if the client measure in source cube for "Cliente" is equal to the client element in your dimension ...
by declanr
Mon Oct 30, 2017 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Child Elements are not visible under consolidations
Replies: 14
Views: 648

Re: Child Elements are not visible under consolidations

What tab did you run the dimensionsortorder on?