1 Reply Latest reply on Jan 27, 2015 9:23 AM by Gianni Ceresa

    Issue doing analysis on answers

    Alex1

      Hi experts,

       

      I have an weird issue.

      I want two measures in one analyisis and I don't have good results. If I make two reports (each report with one measure) I have good results.

       

      Explain with an example.

      First analysis.

      Code // Year // Entity // Revenue(Measure A)

      Total of measure A is 100

       

      Second analysis.

      Code // Year // Entity // Revenue2(Measure B)

      Total of measure B is 220

       

      Third analysis

      Code // Year // Entity // Revenue(Measure A) // Revenue2(Measure B)

      Total of measure A is 100 but measure B is 412

       

      Do you know any idea that can be?

       

      Thanks!

        • 1. Re: Issue doing analysis on answers
          Gianni Ceresa

          Is it possible that Revenu2(Measure B) is filtered and return data only for the existing Code / Year / Entity existing for Revenue(Measure A) ?

          Have a look at the generated physical SQL and check how the query is performed and if there is a inner join between the 2 excluding some values of Measure B because not existing in Measure A.