Home » SQL & PL/SQL » SQL & PL/SQL » how to use oracles IRR function
icon4.gif  how to use oracles IRR function [message #197740] Thu, 12 October 2006 08:44 Go to next message
jitendra.kale
Messages: 4
Registered: July 2006
Location: poona
Junior Member
I want to use oracles IRR function
I found one site for that,

http://www.stanford.edu/dept/itss/docs/oracle/10g/olap.101/b10339/x_inf014.htm

But not come to any conclusion because in the given eg. of site
they said create dimension.
I am not familiar with dimension, for dimension you can refer foll. site,
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_5006.htm


if possible give any example
Re: how to use oracles IRR function [message #197782 is a reply to message #197740] Thu, 12 October 2006 12:36 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Maybe you need to get some theoretical background on dimensions to understand what's going on in the documentation. There are hundreds of books on the subject of dimensional models, so pick any one you like Razz

But I found one article that might be useful straight away, it gives a step by step example of creating dimensions:
http://www.oracle.com/technology/oramag/oracle/05-nov/o65awm.html

Regards,
Sabine
Re: how to use oracles IRR function [message #197869 is a reply to message #197782] Fri, 13 October 2006 00:55 Go to previous message
jitendra.kale
Messages: 4
Registered: July 2006
Location: poona
Junior Member
thanks sabine
Previous Topic: ORA-00604 Error SQL recursive 1
Next Topic: lowest sal
Goto Forum:
  


Current Time: Mon Dec 05 18:55:11 CST 2016

Total time taken to generate the page: 0.11579 seconds