xaction to view Analysis View with Prompt/Secure Filter

[dibe0015]

Hi,

I have the following problem:
I created a new Analysis View with the User Console and saved the result as an xaction. Now I want to edit the xaction using the Design Studio to be able to set some input parameters with the "Prompt/Secure Filter".
Whenever I try the xaction, I can enter the parameters but if I don't set the "mode" from the Pivot View I get the error

An error occurred while rendering Pivot.jsp. Please see the log for details. Whenever I do set the parameter "execute" I only see


Action Successful
model=solution:/bi-developers/analysis/ThesisFaktura_1126_1115.xml
connection=Thesis
....


I searched for answers in the forum and wiki but I didn't get a answer that would help me.

Benjain

[dibe0015]

Hi,

I had a closer look at it and I found out that it uses a different URL whenever I use the "Prompt/Secure Filter"

URL of the result with "Prompt/Secure Filter"
http://localhost:8080/pentaho/ViewAction?&

URL of the result without "Prompt/Secure Filter"
http://localhost:8080/pentaho/Pivot?

Is this a known issue? Am I just blind maybe from trying it out all day long?

Benjamin

[dibe0015]

Hi,

I'm sorry for bringing it up again, but am I the only one ever having problems with it?
Did nobody ever tried to use parameters for the MDX query using the Prompt/Secure Filter ?

Benjamin

[dibe0015]

Hi,

I'm still working on that problem, but without a solution so far.

I tried to use one xaction for the Secure Filter and then pass the parameters to a sub xaction that only has a Pivot Viewer. But even that doesn't work? Is there any how-to in this world that shows how to use parameters with Pivot Views? :mad:

[neroliang]

Hi, I have encountered the same problem here, "A pivot is...", but it seems to be a trial one, when I append my parameter "mode"(without any appointed value), it simply works. I guess the pivot view just need to check on that matter.

But I am sorry that I didn't quite understand what do you mean by saying "execute" parameter. And why is it necessary?

[dibe0015]

Hi,

are you using the secure filter or just the pivot view?

I didn't explain it very good with the "execute". When I just appended the parameter "mode" without a value i got an error. Thats why I tried to set the value to "execute"

Benjamin

[abbottk]

Once I prompt for any kind of input through Secure Filter (even if don't use th input) I also get the
"An error occurred while rendering Pivot.jsp. Please see the log for details."

Kirk.

[abbottk]

I have spent some time and found a link at:
http://jira.pentaho.com/browse/PLATFORM-858
which discusses a related problem.

There is file:
http://jira.pentaho.com/secure/attachment/11127/securefilter_and_pivotview.xaction
on that page which works. Using that approach I have been able to get our code to work as well. But because it uses the data directly from the filter without any manipulation (such as handling multiple selects etc) it may not be robust for general MDX generation.

Kirk.

[dibe0015]

Hi Kirk,

thank you very much for the links. I already felt stupid because it seemed like nobody in this forum answering me could really understand or reproduce the problem I have.

I don't understand why the case is closed in the jira since the problem obviously still exists. It can't be the final solution to use a workaround all the time.

Benjamin

[karate405]

Hi,

both of URLs below cann`t be accessed.
does anybody know detail?

http://jira.pentaho.com/browse/PLATFORM-858
http://jira.pentaho.com/secure/attac...otview.xaction

Best regards,

karate405