Search found 705 matches

by rmackenzie
Thu Jul 30, 2015 7:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide Rules From Users?
Replies: 4
Views: 1316

Re: Hide Rules From Users?

This is definitely vote-worthy, however have you considered the rule trace functionality? Thinking about this might help you frame your enhancement request. What I mean is that whilst it may be desirable to remove the ability to view rules for all non-Admin users, it may still be useful for any user...
by rmackenzie
Thu Jul 30, 2015 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element-ghost
Replies: 9
Views: 2729

Re: Element-ghost

lotsaram wrote:... if {[dimension].[subset]} is used in an MDX set expression then the list of elements in the subset it returned.
You can use TM1SubsetToSet to code around the ambiguity generated by this idiosyncrasy, e.g.:

Code: Select all

{ TM1SubsetToSet ( [DIMENSION_NAME], "SUBSET_NAME" ) }
by rmackenzie
Wed Jul 29, 2015 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine if an element is a member of a subset
Replies: 4
Views: 1890

Re: Determine if an element is a member of a subset

Alan, it took me (more than) a few goes to get there, but finally I got my vote in. :roll: A comment on the use case however: Rather than offer one of my own I'll refer to one that Duncan Turner submitted to Applix on 19 May 2005 (coming up to 10 years ago), for users the world over have had the sam...
by rmackenzie
Tue Jul 21, 2015 2:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sending email using TI process
Replies: 11
Views: 4286

Re: Sending email using TI process

If you are struggling with that go the easier route and download something like sendmail.exe or BLAT; then all you have to do is pass parameters to the executable. Nowadays, the Powershell option is much easier as it is a default install for a modern Windows OS and has in built e-mail capabaility t...
by rmackenzie
Tue Jul 07, 2015 4:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Extract each character from an element
Replies: 17
Views: 2787

Re: Extract each character from an element

Ah, I misread it. So, create a dimension called 'Alphabet' with elements a-z. Create an attribute called 'Scramble Letter' and enter the appropriate user-defined substitute letter against the element. Then, the TI would be: vGroupID = CellGetS('Cube_Name',e1, e2, e3...,'GRP_ID'); vLenOfGroupID = LON...
by rmackenzie
Tue Jul 07, 2015 3:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Extract each character from an element
Replies: 17
Views: 2787

Re: Extract each character from an element

So your code table is this: a b c d e f g h i j k l m n o p q r s t u v w x y z C D E F G H I J K L M N O P Q R S T U V W X Y Z A B And, for any input character with an ASCII value of x, then it's scrambled character will be the ASCII character given by x-30. Therefore your TI should be: vGroupID = ...
by rmackenzie
Tue Jul 07, 2015 2:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation Calculation Performance Issues
Replies: 2
Views: 1000

Re: Consolidation Calculation Performance Issues

RJ, sorry, can't speak to your question... but:

Code: Select all

[] = C:
Is a massive red flag.
by rmackenzie
Mon Jul 06, 2015 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to identify language settings
Replies: 7
Views: 1534

Re: How to identify language settings

They are in the cfg file, I know, but we can not be sure the cfg file will always be in the same subdirectory. You can quickly grab a config setting from the tm1s.cfg as long as you know the name of the Windows service running the TM1 instance, and then use this Powershell script: $service_name = $...
by rmackenzie
Sat Jul 04, 2015 5:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Extract each character from an element
Replies: 17
Views: 2787

Re: Extract each character from an element

... the requirement specifically wants to see the data in scrambled format. The process of displaying the data this way is being fulfilled by another system currently and I've been asked to emulate the same setup using TM1. I have no other choice but to display scrambled data. I would suggest a Vig...
by rmackenzie
Mon Jun 29, 2015 2:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Timst bug
Replies: 2
Views: 1031

Re: Timst bug

stex2727 wrote:Is this a bug?
No - \m is month. You should use \i for seconds. You are getting 01 for the month because it is defaulting to 1960-01-01. Try it like this:

Code: Select all

rough18Sec = (18 / 86400);
asciioutput ( '_test.txt', TIMST ( rough18Sec, '\Y\m\d\h\i\s' ) );
by rmackenzie
Sat Jun 27, 2015 1:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to get Surrogate Element from Primary
Replies: 15
Views: 2832

Re: MDX to get Surrogate Element from Primary

Thanks Robin, this looks similar to what I was trying to achieve but could not. I am however getting the following error which I am unable to correct: TM1 Error: GENERATE: Error in value expression: STRTOMEMBER: Error in value expression: Yes, the culprit would any spaces in the element name - so y...
by rmackenzie
Fri Jun 26, 2015 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to get Surrogate Element from Primary
Replies: 15
Views: 2832

Re: MDX to get Surrogate Element from Primary

Works perfectly - My dimension has an extra level added but using ...CurrentMember.Parent.Parent.Properties... I get the much required result. No worries - but note the issue raised below in case your dimension structure changes. What happens ... with alternate hierarchies, does it still work? Alte...
by rmackenzie
Fri Jun 26, 2015 5:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to get Surrogate Element from Primary
Replies: 15
Views: 2832

Re: MDX to get Surrogate Element from Primary

Try this:

Code: Select all

{ Filter(
  { TM1FilterByLevel( { TM1SubsetAll( [Company] )}, 0 )},
  [Company].CurrentMember.Parent.Properties("Surrogate") = [Company].CurrentMember.Name
)}
Does that work?
by rmackenzie
Fri Jun 19, 2015 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionDeleteAllElements Issues
Replies: 10
Views: 2194

Re: DimensionDeleteAllElements Issues

Perhaps try changing the option in the chore dialog?
by rmackenzie
Wed Jun 17, 2015 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 VBA param
Replies: 4
Views: 1387

Re: TM1 VBA param

pParam = Range("B2").Value bCheck = ExcecuteProcess(sServer, sProcess, pParam) It's probably worth noting that the VBA process Ex c ecuteProcess (or quite possibly ExecuteProcess) is not part of standard TM1 The apparent typo actually gives away that the OP is probably trying to run the code that d...
by rmackenzie
Sun Jun 14, 2015 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Rule not working the same in 10.2 as 9.5.1
Replies: 6
Views: 1776

Re: Cube Rule not working the same in 10.2 as 9.5.1

I guess that the OP has their financial periods coded as 01, 02, 03 ... 11, 12 so the comparison has always worked, e.g.

Code: Select all

="03"<="11"
resolves to TRUE, even though:

Code: Select all

="3"<="11"
does not.

I assume something like this regularly does the rounds at IBM.
by rmackenzie
Sat Jun 13, 2015 6:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Rule not working the same in 10.2 as 9.5.1
Replies: 6
Views: 1776

Re: Cube Rule not working the same in 10.2 as 9.5.1

Your code is flawed because you are testing using @<= instead of <=. Testing numeric inequality on strings exposes you to a lot of problems to do with sort orders/ character encoding etc. I'd suggest you re-code this logic like so: ['Open Forecast', {'USD Translation Rate', 'USD Actual Rate'}] = N: ...
by rmackenzie
Thu May 14, 2015 2:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Has anyone built Generic/Flexible Cubes?
Replies: 6
Views: 2112

Re: Has anyone built Generic/Flexible Cubes?

Multiple choice question: you work in a pasta restaurant and every day you arrive for work and the pot of spaghetti and pot of bolognese are bubbling away - the night chefs left it that way for you. Every day you serve up bowl after bowl of spaghetti and bolognese to hungry customers. You have so ma...
by rmackenzie
Wed May 06, 2015 7:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CAFE under 10.2.2 FP3
Replies: 4
Views: 1554

Re: CAFE under 10.2.2 FP3

RJ! wrote:The MDX used:

Code: Select all

TM1SORT(HIERARCHIZE(TM1FILTERBYLEVEL(TM1SUBSETALL([Account]) , 0)) , ASC)
Why would you try and hierarchize a set of elements that are all at the same level?

Over the 200,000 elements eliminating this overhead may make a noticeable difference.
by rmackenzie
Mon Apr 27, 2015 8:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX in ActiveForm with "INSTR" does not work
Replies: 8
Views: 2562

Re: MDX in ActiveForm with "INSTR" does not work

I created a MDX-Statement, that works in the Subset editor and gives results, but does not work in an activeForm. Does it only work in the subset editor when you have the alias actually turned on? If it doesn't work in the subset editor when aliases are off then at least you know it's consistent wi...