Where are BO reports stored on the server disk?

Document ID : KB000023068
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:  

 

After scheduling a report, it can be found in the report library. From the Report Library you can access the created report by clicking the appropriate icon. Where are these reports stored?

 

Answer: 

 

  1. Navigate to Servers node/dropdown in your CMC
  2. Right-click on your Hostname.OutputFileRepository and choose Properties from the menu
  3. Look in the File Store Directory value for the location
  4. If the value is %DefaultOutputFRSDir%, then in the left / sidebar menu, below Properties, select Placeholders
  5. Locate %DefaultOutputFRSDir% in the list and see the path that it is assigned to for the location.  E.g. C:/Program Files (x86)/CA/SC/CommonReporting3/BusinessObjects Enterprise 12.0/FileStore/Output/
  6. To determine the exact subfolder and filename used for a report that was run, you would then need to login to the QueryBuilder utility.  E.g. http://yourserver:8080/AdminTools/querybuilder/logonform.jsp
  7. After logging in (use yourserver:6400 as the 'System' field if not already populated, replacing 'yourserver' with your own hostname), you will be presented with the Business Objects Business Intelligance platform - Query Builder screen.  You can paste a query into the first text box and click on Submit Query to produce results.  Replace the [report name] with the actual name of a report you are looking for, such as Project List.  Example queries are placed below.
  8. When the results appear, locate the report result with the matching SI_STARTTIME and SI_ENDTIME for the report instance you ran, and then check under SI_FILES for the SI_PATH value referencing frs://Output/etc./etc. and the SI_FILEn values (e.g. SI_FILE1, SI_FILE2, etc.).
  9. This path and filename combination after 'Output' is appended to path location obtained above in step 5 to reveal the full path used for the report output.

 

E.g.

OutputFileRepository:File Store Directory = C:/Program Files(x86)/CA/SC/CommonReporting3/BusinessObjects Enterprise 12.0/FileStore/Output/

Query Builder:SI_PATH = frs://Output/a_245/012/000/3317/

Query Builder:SI_FILE1 = ~ce1a9085cf17bb720.rpt

 

Full path for the report output = C:/Program Files(x86)/CA/SC/CommonReporting3/BusinessObjects Enterprise 12.0/FileStore/Output/a_245/012/000/3317/~ce1a9085cf17bb720.rpt

 

CMC File Store Repository Output properties:

cmc_frsoutput_properties.png

 

CMC File Store Repository Output placeholders:

 

cmc_frsoutput_placeholders.png 

 

BO Query Builder:

 

cmc_querybuilder_sql.png 

 

 

Example Query Builder query:

SELECT SI_NAME, SI_KIND, SI_FILES, SI_INSTANCE, SI_STARTTIME, SI_ENDTIME
from CI_INFOOBJECTS
Where SI_NAME ='[report name]'

 

I.e.:

SELECT SI_NAME, SI_KIND, SI_FILES, SI_INSTANCE, SI_STARTTIME, SI_ENDTIME
from CI_INFOOBJECTS
Where SI_NAME ='Project List'

 

BO Query Builder example results:

 

cmc_querybuilder_resultsv2.PNG