Auto Purge Option in Web Intelligence

[Former Member]

Hi Experts,

I have a Webi report which is on top of 2 BEx queries connected through BICS. The Webi report has more than 4 crore records which makes it difficult to load each time when I refresh. So I need to purge the report before refreshing the report.

I would like to get an option to automate the purging the report so that user do not manually do this process.

Please suggest how will I achieve this. Also I would like to know any other methods to improve the preformance of this report.

Thanks in advance,

Abdul

[Former Member · Accepted solution]

Purge the report and save it in purged mode without any data and use scheduling to make the schedule instances with data available for users and ask users to access the latest scheduled instance for data using Right Click>View Latest Instance.

If they want to open the report without any data(purged version) they can use Right Click>View and run it to answer any prompts etc

Hope this helps.

Thanks

Mallik

[Former Member]

Hi Abdul,

Below is the idea of controlling the purge data across multiple reports via SDK which is closest to what you have asked for. There were other ideas related to purge but they were different from your requirement. At the moment I think Manikandan Elumalai suggested SDK route is one of the ways to control(apart from work around suggested) Purge option for multiple or individual documents without report users interference.

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=1DA84A30-1E5A-43FA-95C5-857A8B99D197&idea_id=CE169F61-...

If you feel  "Auto Purge" is a required option to have it at CMC or webi preferences or webi document properties level you can post it as an idea at idea place.

https://ideas.sap.com/ct/s.bix?c=1DA84A30-1E5A-43FA-95C5-857A8B99D197

Thanks

Mallik

[jyothirmayee_s]

Hi,

When you purge and save the report with "Refresh on open" unchecked then user will not be able to see last refreshed and also prompt screen wont get populated.

Anyway when user runs the report , they can save it in their fav folder or inbox only not into public folders.

Thanks,

Jothi

[former_member182521]

Hi Abdul,

This must help you if you are interested in SDK approach.

http://scn.sap.com/community/bi-platform/java-sdk/blog/2010/04/28/purging-webi-document-data-using-t...

Regards,

Mani

[Former Member]

Hi,

If the user always refresh when he opens the report then we can save the report without having the data. So that whenever he opens and refresh there will be data available at that time

Otherwise,

1. Save the report initially by purging the data

2. Schedule the report and make the user to see the the report via View Latest instance if he would like to see the latest data.

3. If he wants to refresh the report with other parameters open the report via View so that the data is always purged. Upon refresh the data will be availble for the user.

Regards,

Bharath

[Former Member]

Hi Abdul,

There is no specific option as such to auto purge a report. I think you we need to customize SDK to achieve it.

Thanks,

Suresh

[Former Member]

Hi Abdul,

for that please refer below link....

http://answers.uchicago.edu/page.php?id=16756.

Thank You,

Haresh