General OBIEE

Get Involved. Join the Conversation.

Topic

    Robin O'Connor
    Adding two measures not working
    Topic posted July 25, 2017 by Robin O'ConnorBronze Crown: 15,000+ Points, tagged OBI Answers, OBIEE Answers, Reports 
    43 Views, 1 Comment
    Title:
    Adding two measures not working
    Summary:
    Adding two measures not working
    Content:

    I have a report where we are trying to add two measures together with a simple formula X + Y.  This does not work within the report.  The same formula works when I open a fresh OBIEE report.  Has anyone else experienced this issue?  Any fix for this?

    Comment

     

    • Richard Chan
      What is the physical SQL produced ? Get this from the session log. Try just the two measures then bring in columns and filters one at a time until it breaks there maybe a missing join or level in your rpd