MyFolders storage space in OBIEE

3742958 · Jul 20, 2018 4:10AM

Good day

This is likely a simple query to Oracle experts, but are reports created and saved in MyFolders seen as templates of a report that gets refreshed when a report is run or the actual report saved with all the data included to whatever the parameters of that report is?

Trying to understand whether saving numerous reports in MyFolders will create a data storage issue in the same was as one would fill up a normal drive once downloading the report into MS Excel

Thanks

Owen

[Deleted User] · Jul 20, 2018 4:24AM

Not sure if you talk about "reports" - which is BI Publisher - or "analyses" - which is OBIEE, but the answer is the same:

The Oracle BI product suite NEVER stores data in its analysis or report definitions. Always just structural information liek data source, make-up of the data stream, conversion rules, visulaization structures etc.

Long story short: no data. Only metadata.

Joel Acha · Jul 20, 2018 4:24AM

If you are referring to OBIEE analyses, then these are just XML files stored in the catalog. The XML provides information to the presentation services OBIEE component and then in turn to the BI server component which dynamically generates the query against the data source and then returns the results in your web browser (summarised overview).

To answer your question, your catalog should be ok. If you make use of briefing books, then these create snapshots of the analyses executed and this is stored in the catalog.

[Deleted User] · Jul 20, 2018 4:29AM

True. Briefing Books store data as snapshots but who uses those

3742958 · Jul 20, 2018 7:13AM

Thank you Joel and Christian for the clarification

Kind regards

Owen

[Deleted User] · Jul 20, 2018 10:06AM

Owen,

Can you please close this thread if your question is answered?

It will help other forum users looking for the same topic.

Oracle Analytics Forum

Categories

MyFolders storage space in OBIEE

Answers