Skip to Content
avatar image
Former Member

sap bi monitoring trend universe/db

Hello,

I am recently familiarizing myself with trending db for monitoring SAP BI 4.2.
tried to add 4 monitoring db's to audit universe and joined them as below in screenshot,
but somehow the detailsID's does not match, and I get empty result from the next query:

Appreciated if anyone had similar issue and could help,


SELECT MOT_MES_DETAILS.DetailsId, MOT_MES_METRICS.DetailsId FROM MOT_MES_DETAILS INNER JOIN MOT_TREND_DETAILS ON (MOT_MES_DETAILS.DetailsId=MOT_TREND_DETAILS.DetailsId) INNER JOIN MOT_MES_METRICS ON (MOT_MES_METRICS.DetailsId=MOT_TREND_DETAILS.DetailsId)

Schema

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 05, 2017 at 05:20 PM

    mot_mes_metrics won't be populated for all rows. Try a left join to that table.

    Add comment
    10|10000 characters needed characters exceeded