Search found 1395 matches

by Steve Rowe
Fri Jul 20, 2018 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 4
Views: 73

Re: Calling DBRW function without mentioning instance name in the first argument

A use case for this is also to allow migration of application workbooks from Dev to live. You can use the TM1User function to determine which instance from a known list of instances you are connected to. A1= TM1User("Dev") A2= TM1User("UAT") A3= TM1User("Prod") B1=A1 B2=If(A2="",B1,A2) B3=If(A3="",B...
by Steve Rowe
Fri Jul 20, 2018 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Journal validation - account combinations
Replies: 6
Views: 87

Re: Journal validation - account combinations

Depends on the volume of data but I would still be inclined to merge my AB, AC, AD combos into one long ABCD valid combination dimension. Then I would only have one test to perform in my data load. Also if I am allowing direct entry to my data cube for budget purpose for example, then having the val...
by Steve Rowe
Fri Jul 20, 2018 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Journal validation - account combinations
Replies: 6
Views: 87

Re: Journal validation - account combinations

I think you are saying that I have 4 dimensions (A, B ,C and D). Only certain combinations of !A, !B, !C and !D are valid. How do I manage / track / validate this. I'd have a dimension called Valid Code Combination that was a concatenation of the valid combinations of A, B, C and D I'd then test aga...
by Steve Rowe
Thu Jul 19, 2018 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Azure VM Type for Planning Analytics
Replies: 9
Views: 189

Re: Best Azure VM Type for Planning Analytics

Mike, Prepare to be amazed...

https://www-01.ibm.com/software/passpor ... olicy.html

Don't believe ILMT is required in Azure, though there are some mysterious caveats around the cloud being supplied by a third party.

I'm not an IBM license lawyer though...
by Steve Rowe
Fri Jul 13, 2018 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing TM1 formulae from a sheet
Replies: 2
Views: 101

Re: Removing TM1 formulae from a sheet

http://www.tm1forum.com/viewtopic.php?t=2515

I'm pretty sure the forums TM1 Tool add in as some code for stripping out TM1 formula when they are nested, its pretty old though and may not play well with PAx
by Steve Rowe
Fri Jul 13, 2018 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 382

Re: Check if the data of two cubes are the same

A couple of thoughts 25 dimensions in a cube is pretty unusual, are you sure you have the design right or consider hierarchies in the latest release. As to your actual problem How about using DOS to compare the .cub files on the disc, I've never tried this so I'm assuming that two identical cubes at...
by Steve Rowe
Fri Jul 06, 2018 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parameter in TI process
Replies: 8
Views: 259

Re: Parameter in TI process

Hi Pluto, welcome,

(This assumes you mean parameters rather than variables as defined in a TI process)

The short answer they should be whatever you need them to be...
Typically for the scenario you describe they will be some of the dimensions of the source cube, i.e. time and version
by Steve Rowe
Fri Jun 22, 2018 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx, authenticating with CAM and mutiple instances
Replies: 0
Views: 82

PAx, authenticating with CAM and mutiple instances

Hi, We've a client UATing PAx and we are having an erratic issue with the PAx client where the authentication is not persisting. They are using CAM authentication / Mode 5. What should happen is that when you log into a single instance, you do not need to log into all the other instances as your cli...
by Steve Rowe
Fri Jun 22, 2018 8:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with feeders
Replies: 7
Views: 291

Re: Issue with feeders

Also agree this should be working.
Maybe do a rule trace on the zero consolidation and just check that there is no rule applying?
by Steve Rowe
Sat Jun 16, 2018 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Subset Alias Turned Off After Dimension Rebuild
Replies: 4
Views: 415

Re: Public Subset Alias Turned Off After Dimension Rebuild

I expect the alias is being recreated during the rebuild rather than just refreshed. Look the function attrdelete function and comment it out. If you have used the TI wizard you need to change the settings relating to the attribute.
by Steve Rowe
Tue Jun 12, 2018 5:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 505

Re: How to reference data lines as variables in TI?

Interesting I had not noticed that issue, though I am nearly always using Expand with text rather than numbers. Thanks for raising. Love the way that IBM document the defect so they don't have to treat it as a defect because it is documented, that seems to be a fairly recent addition to the document...
by Steve Rowe
Tue Jun 12, 2018 11:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 505

Re: How to reference data lines as variables in TI?

You need to use Expand to translate your string reference to an indirect variable reference. sInputColl = Expand('%Coll' | numbertostring(X) | '%'); #Expand returns a string (or do it all on a single line) nInputColl = StringToNumber(sInputColl); So if Coll10 contain the value 99, when X=10 nInputCo...
by Steve Rowe
Fri Jun 08, 2018 12:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 462

Re: Dimension subset editor in TM1 Perspectives

AS Wim points out this behaviour does vary by version....
by Steve Rowe
Fri Jun 08, 2018 11:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension subset editor in TM1 Perspectives
Replies: 9
Views: 462

Re: Dimension subset editor in TM1 Perspectives

The other reason that the subnm double click often fails is that people often try and reference another cell to get the server name, this will stop the double click from working.

=Subnm("Server:Dimension",....

works

=Subnm( A1 & ":Dimension",....

will not work
by Steve Rowe
Fri Jun 08, 2018 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking Element Level Security in a TI processes
Replies: 6
Views: 347

Re: Checking Element Level Security in a TI processes

You could take this a step further. 1. Set up a subset that uses the MDX. 2. Create a "Front end cube", dimension by }Clients and a dimension with the various parameters. 3. Give the parameter list a pick list attribute and assign the MDX subsets. 4. Remove the parameter from the TI and read it from...
by Steve Rowe
Thu Jun 07, 2018 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: C Level Rules with attributes evaluations in N level elements
Replies: 5
Views: 363

Re: C Level Rules with attributes evaluations in N level elements

[ 'Capital', 'Real' ] =C: IF ( # With the following 3 lines i am trying to ensure the element for time dimension correspond to the C level element that i need: ( DType ( 'Month', !Month ) @= 'C' ) & ( ElIsAnc ( 'Month', 'QTD', !Month ) = 1) & ( Ellev ( 'Month', !Month ) = 1) # With the folowing 4 l...
by Steve Rowe
Sat Jun 02, 2018 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Invalid string
Replies: 4
Views: 320

Re: Invalid string

This issue often happens because the wizard in the data tab assumes that every field that contains a number is a numeric variable type. So your year field will often end up as a numeric variable. This then causes syntax errors at a later stage.
So check the data tab basically.
by Steve Rowe
Fri Jun 01, 2018 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW / PAX performance discussion
Replies: 7
Views: 687

Re: PAW / PAX performance discussion

Excellent, great news!
by Steve Rowe
Fri Jun 01, 2018 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW / PAX performance discussion
Replies: 7
Views: 687

Re: PAW / PAX performance discussion

Hi Robster,

I've noticed the lag in dragging panes as well. Can I ask if you are using PAW through a RDP session connecting to a remote location? I have found that this seems to be the main contribution to the lag rather than PAW itself?

Cheers,