2 Replies Latest reply: Apr 17, 2013 10:58 AM by 907475 RSS

    FR query -data not pulling.

    907475
      Hi,

      we have an issue with one of our Financial Report, which is in 11.1.1.1v.

      Report Background:

      wehave two grids point ot the same cube. ( It's an ASO cube)

      and there are mutilple prompts in the report. 2 prompts in the grid rows. which asks users to enter the scenario and Period.

      i have given the prompts as below
      Department prompts: D_1000,Years Prompt: FY13, Currency Prompt: USD ( at POV level)

      Prompt for Scenario: Actual, Prompt for Period: Jan

      Remaining all dimensions are kept in POV.

      Accounts are in rows & Scenarios, periods are in coloumns

      the data is not matching between in QTD & MTD ( i have selected Jan as period , so it should show the Jan values under QTD & MTD). i retrieved the same combination in Smartview at base level, and evrything is okay there ( data matched in all accounts between both MTD , QTD, YTD) but the data is not showing when i run the report

      i tried different optiosn by changing conditional formatting in that coloumn( Jan QTD ) , but no luck , Can any one please shed some light on this?

      Thx
      Ashok