Statistical Functions (regression analysis)

Hi ,

Does any one know if the following Statistical functions are available in Business Objects ?

Regression Statistical Functions for example calcuation of a slope or linear regression

Thanks


mdbdome (BOB member since 2004-07-28)

Linear interpolation can successfully be implemented creating a stored function Oracle with “aggregates” some points in order to find the best line that describes the general trend of the points.

Of course Oracle hasn’t a built-in function to realize that.


Donald Duck :mexico: (BOB member since 2004-07-29)

Slope calculus is much more difficult, in my opinion: you have to find a discrete derivative of a set of points in order to find their slope.

I have now no idea on how to realize that.


Donald Duck :mexico: (BOB member since 2004-07-29)

Thanks,

There were a couple of functions that can be used, (can be seen when an object is created, under function then number ) but don’t know how to use them right. I tried searching knowledge bases, but can’t seem to find anything !


mdbdome (BOB member since 2004-07-28)

If you see them when you are creating an object in Designer – then these are database functions.

Have you tried getting online/pdf documentation on the database in question? You particularly want the “manual(s)” that include Functions, in detail.


Anita Craig :us: (BOB member since 2002-06-17)

Thanks Anita ,

Actually just did a bit of digging,
I went into Designer and then clicked on a object , got a Number function and then clicked on help.

This gave me Edit options in SQL Editor which has references to the RDBMS guide

ie There is some information available under Help --> Data Access --> Pg 348 if you are looking at Oracle (while using 6.1b)


mdbdome (BOB member since 2004-07-28)

Oh, that’s nice. But a true database user manual will still probably give you the best documentation.

[And, I’m not using either Oracle nor 6.x… :wink: ]


Anita Craig :us: (BOB member since 2002-06-17)