Skip to Content
0

sap bi monitoring trend universe/db

Apr 05, 2017 at 03:18 PM

128

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Joe Peters Apr 05, 2017 at 05:20 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thanks for your feedback Peters,
I understand there won't be always a match,
but no match at all seems to me a little bit strange,
Or am I looking in wrong direction ?

0

I'm not certain, but I see the same results.

0