9

I will describe step by step how to create a transactional report Microstrategy to give the user the possibility to insert, update or delete information. Let us place ourselves in a scenario in which we have to define a small data-entry able to enter values as coefficients or weights that will be part of the business indicators . Continue reading

Captura1

By deliverable requirements we have to export to excel a document that contains a report object and its head is multiline cause of the size of their literal.

For Excel respect us up and our header format debremos do the following:

  1. We should be on the section of the document that is embedded the report object.
  2. Right click, properties and tab ‘design’.
  3. Activate Excel check ‘Auto fit rows’.

magnifying-glass-spreadsheet-shutterstock-kuzma

 

I share a simple query to find duplicates in all  columns that compounds our tables in the project

 Best regards

O como parsear el código html de una página web a través de Pentaho Data Integracion.

El video anterior es un ejemplo sobre recoger información de una página web de deportes sobre la que he llevado a practica lo que a continuación os relato, sin dejar de mencionar a la comunidad/foro de Pentaho en que me apoyo en todo momento en forma de respuestas y adjuntos.

Descargar ejemplo .ktr :  ExampleWS

Continue reading