Calculated Member and Data Item

[cognos05]

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

[MFGF]

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.