Thread: 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]}.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.

Try passing a String.valueOf(myInteger) into the method instead.

// Json

Thanks for the reply.But how do i do this conversion in the query?Please provide a sample query.

What does the code look like where you write your query which blows up?

// Json