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

OTBI analysis based on results of another analysis

Received Response
641
Views
5
Comments
Nick Trojack
Nick Trojack Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary:

I have 1 OTBI analysis that looks at all invoices in system and filters it down based on 10 parameters. I have a second OTBI analysis that I then have a filter to base results on the first analysis and pivot based on INVOICE ID. I then apply a few more filters.

In the past this report has worked fine and i created it to speed things up. Now it has stopped working as of a week ago. Anyone else have this issue have any ideas?

Content (required):

I have 1 OTBI analysis that looks at all invoices in system and filters it down based on 10 parameters. I have a second OTBI analysis that I then have a filter to base results on the first analysis and pivot based on INVOICE ID. I then apply a few more filters.

In the past this report has worked fine and i created it to speed things up. Now it has stopped working as of a week ago. Anyone else have this issue have any ideas?

Content (required):

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


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

Tagged:

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    Hi @Nick Trojack ,

    As per your description it should work fine.

    ·       Is there any recent change to those reports?

    ·       Is there any recent release / upgrade? Which might impact those.

    Can you please share the error / issue details, screenshot etc. also the XML of those reports?

    Cheers,

  • Nick Trojack
    Nick Trojack Rank 1 - Community Starter

    No change to reports or upgrade. Let me see what I can do. the report itself references DFF's

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    Hi - I had this issue where same type of thing stopped working. Turns out in the first analysis which it was based off DFF value in there, there was a NULL value in a row of data for a dff. When passing to second query, the second query failed when there was a null DFF in first analysis. Had to filter out the null, then second query worked again.

    In other words, passing null value to second query will result in failure, even if rest of records contain data.

  • ThomasSimkiss
    ThomasSimkiss Rank 1 - Community Starter

    I am having the exact same issue. I am passing in Period Name and CCID from a prior query and it is not limiting the next query based on the prior results.

  • Rich Merkel
    Rich Merkel Rank 6 - Analytics Lead

    sounds like a good case for SR. they will ask you to provide nqquery logs/etc but that may be best approach since it worked in the past. Oracle would need you to provide the logs (several ways, you can search customer connect) or SR will guide you how to provide the detail. Last time I did have this issue was the query passing to 2nd query had a null value in results which stopped the 2nd query from working. I made some changes to exclude passing nulls which did work in my case, but it sounds like best approach is for SR.