[solved] calculate with fact calculations and sets

[charon]

Hi Everybody,

the dimensional functions in cognos declared war on me..AGAIN. :D

Thats the situation: I have created a set with custom groups in RS 10, based on a DMR Model.
The set are the rows of my crosstab. The colums are different facts, some native facts from the table, some are calculations.
What i need now is the aggregation, means for revenue e.g. i need a sum over all revenue facts for this set. thats easy and works well.
BUT: in a second step, i need to work with these results, in this case sum of fact 1 and all the set members.

Example:
                                      Fact 1                   Fact 2                             Fact x...
SET i
->           member 1        abc                       cde                                    ...
->           member 2        cba                       edc                                    ...
-------------------------
             aggregation   abc+ cba              cde+edc         ( sum fact1-sumfact2)/ sum fact 1


the fact x is a percentage.

How can i realize that? Ive tried different dim functions like "tuple(set i;currentmeasure)) or tuple (set i; factx), but didnt receive the correct data. also, ive tried different aggregation modes.

Help is appreciated a LOT :S
thx and cheerz
charon

[tjohnson3050]

For the total row, use the function aggregate(currentMeasure within set (set(member 1, member2))

[charon]

Thx for the reply TJohnson,

but the main issue is not to aggregate, but to work with the aggregated results from that total row.
It has a total for fact 1, total fact 2, and the 3. column should be calcaulation basesd on the both further totals...

any further ideas ? :D

[tjohnson3050]

On the calculated measure, make sure that the aggregation type is set to calculated.  This will re-apply the calculation with the aggregated values of the data items in the calculation.

[charon]

you sir, are a GENIUS.

of course i know this setting from the cog612 course, but ive never used it b4.
thx a lot tjohnson, u made my day :D

issue solved.

[tjohnson3050]

Glad I could be of help.  Your applause is much appreciated :)