TM1 Forum

99% of the time they will be exactly the same results. However, if you had an element and subset with the same name - it would return the element instead of the subset... so using SubsetToSet makes sure that it returns the subset. It’s probably good practice to be as explicit as possible of what you...

Noticed that it’s only your app gateway that has failed. Have you done the install using the latest PA software that has web as a separate install? If so by default both web and app server run on port 9510; which means starting one stops/causes issues with the other. If so easiest thing to do is cha...

Hi, Union can only handle the joining of 2 statements. But you can nest Unions. e.g. {UNION( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( { [ ' | vDim1 | ' ].[ ' | vEl | ' ] }, ALL, RECURSIVE )}, 0)}, {Union ( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( { [ ' | vDim1 | ' ].[ ' | vEl2 | ' ] }, ALL, RECURSIVE ...

After you have selected Default in BOTH the Source and target it will provide you with additional dropdown boxes underneath each where you can select your source and target TM1 services. These dropdown boxes are only visible AFTER you select the Environments.

Since the introduction of Alternative Hierarchies I believe the best solution is to have a single continuous time dimension and then use alternative hierarchies to split it into Year and Month. That way you can utilise the same cubes in different ways; meaning you can get the benefit of each option ...

Generally speaking I would suggest if possible that you store the date as a numeric cell in TM1 and just format it to look like a date; generally that makes most things a lot easier. That being said since you currently have it as a string; I would start by converting your string to a number ( ParseD...

I believe workspace groups were introduced in 2.0.42 There is no configuration required to enable it; if you were on a version that included it you would see the options by default. And as Moby has highlighted, at the moment it is not linked to AD etc. The groups are created and exist just within Wo...

I must admit that I haven't looked at or used scorecards for quite a long time. However, if memory serves the "status" is just a measure in your cube - so you could have MDX subsets that filter your driver dimension for each possible status (e.g. 1 subset for Excellent, 1 for Poor etc.) then just ch...

PlanningDev wrote: ↑

Wed Jul 01, 2020 11:49 pm

Unable to select control objects as source in a TI

They have actually sorted this one now - not sure what release it came out in but you now have a drop down in the TI Data Source to swap between Control Objects or a Standard Object.

https://ibb.co/gMY8PDh

So do I understand correctly that you then have to rebuild the 'synchronisation' bit of the selector widgets by making cube views refer to this }clients param dim with MDX subsets (i.e.filter the country list to whatever is in that cube for this user)? Yup, just saw the video. I love this approach,...

Do you think that we can completely get away with TM1 architect for development and adopt PAW? What is its future prospects? Thanks! I will answer this question purely from the development point of view that you have asked. I honestly think that I could. I do the majority of my development directly...

Can you connect from the same machine that PAW is running on? Or try and do an ipconfig on the PAW server and then see if you can connect with the IP address rather than the server name. In power shell on the paw server run ./scripts/admintool.ps1 in the admin tool window that opens up; go to Status...

Although an element can exist in a single hierarchy/dimension with multiple parents; the element's primary key is its name - as such it cannot have different calculations for the same intersection (where the only difference is a different parent) - you can do it on other intersections; such as a dif...

PA on demand is a different kettle of fish altogether; it is very much intended to handle individual smaller models - think of those large excel workbooks people might maintain on their own machines but having the ability to utilise PA functionality instead. There is the "Digital Pack" which is sort...

Before the process has finished; a chore etc has kicked off another process that has caused contention (often a savedatall function) which then means that all transactions from your Master Process and its Sub Processes have rolled back and then started again when it has a clean window to do so.

There are a number of things that you can’t quite do with the synchronisation- such as what you have highlighted and another common one of selecting an element in 1 dimension; such as a Country Code in a country dimension and seeing its corresponding element selected in another dimension e.g all Sto...

sFind = '- '; nLong = Long ( vsString ); iPos = nLong - 1; nFound = 0; While ( iPos > 0 & nFound = 0 ); sSub = SubString ( vsString, iPos, 2 ); If ( sSub @= sFind ); nFound = 1; Else; iPos = iPos - 1; EndIf; End; If ( nFound = 0 ); LogOutput ( 'INFO', 'Could not find country in string: ' | vsString...

If you select “1” after it shouldn’t be there do you at least get an error saying it’s not a valid selection?

If IBM mentioned it as a known defect did they give you a reference number for it?

A cells picklist should be re-evaluated every time you use it; so you shouldn’t see any values that are not in the linked subset or the value already in the cell.

Are you sure there isn’t still an old excel data validation list on the cell or something like that?