Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Bin Drill - Data not matching

Received Response
81
Views
18
Comments
3427576
3427576 Rank 4 - Community Specialist
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

Hi,

Created bins in the following way and drill has been enabled to another page on the dashboard. However, the data is not matching. Kindly guide me what might be the issue and what are the things to be taken care when drilling from bins.

pastedImage_0.png

pastedImage_1.png

I tried drilling on the bin $0 - $100 where AP Amount value is not matching with the grand total.

pastedImage_2.png

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3427576 wrote:I tried drilling on the bin $0 - $100 where AP Amount value is not matching with the grand total.

    Did you analyse the situation?

    Which one is right? Did you check the filters if you don't have a mismatch there explaining why you see different things? Did you compare the queries to see if data is coming from the same place with same filters and so they are supposed to match?

    Difficult to tell more as you are the one with the data and the logs and everything available to find the reason of the mismatch.

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

    A BIN based on a calculated measure column will not pass itself as a FILTER to the target. Period.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    +1 ... needs to have a 'key' to work right ...

  • 3427576
    3427576 Rank 4 - Community Specialist

    Thanks for the replies!!

    I searched internet, couldn't find any detailed information regarding bins drill. Could anyone share any related content.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Dear

    Show us the criteria of your target report.

    a) Did you kept the same BIN formula(in the first report) as  a filter in target report and made it is prompted?

    b) Are you adding any new dimension to the target report which is not in source report?

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

    @asim cholas Once more: fact-based bins. Will. Not. Work.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    @Christian Berg

    But it seems like working for me.. I am using the values from a fact.

    a) Criteria 1

    pastedImage_3.png

    b) Bin Code

    c)Results of criteria 1

    pastedImage_4.png

    Report 2 results

    pastedImage_5.png

    pastedImage_6.png

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

    Which version? Which OS?

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    OBIEE 12.2.1.0.0 in AIX 7.1.0.0 . But it works in 10g onwards.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Looks like some of your amounts are greater than the bin 1000-10000 ...