Need help in understanding the query technically

[sabarish iyer]

Hi Guys,

The following query is trying to retrive data from a Oracle cube.I am not very much aware of the cubes.Can someone help in explaining what does mean

MODEL
  DIMENSION BY (
      DIM_TEMPS)
   MEASURES (

in the following query,

SELECT "DIM_TEMPS",
       "DIM_TEMPS_H_SEMAINE_PRNT",
       "DIM_TEMPS_445_ANNEE"
  FROM table(OLAP_TABLE('GOLD_BI duration session',
                        '',
                        '',
                        '&(DIM_TEMPS_LIMITMAP)'))
MODEL
  DIMENSION BY (
      DIM_TEMPS)
   MEASURES (
      DIM_TEMPS_H_SEMAINE_PRNT,
      DIM_TEMPS_445_ANNEE    )  RULES UPDATE SEQUENTIAL ORDER();

Thanks for help

Regards,

Sabarish