Modifying calendar settings

When you install BMC TrueSight Report Engine, by default, the fiscal month is set to January, and the fiscal year is set to 2009. When you generate any custom reports, data is populated from January 2009 to the current date.

For example, if you have data from 2008 to the current date in your database and when you generate reports, the data is populated only from January 2009 to the current date. You cannot see data for the year 2008.

If you want to view data before 2009 and if your fiscal calendar starts from a different month, you must modify the fiscal settings manually.

To modify the fiscal calendar settings manually

1. Copy the rpt-manual-fiscal-calendar-population.sql file from the BMC TrueSight Report Engine installation directory (/ReportEngine/schema/developer/oracle) to the computer where you have installed Oracle client.
2. Using the Oracle client, log on to the Oracle database using the user name that was created with appropriate rights. For details about the user name, see the Creating-tablespaces-and-user-on-the-Oracle-database-for-Report-Engine.

3. Run the following command:
   @<path of the rpt-manual-fiscal-calendar-population.sql file>

    

   Example

   @C:\rpt-manual-fiscal-calendar-population.sql

4. Enter the year from which you want to view data in the reports.
5. Enter the total number of years for which you want to view data in the reports.

6. Enter the numerical value for the month from which a fiscal year starts.

   Each month has a numerical value. The numerical value for January is 01, and the numerical value for December is 12.

   For example, if you want to view data from April 2007 to 2010, enter the values as shown in the example below.

   Enter value for begin_year: 2007
   Enter value for number_of_years: 3
   Enter value for begin_month: 04

   The database is updated with your fiscal calendar settings.