Diseño De KPIs | BIpostIT

Microstrategy Metadata & Statistics Tables (II)

21 March, 2015 by Miguel Pereira·0 Comments

MicroStrategy provide us the possibility to store statistics about our projects in physical tables. This information is varied and includes access dates, fault recording, runtimes … If we want to see the definition and composition of statistical tables which Microstrategy gathers, we can consult in:

Microstrategy 9.4 AdminSupplemental

since 463 page, there, we can see the information contained in each table.

In this post, I will combine information from the statistics repository with the information which we have in MicroStrategy metadata, for this reason it is advisable to take a look at the previous post:

Microstrategy Metadata Queries (I)

Miguel Pereira

http://es.linkedin.com/pub/miguel-pereira-rodr%C3%ADguez/5a/900/b5

Get duplicate values in columns in Oracle

14 January, 2015 by Diego García·0 Comments

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;

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

Diego García

http://es.linkedin.com/pub/diego-garcia-sanz/25/bb6/169/

AVG vs Promedio ponderado

24 December, 2014 by Sergio Martín·0 Comments

Al hilo de la creación de KPIs en Microstrategy, uno de los más recurrentes y, a priori, sencillos de crear, es el cálculo de promedios. Vamos a ver cual es la diferencia entre crear una métrica a partir de la función AVG o a partir de un SUM(x)/COUNT(x) y por el camino vamos a entender, entre otras cosas, la diferencia entre calcular la media de otras medias o la media ponderada de un conjunto de datos. Vamos a ello…Continue reading

Sergio Martín

Más de seis años de experiencia gestionando equipos y proyectos de Business Intelligence para diferentes sectores, apasionado de todos los procesos técnicos relacionados con la gestión de la información, el tratamiento de datos y la automatización de procesos

** Microstrategy 9.4 | Pentaho 5 (ETL) | Oracle 11g **

http://martinsergio.es

BIpostIT

#businessintelligence

Category: Diseño de KPIs

Microstrategy Metadata & Statistics Tables (II)

Get duplicate values in columns in Oracle

AVG vs Promedio ponderado

Uso de cookies