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}

...

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]
{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}

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

                            Image Added

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)
     Image Added
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

     Image Added
4. Press OK  to continue. The following screen will pop up (Remember Multiple Data Set must be selected ):
     Image Added
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

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

...

2. 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: 
     Image Added
3. Right click on Cascading Parameter Group - Fechas (dates) and select the Edit option. The following screen will appear.
     Image Added
4. Select Add to add a new parameter to the cascade. 
5. 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

     Image Added                
6. To continue press OK. The following screen will pop up.
     Image Added
7. Press OK to continue 
     The Data Explorer view of your eclipse should look like this:
     Image Added
8. 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 Block
   SQL SQL
   SELECT {[Fecha].?} ON COLUMNS, {[Vendedores].[Vendedor].members} ON ROWS FROM [Vinos] WHERE Measures.[Litros Vendidos]

...

2. Add the parameter Months (Meses)

...

1. to

...

1. the

...

1. Data

...

1. set

...

1. created

...

1. as

...

1. indicated

...

1. in

...

1. Simple

...

1. Parameterizing 
     Once the Data Set has been performed Set the Data Explorer view of your eclipse should look as shown below:
     Image Added
2. Create a table with the information Sales by Salesperson and Months as explained in Designing Report Layout
3. Select Preview. The following screen will pop up. 
     Image Added
4. Select the Year  for which you wish to see the litres sold by the salespeople. The values for Months will be automatically updated.  
5. Select the Month for which you want to see the report  
6. 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  

...

{scrollbar}