Forums : Technical Issue Help
Dear Open Hub Users,
We’re excited to announce that we will be moving the Open Hub Forum to
https://community.blackduck.com/s/black-duck-open-hub.
Beginning immediately, users can head over,
register,
get technical help and discuss issue pertinent to the Open Hub. Registered users can also subscribe to Open Hub announcements here.
On May 1, 2020, we will be freezing https://www.openhub.net/forums and users will not be able to create new discussions. If you have any questions and concerns, please email us at
[email protected]
slicer dimension in MDX
hi ,
I have a doubt in MDX query in jpivot.When i pass a dimension which has text values as a slicer dimension in the where condition it is working fine.But when i pass an integer type dimension in the where condition i am getting the following exception:
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: ERROR: function upper(integer) does not exist
Let me explain this with an example:I have two dimensions in my cube:location and year.I have a measure say no.of products sold.If i want the report for a particular location I pass this in the where condition like : where {[location].[All location].[Boston]} and its working .But when i want the report for a particular year i am trying with the following :{[year].[All year].[1991]}.But i am getting the above mentioned exception.please help me.
