on 04-18-2014 11:14 PM
Requirement is to capture the query as well as the data returned when a webi document is run by the end user. End user has the ability to access universe and create their own documents.
1) Would it be possible to capture the temporary webi document from repository by turning on "Enable Real Time Cache" and saving the document somewhere else (or in another format)?
2) Is there a way to capture the select statement using Triggers or something and run it and store the output in a excel or csv file in oracle or sql server database by using any packages?
Thanks
Hello,
As per my knowledge, there is no straight forward solution is available.
The property “Enable Realtime Cache", allows the cache to be loaded dynamically. When something is not found in the cache, it is calculated and then saved into the cache for later re-use.
Can you please check if it meets your requirements:
http://service.sap.com/sap/support/notes/1207172
-Mahesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
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.