Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

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

...

  1. Open or select the tab containing the sample transformation you just created in Create Transformations.
  2. Right-click the Write to Database step, and select Visualize > Analyzer. In the background, PDI automatically generates the OLAP model that allows you to begin interacting immediately with your new data source.
  3. Drag the COUNTRY field from the Level section of the Available Fields list panel onto the report area.
  4. Drag the SALES measure from the Measure section of the Available Fields list panel onto the report area. Immediately you can see that there is another problem with the quality of the data. Some records being loaded into the database have a COUNTRY value of United States, while others have a value of USA. In the next steps, you return to the Data Integration perspective to resolve this issue.

...