Search found 357 matches

by PavoGa
Thu Aug 22, 2019 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do I increase my knowledge and basic concepts of tm1?
Replies: 8
Views: 446

Re: How do I increase my knowledge and basic concepts of tm1?

Have not seen it mentioned, but the Bedrock White Papers are excellent resources as well.

Wim's MDX page is very good.
by PavoGa
Wed Aug 21, 2019 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How & why corrupted views of a cube is generated?
Replies: 8
Views: 110

Re: How & why corrupted views of a cube is generated?

In my experience this happens when a view has been saved with static subsets or selected elements. Someone then deletes these elements effectively returning a null set and the view breaks. There are probably other reasons but the above is probably a frequent occurrence for newer users who do not us...
by PavoGa
Fri Aug 16, 2019 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 248

Re: Rule or Process?

I may have missed it, but how are [daystaken] and [sales] loaded? From another cube via rules? Either way, seems obvious your measure should be sliced by the Banding. Adding individual measures to achieve this is really defeating the purpose and advantages of dimensional modeling and TM1. What happe...
by PavoGa
Fri Aug 16, 2019 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 248

Re: Rule or Process?

Why not add another dimension for Bandings since that seems to be the way you want to be able to slice the data?
by PavoGa
Thu Aug 15, 2019 10:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 429

Re: Lock Contention and RollBack

Did you try DIMIX( cDim |‘:‘| cHier, vEle) ? Do not know if this directed at my response, but I was not really clear. Where I'm using the temporary dimensions is when generating an email table of incorrect mappings/etc and, for instance the same account pops up 200 times. Only wanting one line for ...
by PavoGa
Thu Aug 15, 2019 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock Contention and RollBack
Replies: 11
Views: 429

Re: Lock Contention and RollBack

I tested this and compared performances for DIMIX against SubsetElementGetIndex in a large dimenson (having more than 10k members). The result is DIMIX is 400 times faster than SubsetElementGetIndex. Hence, when I replaced DIMIX with SubsetElementGetIndex, my processes never finishes at all and kee...
by PavoGa
Thu Aug 08, 2019 5:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ATTRPUTS much slower on Planning Analytics vs 10.2.2
Replies: 6
Views: 330

Re: ATTRPUTS much slower on Planning Analytics vs 10.2.2

Okay, possible problem with the feeder. When the load was slow, did you test a subsequent update immediately after the first? If so, what were the results? When the process ran quickly after adding back the rules, was the cube unloaded prior to the run? Are you using persistent feeders? (if yes, may...
by PavoGa
Thu Aug 08, 2019 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ATTRPUTS much slower on Planning Analytics vs 10.2.2
Replies: 6
Views: 330

Re: ATTRPUTS much slower on Planning Analytics vs 10.2.2

I have not seen that type of performance difference in this type of update and have a dimension of over 475,000 elements updating four attributes. The TI is reading from an Oracle datasource and runs the update in approximately 90 seconds give or take. Do you have a rule file on the attributes cube ...
by PavoGa
Wed Aug 07, 2019 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 461

Re: Feeder Issue Help Needed

It also appears you are doing a lot of addition in the rule. May consider breaking this gigantic rule into smaller ones by creating a consolidation that has components for each DB() call made. Native TM1 consolidations are much faster than rule-driven addition I believe you'll find.
by PavoGa
Wed Aug 07, 2019 7:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 10
Views: 474

Re: Dimension Order in an MDX cube view as datasource

So the MDX Views are not the magic I was hoping for to force my TI process to loop through the source in a way I want it to then. Thanks for the clarification. That is an interesting conclusion drawn from lotsaram's post. Suspect that you are not fully understanding what we are saying. In a traditi...
by PavoGa
Mon Aug 05, 2019 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension Order in an MDX cube view as datasource
Replies: 10
Views: 474

Re: Dimension Order in an MDX cube view as datasource

Ty, It seems that the ordering is dependent on the view structure - First WHERE - Then ROW - Last COLUMN We have seen this, but also, on a couple of queries, have seen an ordering that has no rhyme or reason to it. Has been rare, but has happened. Enough that we do not trust it and now write the TI...
by PavoGa
Mon Aug 05, 2019 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 375

Re: MDX to return elements that exists in another dimension, but as an alias

Thank you Ty, I got it working. I added this example to my MDX page . - a DIMIX kind of function in MDX. I noticed that Exists exists in MDX so maybe something along these lines. Thought about the EXISTS function as well. Have not tried it, but I think that circles back around to the need to conver...
by PavoGa
Mon Aug 05, 2019 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Rules
Replies: 1
Views: 179

Re: Tm1 Rules

If I may, this is too general a question. If you have a specific issue with rule or a problem you're not sure how to resolve, this is a good place. But this site is not intended to be TM1 101 training. See the proper rule IBM manual for the version you are using. Another excellent source is the Bedr...
by PavoGa
Fri Aug 02, 2019 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 375

Re: MDX to return elements that exists in another dimension, but as an alias

Hi, I had read your mdx code as it needed to be put in dim2, I didn't realise that mdx could be put in dim1 (I assumed because the first part of the code referenced dim2 it had to be put in dim2). A tip: in a GENERATE, the second clause is the operative dimension in which one is creating the subset.
by PavoGa
Fri Aug 02, 2019 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 375

Re: MDX to return elements that exists in another dimension, but as an alias

Okay, I see the potential source of the confusion. Yes, the code example I gave is designed to be executed in the subset editor for [Dim1]. In a TI, does not matter: SubsetCreateByMDX will produce a subset on Dim1. I couldn't get it to work during the 5-10 minutes that I played with it. Maybe that w...
by PavoGa
Fri Aug 02, 2019 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 375

Re: MDX to return elements that exists in another dimension, but as an alias

Wim Gielis wrote:
Fri Aug 02, 2019 2:43 pm
PavoGa wrote:
Fri Aug 02, 2019 2:40 pm
The query builds a subset on Dim1 using an attribute value of Dim2. Was that not what you were asking?
A subset on dim2 whose values occur in an alias attribute on dim1.
:) I was hoping the OP would be able to use the example to figure out the principle...
by PavoGa
Fri Aug 02, 2019 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 375

Re: MDX to return elements that exists in another dimension, but as an alias

Thanks for the replies. PavoGa - in your mdx the attribute is in the same dimension as where the mdx is, but in my case the attribute is in the other dimension. Does this matter? The query builds a subset on Dim1 using an attribute value of Dim2. Was that not what you were asking? Please note: this...
by PavoGa
Fri Aug 02, 2019 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 2985

Re: Dynamic query argument in TI...

We use EXPAND. All of our SQL queries are stored in a cube so we do not have to go through an onerous code migration of a TI if/when a SQL query needs tweaking. If TI needs a particular SQL query, we have utility TI that "assembles" the SQL query, runs it through an EXPAND and we get the SQL we need...
by PavoGa
Fri Aug 02, 2019 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX to return elements that exists in another dimension, but as an alias
Replies: 14
Views: 375

Re: MDX to return elements that exists in another dimension, but as an alias

Yes, you can do this entirely in MDX using GENERATE and StrToMember. For example: GENERATE( FILTER( TM1SUBSETALL( [dim2] ), LEN([dim2].[attribute]) > 0) , {StrToMember("[dim1].[" + [dim2].[attribute] + "]")}); One critical thing here. IF the value of the attribute is NOT a valid member of [dim1], so...
by PavoGa
Wed Jul 31, 2019 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Avoiding TI abort when using ViewCreateByMDX
Replies: 3
Views: 171

Re: Avoiding TI abort when using ViewCreateByMDX

macsir wrote:
Wed Jul 31, 2019 12:10 am
Hi, I had similar problem when using SUBSETCREATEBYMDX and then switch to function SUBSETMDXSET, which allows process goes to epilog. Maybe you can replace yours with ViewMDXSet as well? :D
Talking ViewCreateByMDX, not SubsetCreateByMDX.