0 Replies Latest reply: Jun 11, 2015 9:45 AM by Pradeep Kumar Pandey RSS

    direct discovery

    Pradeep Kumar Pandey

      I have a dimension BUYER_K, and measure Totalkgs_DD in direct discovery and it is joined with the in memory key BUYER_K. While calculating the BUYER_K wise Totalkgs_DD, it is showing correct value but while calculating value SALE_NO_DD wise, it is showing wrong value. What might be the problem. My direct discovery script and data model screen shots are as follows.

       

      directdiscovery:

      DIRECT QUERY

       

      dimension

        Broker As Broker_DD,

        Centre As Centre_DD,

        "Sale No" As SALE_NO_DD,

        Buyer As BUYER_K,

        Season As SEASON_DD

      measure

        Totalkgs As Totalkgs_DD,

        Totalkgs*AuctionPrice As VALUE_DD

      from eAUCTION.dbo."OTB_12_13";

       

      Please help, this is very urgent.