dashboard and analysis

Posted on June 2, 2009 at 7:47am
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

JasperReports® Server
rbaudchon's picture
rbaudchon
306
Joined: May 6 2007 - 11:30pm
Last seen: 15 years 10 months ago

3 Answers:

Posted on June 3, 2009 at 12:55am

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
swood
20595
Joined: Jun 21 2006 - 12:48pm
Last seen: 10 years 5 months ago
Posted on June 3, 2009 at 2:48am

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
rbaudchon
306
Joined: May 6 2007 - 11:30pm
Last seen: 15 years 10 months ago
Posted on June 3, 2009 at 4:57am

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
rbaudchon
306
Joined: May 6 2007 - 11:30pm
Last seen: 15 years 10 months ago
Feedback