Filestore analysis / Cleaning – which file belongs to which report
Are the file stores eating up all your resources and you don’t know which reports are causing it?
BI 4.1 SP7 Windows installation
Well you can analyze it via tools like TreeSize Free. A simple tool to order the files/folders by GB. You will see the analysis of your file store folder. The neat thing is you can drill trough the biggest folders into the file that is loaded with large sets of data. The problem is that you still know nothing, I explain in this blog how to know which document is linked with which file.
In the output file you will retrieve the instances and in the input file you’ll have your report/documents holding large sets of data.
- OUTPUT instances of reports control them by setting limits in CMC
- INPUT data of saved reports purge reportdata
The output files can be limited in the CMC and the input files should be purged.
But always check with the owners of the reports before handling!
But how do we know what is what?
Well by clicking through all the folders, you ‘ll find the file containing large sets of data. Right click on it select properties and copy the name.
go to your query builder
SELECT * FROM CI_INFOOBJECTS WHERE SI_FILES.SI_FILE1 = 'paste filename'
SELECT SI_GUID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_FILES.SI_FILE1 = 'paste filename'
submit the query and in the outcome you can retrieve the CUID and name of the report.
*CUID thanks Former Member
LOGON as administrator in the SAP BI Launchpad and search for the name of the report (as admin you will see reports saved by users in their favourites as well)
Because the reportnames can be confusing, double check via CUID
QUERY RESULT REPORT PROPERTIES
check the guid of the report to match correct report->
Now you know which report is causing all your problems and you can take the necessary measures.