Search found 705 matches
- Thu Jul 30, 2015 7:39 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hide Rules From Users?
- Replies: 4
- Views: 4668
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...
- Thu Jul 30, 2015 7:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Element-ghost
- Replies: 9
- Views: 9946
Re: Element-ghost
You can use TM1SubsetToSet to code around the ambiguity generated by this idiosyncrasy, e.g.:lotsaram wrote:... if {[dimension].[subset]} is used in an MDX set expression then the list of elements in the subset it returned.
Code: Select all
{ TM1SubsetToSet ( [DIMENSION_NAME], "SUBSET_NAME" ) }
- 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: 5972
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...
- Tue Jul 21, 2015 2:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sending email using TI process
- Replies: 11
- Views: 18216
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...
- 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: 13971
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...
- 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: 13971
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 = ...
- Tue Jul 07, 2015 2:22 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Consolidation Calculation Performance Issues
- Replies: 2
- Views: 3436
Re: Consolidation Calculation Performance Issues
RJ, sorry, can't speak to your question... but:
Is a massive red flag.
Code: Select all
[] = C:
- Mon Jul 06, 2015 12:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to identify language settings
- Replies: 7
- Views: 6488
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 = $...
- 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: 13971
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...
- Mon Jun 29, 2015 2:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Timst bug
- Replies: 2
- Views: 3550
Re: Timst 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:stex2727 wrote:Is this a bug?
Code: Select all
rough18Sec = (18 / 86400);
asciioutput ( '_test.txt', TIMST ( rough18Sec, '\Y\m\d\h\i\s' ) );
- 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: 12926
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...
- 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: 12926
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...
- 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: 12926
Re: MDX to get Surrogate Element from Primary
Try this:
Does that work?
Code: Select all
{ Filter(
{ TM1FilterByLevel( { TM1SubsetAll( [Company] )}, 0 )},
[Company].CurrentMember.Parent.Properties("Surrogate") = [Company].CurrentMember.Name
)}
- Fri Jun 19, 2015 12:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DimensionDeleteAllElements Issues
- Replies: 10
- Views: 8383
Re: DimensionDeleteAllElements Issues
Perhaps try changing the option in the chore dialog?
- Wed Jun 17, 2015 11:19 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 VBA param
- Replies: 4
- Views: 5594
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 c...
- 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: 5955
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.
resolves to TRUE, even though:does not.
I assume something like this regularly does the rounds at IBM.
Code: Select all
="03"<="11"
Code: Select all
="3"<="11"
I assume something like this regularly does the rounds at IBM.
- 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: 5955
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: ...
- 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: 6722
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...
- 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: 4713
Re: CAFE under 10.2.2 FP3
Why would you try and hierarchize a set of elements that are all at the same level?RJ! wrote:The MDX used:Code: Select all
TM1SORT(HIERARCHIZE(TM1FILTERBYLEVEL(TM1SUBSETALL([Account]) , 0)) , ASC)
Over the 200,000 elements eliminating this overhead may make a noticeable difference.
- 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: 11
- Views: 15584
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...