Hi All,
When you drag a query calculation in cognos report studio dimensional reporting , you get 4 options
Calculated Member,Calculated Measure,Set and Other DataItem
Calculated Measure - USed when some calculations are done on the Measure - Ex : Sales /Pop
Set - When Sets are used .Set(A,B,C)
I would like to know when should I use Calculated Member and other DataItem and what is the difference between them.
Say If I want to add 2 members from product hierarchy I will use a calculated Member from product Hierarchy and add 2 members,
this is the same when using a normal data item also .
But when I compare this in tuple expression , it will throw an error for data item , but not for the calculated member
Thanks,
Nithya
Quote from: nithya1224 on 26 Oct 2015 07:41:44 AM
Hi All,
When you drag a query calculation in cognos report studio dimensional reporting , you get 4 options
Calculated Member,Calculated Measure,Set and Other DataItem
Calculated Measure - USed when some calculations are done on the Measure - Ex : Sales /Pop
Set - When Sets are used .Set(A,B,C)
I would like to know when should I use Calculated Member and other DataItem and what is the difference between them.
Say If I want to add 2 members from product hierarchy I will use a calculated Member from product Hierarchy and add 2 members,
this is the same when using a normal data item also .
But when I compare this in tuple expression , it will throw an error for data item , but not for the calculated member
Thanks,
Nithya
Hi,
When you choose type "Other", you can end up with a variety of different result types, depending on the expression you code. A calculated member must always contain an expression that resolves to one specific member.
MF.