This discussion is archived
0 Replies Latest reply: Jan 9, 2013 7:13 AM by 983677 RSS

On starting BI Server Report is showing 0 Result

983677 Newbie
Currently Being Moderated
I have facing a strange problem.One report is showing 0 Result on starting server,checked back end query,it shows it is hitting some other fact,tht'why measure is not found and cast Null as 0 is happening.

Strange thing is when I pull some other column from the same fact (But different Presentation table,same Logical table and Same LTS) along with my required measure it is showing data,hitting correct fact.But If I restart the server,again 0 result is coming.

I disabled cache and restarted,still the issue is coming.
I thought from BMM Layer the measure is not getting correct joins.
So I check all logical and physical join with conformed dimensions with Logical Fact.All are ok.

Measure has 2 definition at two LTS.
1.CASE "Oracle Data Warehouse"."Catalog"."dbo"."Fact_W_ORDERITEM_F"."TOP_LVL_LN_FLG" WHEN 'Y' THEN "Oracle Data Warehouse"."Catalog"."dbo"."Fact_W_ORDERITEM_F"."ROW_WID" END
2."Oracle Data Warehouse"."Catalog"."dbo"."Fact_W_ORDER_F"."NUM_ORDER_ITMS"

Please suggest possible reason.

Edited by: 980674 on Jan 8, 2013 9:04 PM

Edited by: 980674 on Jan 9, 2013 7:12 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points