Tuesday 24 January 2012

Within set ,Within detail, Within aggregate Explained

Hi Guys,

I was going through dimensional functions and i have found some preety interesting material on within set,within aggregate and within detail at the below link.

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id10574cr_rptstd_wrkdat_agg_val_xtabs_char.html

So i tried that. However i am not sure how within aggregate works and i found out some new thing in cognos 10


However what i noticed is i am getting same values for both Within set and within aggregate.
Below is a new thing that i noticed in Cognos10.Dimensional Edge summary


Below is a case that i tried for Nested Measures

Consider the case when measures are nested on rows.Like you have Product number on rows and unit price and unit sales nested on row close to it.they are not provided as measures in measure section

Cognos earlier to 10 was taking total(currentmeasure within detail [dimension])
Now this is done assuming currentmeasure is your single measure that is there and dimension is the one that you are doing total on.But in case of nested measure this changes as you dont have a single measure but multiple ones.

total([Quantity] within detail [Product type])--- This will calculate the total of quantity for
each product type for each product line .That is it is to be position as shown in diagram

Below i a Image of Nested measures


Below is the total calculated by using Within set ,Within aggregate and within detail

No comments:

Post a Comment