Question:
Hi,
I wanted to find out how people let their users know when data loads into BW are complete so that they know that they are getting the most up-to-date data when they run their queries?
Thanks,
Allan
Answer:
We usually display the text element "Status of data" which displays the last date of loading.
If you have only 1 load per day, it's the best way to display the relevance of the data.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Hi Fred,
Could you elaborate a little more on how do you achieve this.
That is displaying the status of the load. If I want to do it what/where I need to make changes in BW.
Thanks
Anu
Answer:
With a report displayed, click on the Layout button on the BW toolbar, then choose Display Text Elements, All (or General). We generally then delete the ones not of interest to the user, then save the workbook.
A much more interesting question (IMHO) is: If a data load FAILS, how do you notify potentially affected users?
We check this first thing every morning, but are not very proactive about letting users know if something has not been extracted correctly. Of course, we pay for it later by having to answer telephone calls and/or resolve Help Desk tickets.
Any good techniques, anyone?
Bob
Answer:
Hi Alkirui,
Let us know which ver. of BW u r on. If u r on 3.x, then use Process Chains. If you need help on doing the same, let us know and I shall send u doc on it. By using Process Chains, u can send mails to the user community after upload is complete.
Hope the lead helps.
Answer:
For ERRORS/SUCCESS DATALOADS go for PC(Process chain).
A LOT has been discuused abt implementation of PC in detail,pliz search FORUM
Chetan
nJOY SAP.
Answer:
Hi Allan,
From 3.0B onwards we can do that by using Process Chains mechanism.
Thanks
Sirineni Srikanth.
Answer:
Hi,
Everyday, somebody check the load of all cubes and then write a system message.
So, each user knows if the data are correct or not when he log on BW.
Answer:
Referring to Freds comment
We usually display the text element "Status of data" which displays the last date of loading.
If you have only 1 load per day, it's the best way to display the relevance of the data.
When it is a Multiprovider - it is not displaying the Status of Data because the Muliprovider does not has any data, how can I show the status of data based on the underlying cubes.
Any suggestions ??
regards
Poonam
Answer:
I found the answer to my quey . Here is the post which explains about the status of data for multiprovider
/forums/viewtopic.php?t=31327&highlight=status+data
Regards
Poonam
Answer:
HI alikuri,
From 3.0 B onwards you can use process chain concept and same time you can set up E-mail notification to your mail box. Whoever is on call they will try to solve the problem.
Thanks and regards
Venkat
Answer:
Hai
you can use the reporting agent where in you can define the exceptions.
We need to define an exception where we know when the data upload is completed .
Answer:
My BW team has written ABAP code to update an internal company BW web site with the infoprovider name (for basic cube, ODS, multiprovider), date and time stamp. Works like a charm!
Answer:
Hi All,
One more way to send mails is to use User Exit BADI which will trigger after the data load that we have to set from info package under subsequent processing button. Write some ABAP logic and call appropriate Function Modules to send mails. Use the input parameters available in that user exit to check the status of the load.
Hope this helps!
Answer:
Hi ,
You have to monitor review the load of the data load thry RSMO, everyday that is the best process.
This you have to do it on the basis of frequency of the data loads. You have to inform the people for failure of the loads and not necessary for sucess since then it will mean too many.
Also you can give a report every day for a summary of status to the IT team lead for sucess /failure.
Though monitoring by PC is allways possible, I have not seen it happening too frequently.