Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos aggregation (summary on multiple measures on different hierarchy levels)

Status
Not open for further replies.

Gucha

Technical User
May 18, 2015
1
PL
Hi All,

I have a report with 3 hierarchy levels.
1-main hierarchy
2-by division
3-by region
I would like to do different summary on multiple columns in a crosstab.
There are three measures X, Y and Z.
X and Y column summary is correct but there is an issue with summary for column Z.
For X => [Y]/[Z] is taken.
For Y => it is simple column summary (sum).
For Z => maximum is taken (it is constant value for year).

Everything seem to works properly when I have set up filter parameters for Main hierarchy…
nowy_pic1_eyvcvz.jpg

…but when I choose (select) in filter section only two divisions. Total section shows maximum number of those two divisions, not individually for each division.
nowy_pic2_iigsdt.jpg


Additionally, when you look at summary of column Z for Main Hierarchy, (just to remind that I`ve selected only two divisions, so it should be 519897,00+ 704834,00 => 1224731,00) it shows wrong numbers. It looks like for all divisions of main hierarchy selected firstly.

nowy_pic3_wqa9lc.jpg


Any suggestions? Any help appreciated.

Thank you in advance :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top