Cognos Math Function: POWER

[marceloo]

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.

[sir_jeroen]

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?

[marceloo]

Yes! My Datasoure is a cube based SSAS.

[sir_jeroen]

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