Search found 333 matches

by PavoGa
Fri Jun 28, 2019 5:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 188

Re: Operators in TI : SQL IN equivalent

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 ...
by PavoGa
Thu Jun 27, 2019 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 6
Views: 159

Re: Lock Contention and RollBack

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.
by PavoGa
Thu Jun 27, 2019 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change to DimensionElementComponentAdd in PA vs 10.2?
Replies: 10
Views: 496

Re: Change to DimensionElementComponentAdd in PA vs 10.2?

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 ...
by PavoGa
Thu Jun 27, 2019 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 188

Re: Operators in TI : SQL IN equivalent

SCAN(sCode, 'ABC') > 0
by PavoGa
Tue Jun 25, 2019 4:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: subset MDX works in one cube view, not in another
Replies: 3
Views: 111

Re: PAW: subset MDX works in one cube view, not in another

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...
by PavoGa
Tue Jun 25, 2019 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: subset MDX works in one cube view, not in another
Replies: 3
Views: 111

Re: PAW: subset MDX works in one cube view, not in another

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...
by PavoGa
Tue Jun 25, 2019 2:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: subset MDX works in one cube view, not in another
Replies: 3
Views: 111

PAW: subset MDX works in one cube view, not in another

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...
by PavoGa
Wed Jun 19, 2019 3:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 2
Views: 139

Re: Dimension Order in an MDX cube view as datasource

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...
by PavoGa
Tue Jun 18, 2019 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 2
Views: 139

Dimension Order in an MDX cube view as datasource

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...
by PavoGa
Thu Jun 13, 2019 6:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI views using alternate hierarchies
Replies: 5
Views: 263

Re: TI views using alternate hierarchies

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...
by PavoGa
Wed Jun 12, 2019 10:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI views using alternate hierarchies
Replies: 5
Views: 263

TI views using alternate hierarchies

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...
by PavoGa
Tue Jun 04, 2019 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 291

Re: Method for handling Rules for Actuals/Forecast periods

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 ...
by PavoGa
Mon Jun 03, 2019 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 291

Method for handling Rules for Actuals/Forecast periods

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...
by PavoGa
Mon May 13, 2019 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 324

Re: StrToMember MDX function causing a server crash

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.
by PavoGa
Tue May 07, 2019 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 324

Re: StrToMember MDX function causing a server crash

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...
by PavoGa
Tue May 07, 2019 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 324

Re: StrToMember MDX function causing a server crash

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...
by PavoGa
Mon May 06, 2019 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Cube view
Replies: 1
Views: 95

Re: TM1 Cube view

You might look at PublishView TI Function. As a TI runs as Admin, it should publish a private view for public consumption.
by PavoGa
Mon May 06, 2019 1:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 324

StrToMember MDX function causing a server crash

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...
by PavoGa
Mon Apr 29, 2019 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow MDX performance
Replies: 2
Views: 132

Re: Slow MDX performance

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