Data is available in Iistcube 0SM_BPM but not coming on BW reporting for BPMon

[Former Member]

Hi Experts,

We have implemented BPMon in our solution manager system and Alerts are getting generated properly.

Then we tried to setup BW reports in system but data is not coming in BW reports( Data is in Infocube OSM_BPM )

Also, when we load BW master data its shows empty list

we already tried below things,

- Extractor frameworks are running properly

- BW check box in monitoring object configuration is alredy selected

- RFCs are working fine

- Reactivated all monitoring objects

Please advice to solve above issue.

Regards,

Rahul

[keiji_mishima · Accepted solution]

Hello Rahul

If you want to check the BPMon result in Alert Reporting, please check following.

1. 1st, BPMon Alert Reporting is working for classic BPMon. So please make sure your solution is classic BPMon base. (In BPMon setup, choose your solution. then you can find MAI enable flag. If the flag is empty, your solution is running on classic BPMon infra). I assume your BPMon is running on classic BPMon
   
   
2. In the post, you mentioned data is in the 0SM_BPM. So I assume data is properly transfer from BPMon Alert table (DSWP_BPM_ALERTS) to 0SM_BPM via alert report extractor.
   (If you do not see any entry in 0SM_BPM, I recommend to check data in the table DSWP_BPM_BI_EXTN.  Basically data in the alert table is sent to intermediate table DSWP_BPM_BI_EXTN and then it goes 0SM_BPM cube.
   If you do not see any data in DSWP_BPM_BI_EXTN and 0SM_BPM, then I suspect there is some error in extractor.
   
   (BW Alert Report extractor is enabled result of SolMan setup ->BPMon configuration->1.1  Automatic Configuration. By performing this, extractor enabled. So you may see extractor
   like "BPMon Alert Reporting Extractor (TD)".
   
   If you have some error like this extractor, it is better to implement some SAP Notes (e.g 2002520,1973295,1973181,1888350,1852509). And also better to check setup guide trouble shooting page. http://service.sap.com/~sapdownload/011000358700000825192012E/
   
   
3. If the data is in 0SM_BPM cube but you could not see the data, I suspect 2 things.
   
   3.1 You uses incorrect report template. As Deepak wrote correct one is 0SM_BPM_WT0001N
   
   3.2 You do not have authorization to see the data
   Please make sure your user has similar authorization like template report user.
   (SOLMAN_SETUP->BPMon->1.3 Template User Creation. User like BPO_REP_<SID>.
   
   

         or you can analyze using ST01 authorization trace

Best Regards

Keiji

[Former Member · Accepted solution]

Hi Keiji,

Thanks for your Valuable inputs.

I checked all things which you had mentioned

1- In BPMon setup i didnt find any MAI enable flag( we are implementing on SOLMAN 7.1 sp08)

2- Data is available in infocube-0SM_BPM and all extractors are working fine( All 3 showing green status) and its running on every hour.

Also, checked all notes which you have mentioned, all are completely implemented in system

3- we used new template and data is coming in BW reports now but dashboard is not working properly.

User is having SAP_ALL authorization so i guess its not authorization issue

Dashboard key figure repository showing blank value.

I checked below things,

- Connectors are proper

- we have updated AKF repository for all connectors

- note 1806818 is implemented completely

Please Assist to update key figure repository of dashboard.

Regards,

Rahul

[keiji_mishima · Accepted solution]

Hi Rahul

Let me clarify since you mentioned following.

> 3- we used new template and data is coming in BW reports now but dashboard is not working 
    properly.

Do you have a problem in BPO Dashboard ? (Cannot display BPMon Alert cube content in BPO Dashboard function ?)  or do you have problem on BPMon BW Alert report itself ?

BPMon BW Alert Report is this one.

http://service.sap.com/~sapdownload/011000358700000825192012E/

BPO Dashboard is this one

http://service.sap.com/~sapdownload/011000358700000764942013E

For BPMon BW Alert Report, you do not need "BW master data load",  connector and AKF.

Without having these, you can open BPMon BW Alert Report.

If this is a your case, I have no idea. Because your 1st sreen shot is 2nd screen of Alert Report. The screen coming after you choosing solution and timeframe in 1st screen. Usually we do not have issue in this phase. So I bit wonder. The only case that I can think of is, trouble that is described in set up guide page 34 (3.2.5 Message ‘Chart “CHART_*”. Data Provider does not contain any data’ is shown). But your screen shot does not have it. So I really wonder.

If your issue exist in BPO dashboard, there is some further check point.

To display the data in BPO Dashboard, you need connector instance to BPMon Cube.

And you need to have AKF (BW master data load is for analytics. So not related).

To see the data, you need to have active connector instance to the connector "BPM_AlCube".

BPM_ACube is for Analytics. So if you want to display BPMon Alert Cube data, you need BPM_AlCube connector instance and need to asign dashboard application.

Also in this case, better to have following note since there is some existing issue.

2059902 - Alert Cube connector in the BPO dashboards: Cumulative note for ST 7.10

1918347 - BPO dashboards alert cube: correction for FM AGS_BPM_RI_GET_

(Note 1918347 is required if your solman has  1806818)

Hope this help you.

Best Regards

Keiji Mishima

Cannot save clip

View Crash Report

Clipped to default notebook

Untitled note

Source link

Copy to clipboard

' ; // get html // ======== var _html = _response; // normalize // ========= _html = _html.replace(/<\s+/gi, '<'); _html = _html.replace(/\s+>/gi, '>'); _html = _html.replace(/\s+\/>/gi, '/>'); // remove // ====== _html = _html.replace(/]*?>([\s\S]*?)<\/script>/gi, ''); _html = _html.replace(/]*?\/>/gi, ''); _html = _html.replace(/]*?>([\s\S]*?)<\/noscript>/gi, ''); _html = _html.replace(/' ); // write to frame // ============== var _doc = $('#nextPageFrame__'+_pageNr).contents().get(0); _doc.open(); _doc.write(_html); _doc.close(); }; // loaded in frame // =============== $R.getContent__nextPage__loadedInFrame = function (_pageNr, _pageWindow) { // find // ==== var _found = $R.getContent__findInPage(_pageWindow), _foundHTML = _found._html, _removeTitleRegex = new RegExp($R.articleTitleMarker__start + '(.*?)' + $R.articleTitleMarker__end, 'i') ; // get first fragment // ================== var _firstFragment = $R.getContent__nextPage__getFirstFragment(_foundHTML); // gets first 2000 characters // diff set at 100 -- 0.05 switch (true) { case ($R.levenshteinDistance(_firstFragment, $R.nextPage__firstFragment__firstPage) < 100): case ($R.levenshteinDistance(_firstFragment, $R.nextPage__firstFragment__lastPage) < 100): // mark $R.debugPrint('NextPage', 'false'); // mark again if ($R.debug) { $('#debugOutput__value__NextPage').html('false'); } // pop page $R.nextPage__loadedPages.pop(); // break return false; default: // add to first fragemnts $R.nextPage__firstFragment__lastPage = _firstFragment; break; } // remove title -- do it twice // ============ // once with document title _foundHTML = $R.getContent__find__isolateTitleInHTML(_foundHTML, ($R.document.title > '' ? $R.document.title : '')); _foundHTML = _foundHTML.replace(_removeTitleRegex, ''); // once with article title _foundHTML = $R.getContent__find__isolateTitleInHTML(_foundHTML, $R.articleTitle); _foundHTML = _foundHTML.replace(_removeTitleRegex, ''); // display // ======= $R.displayPageHTML(_foundHTML, _pageNr, _pageWindow.location.href); // next // ==== $R.getContent__nextPage__find(_pageWindow, _found._links); }; // rewrites // ======== // rewrite displayPageHTML -- for multi-page articles // ======================= $R.displayPageHTML = function (_processedPageHTML, _pageNr, _pageURL) { // skip first if (_pageNr > 1); else { return; } // push to pages $C._nextPages.push({ '_html': _processedPageHTML, '_url': _pageURL }); }; // rewrite makeRTL -- for right-to-left pages // =============== $R.makeRTL = function () { $R.rtl = true; }; $R.makeNotRTL = function () { $R.rtl = false; } // set component object // ==================== window.ClearlyComponent = $C; window.$readable = $R; }

[Former Member · Accepted solution]

Hi Keiji,

Thanks a lot for your help.

I implemented above mentioned SAP Notes and its started working.

you have in depth knowledge of BPMon.

Thanks:)

[Former Member]

Hi Rahul,

You need to check if the table DSWP_BPM_ALERTS is getting populated. This table is the source for the Trend Analysis report.

Also, check if you have checked the BW check-box within the configuration of the Monitoring object.

Also, ensure that you are using the new report template - 0SM_BPM_WT0001N.

Regards

Deepak

[Former Member]

Hi Deepak,

Thanks for your reply.

I checked table DSWP_BPM_ALERTS and its having data as below

Also, check-box for BW reporting is selected  and i tried using new template but still data is not coming on reports.

Please assist.

Regards,

Rahul

[Former Member]

Hi Rahul,

In that case, try this -

Deactivate monitoring objects

Re-generate monitoring objects

Re-activate monitoring objects.

wait for about an hour or 2 and then check the report.

Regards

Deepak

[Former Member]

Hi Deepak,

Already tried that but no luck:(

[Former Member]

Hi Rahul,

did you try both the old and new reports?

Also, are you generating email notification on the alerts.... are you getting those alerts?

Rgds

Deepak

[Former Member]

Hi Deepak,

yes we tried using both templates but data is not coming

also, alerts and email notifications are working fine.

Regards,

Rahul