7 Replies Latest reply: Jan 21, 2011 5:27 AM by user12116294 RSS

    Previous Month

    786795
      Hi Guru's,

      I want to view the report in Previous Month.


      Thanks
      cmr
        • 1. Re: Previous Month
          828281
          just go for AGO function. you can calculate data for previous year or previous quarter or previous month if I m not wrong.

          Edited by: chandana on Jan 19, 2011 10:21 PM
          • 2. Re: Previous Month
            Srikanth Mandadi
            Hi,
            You can create a logical column in repository BMM Layer in that Fact table using AGO function so that you can display previous month\qtr\year level values.

            Refer : http://sandybi.wordpress.com/2009/12/08/time-series-caclulations-in-obiee/

            Example : AGO("Sample Sales"."F0 Rev Base Measures"."1-01 Revenue (Sum All)", "Sample Sales"."H0 Time"."Month", 1)
            AGO(Measure,Level(like..Month,Qtr,Year),Number(like..1,2,3..))

            Regards,
            Srikanth
            http://bintelligencegroup.wordpress.com
            • 3. Re: Previous Month
              Vinag
              Hi,

              You can also create a dynamic repository variable and used that in the report filter to fetch the previous month values. This is another way of looking at the req

              This should work. Try this. If it works, Pls award points.Thanks

              ~ Sarat Nallapati
              • 4. Re: Previous Month
                Vinag
                Hi,

                You can also create a dynamic repository variable and used that in the report filter to fetch the previous month values. This is another way of looking at the req

                This should work. Try this. If it works, Pls award points.Thanks

                ~ Sarat Nallapati
                • 5. Re: Previous Month
                  Vinag
                  Hi,

                  You can also create a dynamic repository variable and used that in the report filter to fetch the previous month values. This is another way of looking at the req

                  This should work. Try this. If it works, Pls award points.Thanks

                  ~ Sarat Nallapati
                  • 6. CREATE_DATE is on or before last day of previous month
                    786795
                    Hi Guru's,

                    I want to display the results for on or before last day of previous month


                    EX:CREATE_DATE is on or before last day of previous month

                    Thanks
                    Cmr
                    • 7. Re: CREATE_DATE is on or before last day of previous month
                      user12116294
                      Hello to get the last day of the current month please follow the below formula

                      TIMESTAMPADD(SQL_TSI_DAY,DAYOFMONTH(CURRENT_DATE) * -1 , CURRENT_DATE)

                      Hope it helps