Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Not possible to use '[' and ']' on requests when trying to filter a report through parameters

Description

We create an analyzer report and set some filters with parameters, which we can use on the URL to filter our report.

So, when we try to open the report filtered by Months:
http://localhost:8080/pentaho/Home?name=deeplink&startup-url=%2Fpentaho%2Fapi%2Frepos%2F%253Ahome%253Aadmin%253Adeeplink.xanalyzer%2Feditor?Months=[Time].[2003].[QTR1].[Mar]

we have the following error, on 8.2 GA:

Check the attached video that reproduces the issue.

My suggestion is to take a look at the developments done on Spring Security and Apache Tomcat upgrade. This issue was not reproduced in 8.1 GA, on 8.1 GA is working as expected.

NOTES FOR QA/DEV:

  • we need to validate according to the Steps to Reproduce

  • we need to test the scenario that a user in PSW define a cube with name C1--=_+|;"?<>~: and in a analyzer report we open the MDX console through the "More actions and options".

SOLUTION check the workaround field.

Environment

8.2 GA 8.2.0.4

Steps to Reproduce

  1. Login to PUC as admin.

  2. Create a new Analyzer report using Steel Wheels data source.

  3. Add Years, Quarters and Months to the report.

  4. Filter the report by Year using Select a range option with the next condition:

    1. Years is |Before (and incl.)| |2005|

    2. Set parameter name: Year

  5. Add a filter for Quarters using Select a range option with the next condition:

    1. Quarters is |Between (and incl.)| |QTR1| and |QTR3| (select the first values in the drop-down that are related to 2003 year)

    2. Set parameter name: Quarter

  6. Add a filter for Months using Select a range option with the next condition:

    1. Months is |After (and incl.)| |Feb|

    2. Set parameter name: Month

  7. Save the report.

  8. On the report tab, right-click and create a deep link.

  9. Copy and past the deep link in a new window.

  10. After "editor" word, add "?Year=2004" and press ENTER.

  11. Check the report is render and Year is filter by 2004

  12. After "editor" word, add "?Month=[Time].[2004].[QTR2].[May]" and press ENTER.

  13. The report is not render here and previous was working.

Workaround

None

Attachments

1

Activity

Show:

Bruno Edgar Cardoso da Costa July 3, 2019 at 2:47 PM

Validated: pentaho-server-ee-9.0.0.0-74 [QAT] 

Fixed

Details

Assignee

Reporter

Edit Screen Preamble

<div class="notify info" style="margin-bottom: 10px;">
If you are a Pentaho customer, please use the <a href="http://support.pentaho.com">Customer Support portal</a> to log issues.
<p />
This system is used for logging bugs and enhancement requests only. Please use our <a href="https://community.pentaho.com">community at https://community.pentaho.com</a> if you have questions, configuration issues, or have an issue with a marketplace plugin as Pentaho does not support marketplace plugins unless written by Pentaho.
<p />
Lastly, when creating a bug, please provide as much detail as possible. To prevent unnecessary delays in reviewing your issue, please attach complete server logs, SQL/MDX logs where applicable, schemas, etc. Also, screen-shots and screen-cams are especially helpful in demonstrating the issue.
<p />
Thank-you so much,<br />
The Pentaho Team
</div>

Notice

<div class="notify info" style="margin-bottom: 10px;">
When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
</div>

Sprint Team

Story Points

Components

Fix versions

Affects versions

Priority

Created March 22, 2019 at 5:25 PM
Updated March 3, 2023 at 6:45 PM
Resolved August 30, 2019 at 1:49 PM