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.
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
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)
Thanks PaulM and MFGF for the reply.
I found the power function. and its working now.