-The Metric_M table in the Data Mart table.
-The MetricKey_Map table in the Data Mart database.
-The MetricKey_Map table in the Data Warehouse (AC_Warehouse) database.
-The MetricKey_Map table in the Data Warehouse database includes the data source identifier as defined in the AC_Configuration database, to be combined with the idMetric column because the idMetric will generate duplicate values in the Warehouse from multiple sources.
-The idMetricKey value is the enterprise key for the data stream and relates to the Metric table in the data warehouse database.
The Metric table is used to source the OLAP Metric dimension and the Metric name in the context selector tree-view control in the Analysis Center console.
Using this information combined with the SQL queries below should assist you to determine if a given metric has been processed in Analysis Center. This can be helpful in cases where report in Analysis Center are not producing the expected results.
--Use the desired DataID from AppManager to trace data in the Analysis Center Data Marts--
select * from metric_m where idmetric = XXX
select * from metric_w where idmetric = XXX
select * from w_metric where dataid = XXX
--If AM DataId is NOT found above, look here--
select * from w_data_missing where dataid = XXX
select * from w_metric_missing where dataid = XXX
--IF AM DataID is found, then LOOKUP idMetricKey from MetricKey_Map--
select * from metrickey_map where idmetric = XXX
--IF found in MetricKey_Map query data tables for idMetricKey--
select * from data_20110401 where idmetrickey = YYY