Page Comparison

{scrollbar}

----
This section describes how to add parameters to manage dates. 


The finished example can be seen here.


h3. Creating Parameters on Dates 


{note:title=Nota}
It is advisable to have read [Cascading Parameterizing] before.

{note}
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*:
{code:SQL}
SELECT {[Fecha].[Año].members} ON COLUMNS
FROM [Vinos]
{code}
 Once defined the *Data Set* it can be seen from the *Data Explorer* view of O3Reporting:

                            !Data Explorer 1.png!

To continue follow these steps: 

# Right-click on *Report Parameters* and choose the *New Cascading Parameter* option and create a parameter cascade under the name *Dates* (Fechas)
  !Cascading Parameter 1.png!
# Press *Add* to add a parameter to the cascade 
# 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* |
  !Add Parameter 1.png!
# Press *OK * to continue. The following screen will pop up (Remember *Multiple Data Set* must be selected ):
  !Cascading Parameter 2.png!
# Press *OK * to continue:
# 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*
{code:SQL}
SELECT Descendants([Fecha].?, [Fecha].[Mes]) ON COLUMNS
FROM [Vinos]
{code}
# 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 {color:#ff3300#000000}eclipse{color} should look as shown below: 
  !Data Explorer 3.png!
# Right click on *Cascading Parameter Group - Fechas (dates) and* select the *Edit* option. The following screen will appear.
  !Cascading Parameter 2.png!
# Select *Add* to add a new parameter to the cascade. 
# 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* |
  !New Parameter 2.png!                 
# To continue press *OK*. The following screen will pop up.
  !Cascading Parameter 3.png!
# Press *OK* to continue 
  The *Data Explorer* view of your eclipse should look like this:
  !Data Explorer 4.png!
# 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*:
{code:SQL}
SELECT
	{[Fecha].?} ON COLUMNS,
	{[Vendedores].[Vendedor].members} ON ROWS
FROM [Vinos]
WHERE Measures.[Litros Vendidos]
{code}
# 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:
  !Data Explorer 5.png!
# Create a table with the information Sales by Salesperson and Months as explained in [Designing Report Layout]
# Select *Preview*. The following screen will pop up. 
  !Enter Parameters.png!
# Select the *Year * for which you wish to see the litres sold by the salespeople. The values for *Months* will be automatically updated.  
# Select the *Month* for which you want to see the report  
# Click *OK* 

For instance, if you choose "_2002_" as *Year*, and "_mar/2002_" as *Month* the report will show:  
|| Wine (vino) \\ || Litres Sold (litros Vendidos) \\ ||
| G & P Corp. | 5850 |
| Link S.R.L. | 1800 |
| Mykonos | 0 |
| ... | ... |
| Susana Garcia | 2700 \\ |
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  *

----
{scrollbar}