Search found 587 matches

by PavoGa
Fri Oct 08, 2021 10:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Erroring on Duplicative Dimension in DB Formula
Replies: 16
Views: 14154

Re: Rule Erroring on Duplicative Dimension in DB Formula

It's been a very long time since I looked at the parsing code but I seem to recollect that you can't do bang notation (!dimname) on a dimension name with a space in it. I'm probably wrong. Perhaps someone closer to the product could confirm or refute for me. It is not a problem. Do it all the time.
by PavoGa
Mon Sep 13, 2021 3:00 pm
Forum: Useful code, tips and tricks
Topic: Expand is SLOOOOOOOOOOW
Replies: 4
Views: 31688

Re: Expand is SLOOOOOOOOOOW

Very interesting! I use EXPAND a lot, but do not have to deal with excessively large datasets. A few years ago I tested and compared using EXPAND vs IF conditionals for output that varied in the number of fields, and while EXPAND was slower, the difference was negligible (at the time) vs the gain in...
by PavoGa
Wed Sep 01, 2021 8:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 13
Views: 11299

Re: @= in active sheet formula

As an FYI, this seems to clear by doing an edit replace of "=@" with "=" across all cells and sheets. I've not seen the "@" get re-introduced to date. I'm having a time with this. The snail keeps getting reintroduced to the formula (=@DBRW) just as soon as a new value ...
by PavoGa
Wed Sep 01, 2021 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: @= in active sheet formula
Replies: 13
Views: 11299

Re: @= in active sheet formula

As an FYI, this seems to clear by doing an edit replace of "=@" with "=" across all cells and sheets. I've not seen the "@" get re-introduced to date. I'm having a time with this. The snail keeps getting reintroduced to the formula (=@DBRW) just as soon as a new value ...
by PavoGa
Thu Aug 12, 2021 1:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - re-ordering dimensions
Replies: 2
Views: 3051

Re: TM1 - re-ordering dimensions

I believe Density is the ratio of populated leaf elements to the total leaf elements.
by PavoGa
Fri Aug 06, 2021 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New to Tm1 - question on how to access }StatsByCube
Replies: 2
Views: 3211

Re: New to Tm1 - question on how to access }StatsByCube

You can use either the Excel addin, PAW, Architect or custom build something with the API. You will need turn Performance Monitor on for the particular server instance to have any results in the }Stats cubes. I typically use Architect. In Architect, right click the instance and click <Start Performa...
by PavoGa
Wed Aug 04, 2021 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Filter Using MDX
Replies: 6
Views: 5736

Re: Cube View Filter Using MDX

The only odd think is that I was not able to create such view using ViewCreateByMDX in a TI process. Thanks This should be a fairly straightforward MDX view, but there are some differences in how the various user interfaces handle MDX in TM1. I do not have one readily available, but you might searc...
by PavoGa
Tue Aug 03, 2021 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Filter Using MDX
Replies: 6
Views: 5736

Re: Cube View Filter Using MDX

MDX example View as promised:

Code: Select all

SELECT
	[M].members ON COLUMNS,
	FILTER( [A].members *
		[B].members *
		[C].members *
		[D].members,
		[M].[Dispute Flag] > 0)
		ON ROWS
FROM [cubename]
by PavoGa
Tue Aug 03, 2021 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube View Filter Using MDX
Replies: 6
Views: 5736

Re: Cube View Filter Using MDX

Which dimensions are used in context (title dimensions) and which are used in rows/columns? There are a couple of approaches. The easiest, by far, is with one row dimension and one column dimension, one of which being the measure dimension. That MDX is pretty straightfoward and does not require any ...
by PavoGa
Sat Jul 31, 2021 7:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View to show first item in subset dynamically
Replies: 12
Views: 11476

Re: View to show first item in subset dynamically

Would like to see the MDX you are using to build the subset.
by PavoGa
Thu Jul 15, 2021 5:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drillthrough from 1 cube to another
Replies: 2
Views: 3028

Re: Drillthrough from 1 cube to another

This is pretty much how it's done. There are a number of threads about drill through (and some about issues that popped up with PA) already on the Forum. May have been why no one answered.
by PavoGa
Wed Jul 07, 2021 2:48 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 281458

Re: Belgium - Italy

...Armoured Throwball. I like this! :D I think my comeback would have been, why does the only guy who actually kicks a ball need full body armour? I have never seen that in football. Occasionally he can get clocked. Or she now, as Vanderbilt University last year used a female kicker. :lol:
by PavoGa
Tue Jul 06, 2021 6:58 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 281458

Re: Belgium - Italy

Do not remember the team, but recall a few years ago a player had his ear touched whereupon he immediately fell to the ground acting as if his leg was being removed with a dull butter knife. Good friend of mine here is English and we, good naturedly, razz back and forth about soccer and American foo...
by PavoGa
Mon Jun 28, 2021 8:26 pm
Forum: General
Topic: Belgium - Italy
Replies: 35
Views: 281458

Re: Belgium - Italy

My favorite old joke about what we call soccer was:

Joe: "What is 'soccer'?"

Franz: "It's a game where 22 men run around for an hour kicking a white ball and then Germany wins."
by PavoGa
Tue Jun 22, 2021 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Resetting }StatsByRule
Replies: 1
Views: 3145

Re: Resetting }StatsByRule

When I'm using }StatsByRule, I reset by resaving the rule file.
by PavoGa
Tue Jun 15, 2021 8:13 pm
Forum: General
Topic: Public Dataset suitable for TM1
Replies: 7
Views: 55945

Re: Public Dataset suitable for TM1

CDC has a lot of downloadable datasets on health & death statistics.
by PavoGa
Fri Jun 11, 2021 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 6491

Re: Long time execution of TI after finished nested processes

Well, then here is a long shot: have you re-ordered the dimensions in the affected cubes? I have one cube that was taking an extraordinary amount of time to load and read with TI's and, like in this case, there was no indicator at all. Reordered the dimensions and processing time dropped dramaticall...
by PavoGa
Wed Jun 09, 2021 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 6491

Re: Long time execution of TI after finished nested processes

Is B_TECH_Flag_En_0 executed with TM1RunTI from }Drill_RunCalcEntity ? Have you turned on the logger for lock contention? What code is executing after the calls to B_TECH_Flag_En_0 ? It is hard to have any idea on this without know exactly what is occurring after those calls in the master process. I...
by PavoGa
Tue Jun 08, 2021 1:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Long time execution of TI after finished nested processes
Replies: 8
Views: 6491

Re: Long time execution of TI after finished nested processes

Here is a discussion about a process that seems to correlate with the problem you have described.

It may not have anything to do with it, but it was a process that suddenly went to taking way too long to complete and there were no log file entries providing a clue.
by PavoGa
Tue Jun 08, 2021 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule set value to zero
Replies: 7
Views: 5609

Re: Rule set value to zero

Feeders are independent of the value (or non-value) stored in the cell. Regardless of whether the cell is blank or zero, if it is fed, TM1 has to deal with the overhead slowing performance of the consolidations. This is why feeder design is so important. There is nothing inherently wrong with storin...