TM1 Forum

rmackenzie

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...

rmackenzie

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" ) }

rmackenzie

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...

rmackenzie

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...

rmackenzie

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...

rmackenzie

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 = ...

rmackenzie

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

Code: Select all

[] = C:

Is a massive red flag.

rmackenzie

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 = $...

rmackenzie

... 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...

rmackenzie

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' ) );

rmackenzie

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...

rmackenzie

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...

rmackenzie

Try this:

Code: Select all

{ Filter(
  { TM1FilterByLevel( { TM1SubsetAll( [Company] )}, 0 )},
  [Company].CurrentMember.Parent.Properties("Surrogate") = [Company].CurrentMember.Name
)}

Does that work?

rmackenzie

Perhaps try changing the option in the chore dialog?

rmackenzie

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...

rmackenzie

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.

rmackenzie

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

rmackenzie

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...

rmackenzie

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.

rmackenzie

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...

TM1 Forum

Search found 705 matches

Re: Hide Rules From Users?

Re: Element-ghost

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

Re: Sending email using TI process

Re: Extract each character from an element

Re: Extract each character from an element

Re: Consolidation Calculation Performance Issues

Re: How to identify language settings

Re: Extract each character from an element

Re: Timst bug

Re: MDX to get Surrogate Element from Primary

Re: MDX to get Surrogate Element from Primary

Re: MDX to get Surrogate Element from Primary

Re: DimensionDeleteAllElements Issues

Re: TM1 VBA param

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

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

Re: Has anyone built Generic/Flexible Cubes?

Re: CAFE under 10.2.2 FP3

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