dashboard and analysis

0
Code:

Hi,

I'm using jasperserver-pro 3.0.2 on linux platform.
I have done an analysis view and it works well.
I have create a report with iReport with hypertext link in order to run the analysis when click on data.
The report is now in a dashboard.
Everything is working well except my analysis which run wil not accept my parameter. It will always run the analysis view as defined at the beginning.
The URL is good, with my parameter, but not the analysis.
I have checked the assign permissions on it, but I have administer access.

In he hypertext link I'm calling my analysis like follow :

"./olap/viewOlap.html?name=/analysis/views/analyseapcms&new&mdx=select NON EMPTY Crossjoin(Hierarchize(Union({[Delai].[All Delais]}, [Delai].[All Delais].Children)), {[Measures].[qte]}) ON COLUMNS, "
+ " NON EMPTY Hierarchize(Union({[Const/Produits].[All Const/Produitss],[Const/Produits].[All Const/Produitss].[" + $F{F_LIB_CONST} + "]},"
+ " [Const/Produits].[All Const/Produitss].[" + $F{F_LIB_CONST} + "].Children)) ON ROWS "
+ " from [Encours] "
+ " where ([Secteur].[All Secteurs].[Audio-vidéo], [Constructeur].[All Constructeurs].[" + $F{F_LIB_CONST} + "], Sites=[Sites].[All Sitess].[APCMS])"

If you have any idea
Thanks

rbaudchon's picture
Joined: May 6 2007 - 11:30pm
Last seen: 12 years 5 months ago

3 Answers:

0

You cannot pass parameters to the analysis view like that.

 

Can you expand the pararmeters yourself in a report, say, and generate the complete MDX query?

 

 

Sherman

Jaspersoft

swood's picture
2457
Joined: Jun 21 2006 - 12:48pm
Last seen: 6 years 12 months ago
0

Hi Sherman,

thanks for your answer.

It's strange, because I have done it before without this kind of issue.

By expand parameters, you mean to put the value hardcoded in order to test without using $F{...}.

I will try and let you know

Remi

 

 

.

 

rbaudchon's picture
Joined: May 6 2007 - 11:30pm
Last seen: 12 years 5 months ago
0

HI Sherman,

I have done several test directly on the OLAP analysis using mdx query.

I have got an error message saying something wrong in dimension=member.

So I have copy the correct MDX query in to my hypertext link, add some parameters and now it works fine.

This is the syntaxe i'm using now in my report :

"./olap/viewOlap.html?name=/analysis/views/analyseapcms&new&mdx=select NON EMPTY Crossjoin(Hierarchize(Union({[Delai].[All Delais]}, [Delai].[All Delais].Children)), {[Measures].[qte]}) ON COLUMNS,"
+ " NON EMPTY {[Produit].[All Produits].[" + $F{F_LIB_CONST} + "]} ON ROWS "
+ " from [Encours] "
+ " where ([Secteur].[All Secteurs].[Audio-vidéo], [Sites].[All Sitess].[APCMS])"

I do not understand what was the difference with the earlier version, but it works.

 

Thanks for your support

Remi

rbaudchon's picture
Joined: May 6 2007 - 11:30pm
Last seen: 12 years 5 months ago
Feedback