0 Replies Latest reply: Jan 10, 2013 5:32 AM by 970365 RSS

    Report Mismatch error

    970365
      Hi
      I am using 10 as well as 11g.
      I have 1 dim and 1 fact table

      Fact
      Name------sales
      Raj---------10
      Ve--------20
      Raj------30

      Dim
      Name-------Team
      Raj----HUB
      Raj----HUBNET
      Ve----HUB

      Now i joing Dim.Name=Fact.Name(1 to n join)
      But dim data duplicated(e.g Raj)

      I report i selecting TEAM------SUM(SALES)

      in 11g table report return
      HUB---60
      HUBNET-----40

      In 10g table report return
      HUB--------(wrong value)
      HUBNET--------(wrong value)

      But both query 10g and 11g same value return DB query.

      So where is problem How presentation server works.

      When we have duplicate values DIM 10g not showing correct values?but DB fetching query is correct value return.After sum then problem.