Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Briefing Book is not updated if we change the filter condition of Analysis

Received Response
41
Views
4
Comments
Shubham Singh
Shubham Singh Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary:

I have created a updateble briefing book based on an analysis, later we updated the analysis using filter condition as per requirement, but Briefing Book is not updated if we change the filter condition of Analysis

Content (required):

Briefing Book is not updated if we change the filter condition of Analysis

Version (include the version you are using, if applicable):

21D (11.13.21.10.0)

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    By "change filter" do you mean you created analysis X, for example, 

    SELECT 0 s_0
, "Time"."Calendar Year" s_1
FROM "Absence Management - Leave Donations Real Time"
WHERE (cast("Time"."Calendar Year" as character) = '1999')
ORDER BY 1, 2 ASC NULLS LAST FETCH FIRST 75001 ROWS ONLY

    you added this to a "briefing book" A and then you edit the filter in analysis X for example

    WHERE (cast("Time"."Calendar Year" as character) = '2000')

    But when you view briefing book it still shows 1999 not 2000? I think it is a snapshot of the "code" from the analysis back in the day but if you selected "snapshot" then with the results saved from back in the day and if you selected "updateable" then the results as at now but with the code that was in the analysis back in the day? I think you will need to save the analysis to the briefing book again to pick up any changes in the analysis.

    For more information see

    "basics" guide Oracle® Fusion Middleware Basics Guide for Oracle Business Intelligence 11g Release 1 (11.1.1) E57682-01 April 2015 https://docs.oracle.com/middleware/11119/biee/BIEBB/raas-dash005.htm#A1012452

    and "Working with Briefing Books" Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) E10544-08 December 2014 https://docs.oracle.com/middleware/11119/biee/BIEUG/dashboards.htm#CHDFJDFG

  • Shubham Singh
    Shubham Singh Rank 1 - Community Starter

    Hi Nathan CC,

    Yes, that what I am currently doing. Thanks for the response I am looking into the documents that you have shared.

    Thanks

    Shubham

  • Shubham Singh
    Shubham Singh Rank 1 - Community Starter

    Hi Nathan,

    Saving the analysis again via Add to briefing book is not very efficient.

    Customers are adding multiple analysis in thier Briefing book and we cannot ask them to add them again just becasue we have made some refinement in the analysis and which may or may not change the Briefing book output.

    I hope this clarifies why this is big issue at our end.


    Thanks

    Shubham

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    HI Shubham, Your response confused me. This is a forum. I am simply sharing with you my opinion on how I think things work based on my experience of using OBI over the last 10+ years or so. I am a user the same as you at the end of the day. I am not the product owner from your vendor. If you you do not like how the product works then you need to raise an enhancement requests as an idea with Oracle to get them to change the functionality. Cheers, Nathan