Print Page - How to write formula that is dependent of current measure? If command?

Title: How to write formula that is dependent of current measure? If command?
Post by: abcuser on 14 Jun 2010 03:54:01 AM

Hi,
in Cognos BI v8.4.1 Report Studio in Crosstab I would like to write formula that accesses TM1 v9.5 cube.

I have two products "A" and "B". I have a price measure for this member and quantity sold for this products. Now I need to calculate what is sum of quantity for this two products and what is average price sold for this two products.

I have a problem with "sum of A and B" formula which is dependent of current measure. I most probably must write some kind of IF statement to ask for current measure or something like this. Please see bellow link I have written simple sample. How to write formula for "sum of A and B" --> Price combination?
Thanks

http://www.shrani.si/f/D/bj/1UmtvYpO/formula.png

Title: Re: How to write formula that is dependent of current measure? If command?
Post by: mvjcognos on 14 Jul 2010 02:29:00 AM

might be try this

sum(quantity for a,b)
avg(sales price for a,b)

Title: Re: How to write formula that is dependent of current measure? If command?
Post by: MFGF on 14 Jul 2010 09:15:10 AM

How about using syntax along the lines of:

aggregate([quantity] within set ([Product A],[Product B]))

and

average([sales price] within set ([Product A],[Product B]))

Regards,

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: abcuser on 14 Jun 2010 03:54:01 AM