TM1 Forum

As string comparison is not case sensitive ('b'='B'), but Scan is (Scan( 'b', 'B') = 0); and as you are matching on a specific term not a combination of terms (i.e. sCode = 'B' should pass but sCode = 'BC' should fail) I would go with: If( Scan( '<' | Upper( sCode) | '>', '<A><B><C>') > 0) Include ...

I have not tested this, but one possible way around this is to build a temporary subset and use the SubsetElementGetIndex function instead of DIMIX against the base dimension.

This change might have come in an earlier 2.0.x and not in 2.0.7. Is anyone able to confirm this behaviour and which 11.x version it appeared? Many people may have exploited the more lenient behaviour of DimensionElementComponentAdd so although dead easy to patch this is definitely something to be ...

SCAN(sCode, 'ABC') > 0

Apparently, this filter method using the cube and the alternate hierarchy does not work if not within the context of the filter cube itself. As this was part of a larger query, just switched to using the base dimension and StrToMember function with a GENERATE to resolve the overall requirement. I th...

Okay. This is, surprisingly, the first time I have attempted to build a subset on a hierarchy with the FILTER using cube values as the filter. All the others were using attributes, TIFWIW. Have also tried saving the subset that is returning a subset and then using TM1SUBSETTOSET, but that fails to r...

Seems to be a context problem. However, I have been unable to figure out the problem. Here is the query: FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Accounts Master].[Hier.001]), 0), [Account Mapping].([Version].[Active_02], [sys.Websheet Control].[Input], [Geography].[All Geography], [HR Level].[All HR L...

Is the cube re-ordered ("optimized") in the order of the variables? HRLevel Period Adjustments Measure Org It then wouldn't be correct how the variables are being ordered, but it would offer an explaination. Yes, that was checked and I should have stated so. While I have no explanation, all that se...

There does not seem be a rational way to determine the dimension order when a TI is based on a cube view created by MDX. The original cube order: Org HRLevel Period Adjustments Measure The MDX: sViewMDX = EXPAND('SELECT {[Measure].[Measure].[FTE]} ON COLUMNS, NON EMPTY TM1SUBSETTOSET( [Org].[%hierOr...

Not sure if a mea culpa is due here or not, but views built with MDX are working fine in a TI using leaf elements or consolidations that only exist in an alternate hierarchy. Between interruptions today and asking the same question three times of IBM this morning :roll: ( thanks Lotsaram for the lin...

Is it not possible to build a view in a TI where one dimension is using elements that exist only in the alternate hierarchy? We have some consolidations that only exist in an alternate hierarchy. As there is apparently no way on God's green Earth I have found to assign a subset created with Hierarch...

Thank you all for the responses. After weighing "a large number of factors", decided to load actuals through a TI . The comments here confirm that decision. Always have done it that way, but wondered if I might be missing something. Was leaning towards rules because of some factors, but the overall ...

Would like some opinions/ideas on handling calculations for closed vs open periods in a time dimension. First, I've read several threads on time dimensions here, but as yet not one dealing with this particular topic. If I've missed one, more than happy to review it. We track open/closed periods with...

Elessar,

Have not looked at your link yet, but I do have an update. This also happens when a bad alias is handed to StrToMember. That should not have happened in our case, but we had a bad alias stored in a cube and, Whoa Nellie! it crashed the server while building a subset off that measure.

Yes, the server crash is unacceptably cruel. But you can use the workaround using the union of two members and take only one upper one, then if the first one is empty, you can take the default one. But this is terrible in terms of finding bugs. I am responding to this to make sure anyone who sees d...

you tried to put more curly braces??? {GENERATE( {FILTER( TM1SUBSETALL( [Account] ), LEN([mycube].([Version].[Active1], [Measure].[myMeasure])) > 0)} , {StrToMember("[Account].[" + [mycube].([Version].[Active1], [Measure].[RollupAccount]) + "]")})} Those are not necessary with functions that return...

You might look at PublishView TI Function. As a TI runs as Admin, it should publish a private view for public consumption.

We have isolated a problem where StrToMember will cause a server crash. This may be a well known problem, but a cursory Google search did not reveal anything on it. The code is building a subset of accounts based on values in a cube: GENERATE( FILTER( TM1SUBSETALL( [Account] ), LEN([mycube].([Versio...

Fantastic, thanks lotsaram.

Hi PavoGa, If you can I would raise with IBM, seems like a defect? May not help you in the short term unless its already been fixed.... Wondering if that is the case that it has been fixed. There are several reported MDX performance issues with the version we are on (TOPCOUNT, etc) that are fixed i...