on 11-18-2013 11:44 AM
Hi All
I would like to understand where the data about the BPmon for simple job , idoc monitoring , PI monitoring , functional key figures are stored i.e in any table or any info cubes. And how long are these data will be available in solman.
And after confirmation of alerts from the Alert inbox , will the details about the alerts stored somewhere in any tables .
How can I go and check the alerts which were confired sometime before or deleted sometime before .
How long the confired alerts or deleted alerts will be stored in system .
Regards
Bala
Hi Bara
BPMon Alert data is stored in the table DSWP_BPM_ALERTS.
The alert information is stoed until its retain period.
You can define retain period when you setup your monitor.
if you are using SolMan 7.1 SP5 higher, the setting should be avaialble at alert reorganization and others tab of your monitor configuration screen.
If you want to keep the alert/confirm result for long term, you can use BPMon Alert Reporting function. That is introduced here (to transfer the data from DSWP_BPM_ALERTS to 0SM_BPM cube, you just need to set BW flag at same place where you define retention period).
http://scn.sap.com/community/software-support-and-maintenance/blog/2012/06/19/new-business-process-m...
In Alert Reporting function, you can keep the data in BPMon BW cube(0SM_BPM).
Configuration guide is availale
http://www.service.sap.com/~sapdownload/011000358700000825192012E/BPMon_Al_Rep_Setup_71_SP05.pdf
Cube 0SM_BPMRH is used for Business Process Analytics. So it is not relevant to the BPMon.
Best Regards
Keiji
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I have did the configuration for Materials w/o moving avg. price = 0 ,it runs twice in a day , right now it shows as 900 materials without MAP . But in alert inbox , I could able to see the last four days values only .
In alert reorg , i have given 30 days as my retention period .
I want to check the deatils of last 30 days for this particular monitor . So I went to RSA1 and given the particular monitoring ID and also Solution ID . But no data is displayed .
Please help me to retrive the data from infocube for last 30 days .
Regards
Bala
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bala,
All the alerts are stored in the BI cube 0SM_BPM itself, the corresponding fact table is /BI0/F0SM_BPM. check out with the field SM_ALSTA.
The data cleanup depends on your BI housekeeping jobs E2E_HK_CONTROLLER.
generic rule for Bw cube data deletion would be for infocubes with hourly data - 90 days. infocubes which hold daily data would be 12 months. however you can change those days, months from the table E2E_BI_DELETE.
later the bi housekeeping job take over the modified days. Check out the note 1480588.
Best regards
Jansi
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.