Current Position:Home > Rolling Months

Rolling Months

Update:11-30Source: network consolidation
Advertisement
I created 12 rolling session variables to use to get 12 month rolling sums for my report. After creating the variables i made this filter to get sums for my GL balances (12 months ending).
FILTER ("Facts - GL Balance"."Balance Amount") USING ("Time"."Fiscal Period End Date" BETWEEN VALUEOF(NQ_SESSION.PERIOD_START_11AGO) and VALUEOF(NQ_SESSION.PERIOD_END_00))
this filter works only for 12 periods from the current date (NQ_SESSION.PERIOD_END_00) - how can I expand my range to include all the fiscal periods from 2002 to 2011, right now the report only gives me 12 periods from 10/31/2011 to 11/30/2010... for some reason my filter is limiting me, how can i circumvent this.... any help wld be apprceiated!!!!

The Best Answer

Advertisement
Thank you Deepak, you guided me correctly it is working for my 12/31 end of month dates bcoz it is rolling summed months from january. All other dates when selected from droplist are a sum from jan and not 12 months ago, i did all teh steps how can i now make the data correct- thanks
Edited by: 846431 on Nov 2, 2011 9:21 AM
  • Rolling month at repot level Update:10-11

    Is it possible to adding rolling 12 month at the report level? Does a formula need to be added or is there is an example I can see. I saw an example where the rolling months can be entered by the user but in this case th the # of monts need to be 12.

  • Rolling months in HFR ---- Really Urgent Update:11-30

    Hi All, We are using HRF to generate Reports connecting to and Essbase Database 11.1.2 Versions, in HFR we need 12 rolling months as per user request, User will select one Period and he need previous 11 months information... I tried to Period -1 to P

  • Rolling month for webi report using Univ based on BEX Query Update:11-30

    Dear Experts, I'm new to OLAP universes. We have a requirements of having last 12 months rolling  for given measure(Key figure) in webi report using Univ based on Bex Query. We require a calmonth (time dimension) object  (restricted for last 12 month

  • Rolling Month in Billing Plan in Sales Order Update:11-30

    I Require rolling month billing dates in Sales Orders . Kindly help on the same the followng format is required. Contract Start Date : 05.01.2010 Contract End Date : 31.03.2010 Settlement From   Settlement to    Billing Date 05.01.2010            04.

  • Dynamically rolling months forward in Analyzer with HFM data source Update:11-30

    I'm building a dashboard in Analyzer 7.0. I want the reports to dynamically update each month so a user does not have to go in and change the month on each report. Normally I would use a sub variable (i.e. cur_month) however, the datasource is not Es

  • Team calendar - rolling month Update:11-30

    Hi all Just wondering if anyone has found a way to have the team calendar show a rolling month i.e. rather than a static month (1 - 31), show 15 days prior to todays date and 15 days after todays date. Our managers get annoyed towards the end of the

  • Rolling months - Time series function Update:11-30

    Hi, I am new to OBIEE and this forum, and wondering someone could guide me through this requirement. I have a requirement that User needs to see inventory for rolling past 13 months, and should display inventory numbers(snapshot) for the first day of

  • Rolling Months Update:11-30

    I created 12 rolling session variables to use to get 12 month rolling sums for my report. After creating the variables i made this filter to get sums for my GL balances (12 months ending). FILTER ("Facts - GL Balance"."Balance Amount")

  • Rolling Month Sum required Update:11-30

    Hi , I like to achieve a functionality using the RSUM or Timeseries function but any of this would not help . I have a report to show the sales for last 12 months in such a way that each month of that 12 months will show the sum up all sales for past

  • Rolling months display Update:11-30

    Hi All, My requirement is such that the charts and cross tabs should display rolling 13 months from the selected month in the dropdown. My dropdown code at startup is: DROPDOWN_1.setItems(DS_1.getMemberList("0CALMONTH",MemberPresentation.Text,Me