On April 27, 2024, our Sign-in and Create Account options will be unavailable from 9am-12pm ET. During this maintenance window, developer account access and free trial registration will be unavailable.

[2.2.2] How to use crosstabs in librarires ?

Erwan
Erwan Junior Member
Hi,

First of all, i would like to apologize for my poor english.

I have a project with a lot of reports, datasets and items. I use librarires to store generic datasets and items. It works very well.

Nevertheless, I don't manage to use properly crosstab via librairies.

Here is my problem :

--> creation steps :

#1 - I create a dataset in a library. This dataset has two parameters : "Year" and "CustomerCategory". The parameter "Year" is binded to a report parameter and the parameter "CustomerCategory" has as default value 4. According to reports the value of the parameter "CustomerCategory" could change.

#2 - I create a datacube based on the previous dataset. I create two groups and one measure. I don't need to use a filtrer because the dataset returns only the datas i want.

#3 - I create a crosstab based on the previous datacube.

--> use in report steps :

#1 - drag & drop the crosstab from the library to the report. I can't set here the value of my dataset parameter "CustomerCategory". What a pity !

#2 - drag & drop the datacube from the library to the report. We are compelled to do this or else the crosstab displays erroneous data.
here, we can not define the parameter value "CustomerCategory"

#3 As we can set the value of the parameter nowhere, we are compelled to drag&drop the dataset from the library to the report and change the default value of the parameter.

When we run the report vie the "preview" tab it works but when we run the report via another way (webapp BIRT) we have an error message :

"GRAVE: Failed to save design!"

How should i use crosstab from librairies with such a dataset ?