Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

MyFolders storage space in OBIEE

Received Response
2
Views
5
Comments
3742958
3742958 Rank 2 - Community Beginner

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Joel Rank 8 - Analytics Strategist

    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]
    [Deleted User] Rank 2 - Community Beginner

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

  • 3742958
    3742958 Rank 2 - Community Beginner

    Thank you Joel and Christian for the clarification

    Kind regards

    Owen

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Owen,

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

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