Setting parameters before loading Crosstab

Modified on Wed, 6 Mar at 2:03 PM

How to set query parameters before loading a Crosstab

By default, Cross-tab will be loaded with full data from the dataset. Retrieval parameters are run-time parameters which are used to load cross-tab with filtered views.

Note: Retrieval parameter created for one object cannot be accessed from other objects.

The below Sales cross-tab shows Product Category wise Gross sales over different years.


image002.png


PRODUCT CATEGORY WISE GROSS SALES OVER DIFFERENT YEARS 

Step 1

Go to the Cross-tab Settings toolbar > Manage Retrieval Parameters

Step 2

In the Manage Retrieval Parameters dialog box, options to select the Dimensions and their default values are available.

In the Selected dimension(s) field, select the Year dimension from the drop-down list.

Step 3

In the Default value(s) field (this is optional), you can select any years from the drop-down list.


image004.png

MANAGE RETRIEVAL PARAMETER WINDOW 

Step 4

Click OK to create retrieval parameters.

After creating the Retrieval Parameters, select the Retrieval Parameters option from the Cross-tab toolbar to access them. You can give year values (say 2013 and 2014) from the drop-down list.


image006.png

RETRIEVAL PARAMETERS OPTION TO PROVIDE VALUES

The result will be queried like an 'OR' condition between these values of the dimension 'Year' (ie; Year = 2013 OR 2014). Hence, the Category sales of 2013 and 2014 will be displayed.


image008.png

    CATEGORY SALES OF 2013 & 2014



Anytime you can change the retrieval parameters values as needed based on which the data in the cross-tab will get reflected.

Multiple Parameters can be defined from the Manage Retrieval Parameters dialog.

For example, you can create two retrieval parameters – Year and Product Category. Once these retrieval parameters are created, you can retrieve this cross tab based on selected values from Product Category and Year – e.g. Sales of 'Bakery' and 'Fruit Juices' for '2013' and '2014'.


image010.png

MULTIPLE PARAMETERS FOR PRODUCT CATEGORY AND YEAR


image012.png

    AFTER APPLYING MULTIPLE FILTER

The data will be queried like an 'AND' condition of the dimensions Product Category and Year. So, this whole query would be (Category = 'Bakery' OR 'Fruit Juices') AND (Year = '2013' OR '2014'). Hence the sales of 'Bakery' and 'Fruit Juices' for the years '2013' and '2014' will be displayed.

 Note: This article is based on Smarten Version 5.x. This may or may not be relevant to the Smarten version you may be using.

set query parameters Retrieval parameter run-time parameters filtered views multiple parameters Manage Retrieval Parameters Business Intelligence Support Business Intelligence Articles Business Intelligence Training

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article