TM1 Forum

It's not something that I've noticed happening yet. What version of PAFE are you using? Have you checked the named ranges to make sure they are covering the other columns? I know normally it would just expand to cover everything without intervention but wondering if something has changed where it ne...

Hi, Your issue stems from the fact that with a StrToMember function you are telling it that the member DOES exist; so when it doesn't find it the system will throw an error. A set can be "empty" but a member can't be. The idea of doing a COUNT with IIF is a good one but the count needs to ...

In the latest versions of PAW you would right click on the row header and then select "Format Manager" > "Header" - in the screen that pops up you can select "Wrap Text without Line Break" or "Wrap Text with Line Break" (assuming its unlikely you have line bre...

Presumably in your TI process it is using the DimensionElementComponentAdd function (or HierarchyElementComponentAdd - the logic is the same) where you specify the parent and child elements that will form the relationship, the number at the end of that function is the weight which will be applied to...

How long did you wait to see if it started up before going for the reinstall? It's normal for that screen to appear when starting the PAW services and can remain there for a while if the server doesn't have a lot of resources. What are the specs of the server you are installing it on? And is there a...

Interesting I will cede to standing knowledge if the DB is usually significantly slower. I was basing it on a fairly small test case I had done (all in one model) where there are a lot of hierarchies with same named elements (between hierarchies and dimensions unfortunately) - so it probably skewed ...

It does look redundant. The only reason I can think of to write the rule that way would be if you wanted to keep the cell editable so users can add a value in this cube for the non rule-derived cases. E.g. if a % has been provided in the master cube we will use that one; otherwise users should/can a...

Hi, I don't get why the DB is needed in the above rule, so I was thinking this would be better: Technically it terms of performance DB performs slightly better than shorthand; you are unlikely to notice any difference from changing just 1 rule but it could add up if its every rule in a rule heavy s...

Not the perfect option for the average person just wanting to learn but in terms of wanting to create/contribute to open source projects etc. my understanding is that IBM made access to the "Software Access Catalogue" free for IBM partners at some point over the last few years. I'm not sur...

The DBS formula is cell specific so when you try updating the consolidation it is only trying to update that cell and it finds that it is a consolidation which means it is non updateable. When you manually type into the cell with something like "C" or "S0" you are actually callin...

The difference is a commit step after each of the TIs, or only 1 commit after all TIs are finished. With one potential "gotcha" proviso; it only applies to TI processes which are called from the chore itself. If you have to call (say) an upload process a variable number of times, and ther...

Hi, As you have found; subsets are just a list of members - but it is just a pre-applied "selection" of members within the dimension. The user is still interacting with the dimension; so the second they make any sort of change (e.g. expanding or collapsing a consolidation) they are no long...

If this wasn't a control dimension; you could add a consolidation to the }clients dimension and feed that - feeding a consolidation is essentially just shorthand for feeding every N-level element under the consolidation. However, I would not recommend it with a control dimension (you can add consoli...

The below code concept should work for you. Generate ( {TM1SubsetToSet([<Dim1>].[<Hier1>] , "N_Level_Set" , "Public")}, {StrToMember ( "[<Dim2>].[<Hier2>].[P" + Right ( [<Dim1>].[<Hier1>].CurrentMember.Properties("Member_Name"), 6 ) + "]" )} ) Genera...

I've never used it as an actual element name; but I regularly use "-" as a calculated member in MDX views to create spacing rows and columns.
I've never had any issues with that in PAW or PAFE.

Looking at the requirement I would probably be inclined to just go with a couple of while loops as a simple implementation; then check that the performance is good/acceptable - if its not I would investigate other options. I gather from your query that if the target range is Jan - Dec; the Jan shoul...

Hi,

I haven't used it in a while but there is an "IsDisabled" flag in the }ClientProperties cube.
If you put a 1 in there it should stop the user from being able to connect.

Thanks,
Declan

This is one of those rock and a hard place requirements. It would be impossible for IBM or anyone to say that it is impossible to get viruses or issues in a certain place. Now to run on windows you should exclude it (depending on virus software used) to guarantee a good service level. So then if an ...

I haven’t used the bedrock processes before but looking at the parameters you are passing a 1 to a “temp” parameter. So most likely this is creating the views as temporary views which get destroyed at the end of the thread. In the earliest release that included the temp option it could only be used ...

Good information Declan. In the first code snippet, I would calculate the variance based on the 2 variables above. Less hardcoded elements, shorter code too. Yes, that's what the second code snippet was showing how to do. However, it's only really needed because of the issues that Maren has encount...