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