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

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

SELECT '/* '|| AB.TABLE_NAME || ' */        SELECT ' || AB.COLUMN_NAME ||', COUNT(1) AS DUPLICADOS FROM ' || AB.TABLE_NAME || ' GROUP BY '|| AB.COLUMN_NAME ||' HAVING COUNT(1)>1;' FROM(SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME LIKE '%' -- CONDITIONORDER BY 1, 2) ABGROUP BY AB.TABLE_NAME, AB.COLUMN_NAMEORDER BY AB.TABLE_NAME, AB.COLUMN_NAME;

 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