Page 1 of 1
ConsolidatedAvg Function
Posted: Wed Feb 08, 2012 11:54 am
by declanr
I expect to be redfaced when responses come in for this question but here it is:
I am currently working on 9.5.2 and have heard rumours of mythical functions e.g. consolidatedavg, consolidatedmax etc...
In the rules editor these functions aren't recognised, is it simply a case of them having been added in a later patch that I don't have installed or am I being more fundamentally dense?
Cheers
Re: ConsolidatedAvg Function
Posted: Wed Feb 08, 2012 12:25 pm
by qml
These functions have been added in the 9.5.2 release, but not documented in the standard documentation or added to the Advanced Rules Editor syntax. It doesn't mean you can't use them, it's just an unorthodox way for IBM to say "we care about our customers".
These functions do have their quirks and substantial limitations, so be sure to look for a thread on them on this forum.
Re: ConsolidatedAvg Function
Posted: Wed Feb 08, 2012 1:50 pm
by jim wood
Normally when they do that thy introduce them to test and then add them to documentation at the next major release. My guess is that they were added to 9.5.2 but intended for full release in 10.1.
Re: ConsolidatedAvg Function
Posted: Thu Feb 09, 2012 8:19 am
by Andy Key
ConsolidatedXXX functions were definitely supposed to be in 9.5.2, they made A Big Thing of them during the release presentations, and they released the documentation onto the web site immediately afterwards - it's just not in the PDFs. It can be found at {rummages in document of useful links from the IBM web site, yes it's a short document...}
http://www-01.ibm.com/support/docview.w ... wg21472749
Max and Min are probably less broken than Avg, which needs to be fixed so that zeros are handled properly with SkipCheck.
I spotted that something had been done with these in the 10.1 fix list, but I haven't had a chance to read any more than the title yet.
Re: ConsolidatedAvg Function
Posted: Fri Feb 10, 2012 3:39 pm
by declanr
Cheers for the responses... nice to know I wasn't just going insane.
I ended up going the old school way around the average method anyway.
I am currently testing 10.1 and when I regain my energy after the ridiculously long install time I will possibly start having a look at the rules editor etc.
Re: ConsolidatedAvg Function
Posted: Tue Feb 14, 2012 2:57 pm
by pobrouwers
hello,
I'm with 9.5.2 and I can't use the function consolidatedavg
Can you help me with a concrete example please?
thank you
Re: ConsolidatedAvg Function
Posted: Tue Feb 14, 2012 3:26 pm
by qml
pobrouwers wrote:Can you help me with a concrete example please?
IBM's website elaborates on the syntax:
IBM wrote:ConsolidatedAvg(flag-value, cube-name, element_1, element_2,
… );
flag-value The flag value is the sum of the following values:
1 - Use consolidation weighting when computing the value. If this is not turned on the raw value of the consolidated element will be used.
2 - ignore zero values. If this is set, zero values will not be used as part of computing an average.
cube-name Name of the cube where the values reside.
If the cube-name argument is an empty string, the current cube is used. This means you may write a rule such as:['Apr']=ConsolidatedMax( 0, '', !actvsbud, '1 Quarter' );
element_1, element_2, … Dimension element names that define the intersection of the cube containing the value to be retrieved.
Arguments element_1 through element_n are sequence-sensitive. element_1 must be an element from the first dimension of the cube, element_2 must be an element from the second dimension, and so on. These arguments can also be the names of aliases for dimension elements or TurboIntegrator variables.
Example
Consider a cube with “Income Statement” with three dimensions, “Regions”, “Time”, and “Income Statement”. The “Income Statement” dimension contains an element “Gross Sales” for the overall sales number.
To calculate the average sales across all regions in the year 2010 you can write:
ConsolidatedAvg( 0, 'Income Statement', 'All Regions', '2010', 'Gross Sales' );
Re: ConsolidatedAvg Function
Posted: Tue Feb 14, 2012 4:54 pm
by pobrouwers
Thx for your reply.
I've seen this example but it isn't work with my application. I don't understand
Do you have TM1 server example that illustrate this function ?
Thank you in advance
Re: ConsolidatedAvg Function
Posted: Tue Feb 14, 2012 5:39 pm
by qml
In this case, can I interest you in
Request for assistance guidelines, especially points
4, 5,
6 and 7.
Re: ConsolidatedAvg Function
Posted: Thu May 03, 2012 3:02 pm
by IronFlo91
Hello,
The "ConsolidatedAvg" Function does not work correctly, it displays #N/A on the consolidated level when the N level is 0.
We will receive the patch for version 9.5.2 IBM normally tomorrow
I'll try to keep you informed.
Florian
PS: Sorry for my english
I'm french
