Guidelines for Model Design, Cube Creation, and System Maintenance Process

Use the following guidelines when building PowerCubes in UNIX or Linux®environments.

  • Design and create a prototype model locally, on a Windows computer.
  • Create and test your cubes locally on a Windows computer.
  • Define a UNIX- or Linux-accessible data source in the model and save your server cubes in Model Definition Language (MDL) format.
  • Convert the .mdl files to .pyj files and create cubes using the .pyj files.
  • Move your cubes to a UNIX or Linux production server and tune your system for optimal OLAP reporting performance.