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)
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 (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 (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 (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… ]
Anita Craig (BOB member since 2002-06-17)