COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: marceloo on 04 Feb 2011 11:26:16 AM

Title: Cognos Math Function: POWER
Post by: marceloo on 04 Feb 2011 11:26:16 AM
Hello!

Anybody know about the exponential function POWER of Cognos?

I using POWER( expression1; expression2 ) but i get the follow error:

"YK -ERR 0008 The data provider returned an error message: The '[POWER]' function
does not exist."


I'm searching for this error and get this explanation:
The solution is to install MS Office on the MS SQL 2005 Server computer

Where are native function POWER of Cognos? It's the primary function of world of Math..

Thanks.

Title: Re: Cognos Math Function: POWER
Post by: sir_jeroen on 06 Feb 2011 07:34:41 AM
With a relational SQL Server datasource I can use in 8.4.1 the following function without problems: power(3;3)
Are you perhaps using a Dimensional datasource?
Title: Re: Cognos Math Function: POWER
Post by: marceloo on 07 Feb 2011 05:27:37 AM
Yes! My Datasoure is a cube based SSAS.

Title: Re: Cognos Math Function: POWER
Post by: sir_jeroen on 08 Feb 2011 03:11:47 AM
That's what I expected :S (YK-Err...)...
Have you tried [Expression1]^[Expression2] that might work... Let me know if this works..

This might come in handy http://msdn.microsoft.com/en-us/library/ms144766.aspx (http://msdn.microsoft.com/en-us/library/ms144766.aspx)