ConsolidatedAvg Function

[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

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

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

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

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

[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

[qml]

Can you help me with a concrete example please?

IBM's website elaborates on the syntax:

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' );

[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

[qml]

In this case, can I interest you in Request for assistance guidelines, especially points 4, 5, 6 and 7.

[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