Hitachi Vantara Pentaho Community Wiki
Child pages
  • Evaluating Pentaho Analysis

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Make sure data types used in the schema are appropriate with what is in your RDBMS. Sometimes dates in RDBMS need to be defined as Strings in the schema design depending on how your RDBMS reads and uses the date data type. Notice in the example below that GAME_DAY is a DATE, GAME_MONTH is a VARCHAR, and GAME_SEASON (which is YEAR) is a number. Make sure your data types in the schema match accordingly.

You can download the Oracle DDL sample data set here  if you wish.


 

Follow the instructions below to create a simple schema:

...