Parameterizing with dates

This section describes how to add parameters to manage dates. 

The finished example can be seen here.

Creating Parameters on Dates 

In the following example we show how to define a report where to see litres sold by all salespeople, parameterizing the months. 

First create a Data Set  containing the following information.
    * Name: Years
    * Data Source: O3 MDX View
    * Data Set Type: O3 Data Set
    * Query The following expression in MDX:

SELECT {[Fecha].[Año].members} ON COLUMNS
FROM [Vinos]

 Once defined the Data Set it can be seen from the Data Explorer view of O3Reporting:

To continue follow these steps: 

1. Right-click on Report Parameters and choose the New Cascading Parameter option and create a parameter cascade under the name Dates (Fechas)
    
2. Press Add to add a parameter to the cascade 
3. Enter the follwing data :

   Name:	The name of the parameter In our case Year (Año)
   Data Set:	Data set to which the parameter is associated  In our case we will use the Data Set Years (Años)
   Value:	Value the parameter will have In our case we will use  unique_name
   Display Text:	Text to be shown in the report  In our case: label

    
4. Press OK  to continue. The following screen will pop up (Remember Multiple Data Set must be selected ):
    
5. Press OK  to continue:
6. Create a Data Set  containing the following information :
       * Name: Months
       * Data Source: O3 MDX View
       * Data Set Type: O3 Data Set
       * Query: The following expression in MDX

   SELECT Descendants([Fecha].?, [Fecha].[Mes]) ON COLUMNS
   FROM [Vinos]
   

7. Add the parameter Year (Año) to the Data set created as indicated in Simple Parameterizing 
     Once the Data Set has been performed the Data Explorer view of your eclipse should look as shown below: 
    
8. Right click on Cascading Parameter Group - Fechas (dates) and select the Edit option. The following screen will appear.
    
9. Select Add to add a new parameter to the cascade. 
10. Enter the following data:

    Name:	The name of the parameter In our case Month (Mes)
    Data Set:	The data set to which the parameter is associated  In our case we will use the data set Months
    Value:	Value the parameter will have  In our case we will use unique_name
    Display Text:	Text to be shown in the report In our case label

                     
11. To continue press OK. The following screen will pop up.
     
12. Press OK to continue 
      The Data Explorer view of your eclipse should look like this:
     
13. Create a Data Set   containing the following information:
        * Name: Sales by Salesperson and Months
        * Data Source: O3 MDX View
        * Data Set Type: O3 Data Set
        * Query The following expression in MDX:

    SELECT
    	{[Fecha].?} ON COLUMNS,
    	{[Vendedores].[Vendedor].members} ON ROWS
    FROM [Vinos]
    WHERE Measures.[Litros Vendidos]
    

14. Add the parameter Months (Meses) to the Data set created as indicated in Simple Parameterizing 
      Once the Data Set has been performed Set the Data Explorer view of your eclipse should look as shown below:
     
15. Create a table with the information Sales by Salesperson and Months as explained in Designing Report Layout
16. Select Preview. The following screen will pop up. 
     
17. Select the Year  for which you wish to see the litres sold by the salespeople. The values for Months will be automatically updated.  
18. Select the Month for which you want to see the report  
19. Click OK 

For instance, if you choose "2002" as Year, and "mar/2002" as Month the report will show:  

If you wish to change the value of the parameter you will have to click on Show Report Parameters and the previous window will be opened again, where you can choose a new year and month