Modificación del SQL generado.

When you press the Sql button in section  Optional modification of genereated SQL , it appears this dialogo that shows the SQL instruction use the bring the data used to create the cube.

It is not recommendable in any way, but you can modify this SQL instruction. You must be careful how do you modify this instruction. The number of fields and their corresponding data type must match with original instruction. If this isn't the case, the cube won't be created. The tables, condition and order sections are unimportant.

Modify the instruction text as necessary and use the buttons to:

  • Cancel : Exits the dialog without saving the modified SQL.
  • Apliy: Exits the dialog while saving your modified instruction. Use the Generate button of section Optional modification of generated SQL  to reset the SQL.
  • Data : Use this button to open the  See data dialogo to see yours SQL data.