Power() function in Cognos 10 Report studio for DMR reporting

[Mpotla]

Hi Folks,

I am creating reporting package published using TM1 cube.

In one of my report, I would need to calculate the Power ( X, 1/n). Please help in evaluating the above expression..

I have searched in cognos available functions, I couldn't find any function with similar functinality, except sqrt().


Thanks for you help.

[MFGF]

Hi,

Have you looked at the Power() function? I think this should give you the result you need? Or have I misunderstood (which is quite normal for me! :) )

Cheers!

MF.

Sent from my iPad using Tapatalk HD

[CognosPaul]

Is this for DMR or TM1? Unfortunately most OLAP sources don't support power, or exp, log, or ln, which could let you find the power in a different way.

If you need to display the data inside a chart, you may be out of luck. However, if you just need to show the numeric values in the xtab, you do have a work-around. Unlock the report, and select the intersection you need. Set Define Contents to yes, and drag in a layout expression. At that point you can use the Power function as MF suggested.  power (CellValue (), 1/5)

[Mpotla]

Thanks PaulM and MFGF for the reply.

I found the power function. and its working now.