US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: problem with JPivot "clickable" tag

  1. #1
    Join Date
    Sep 2013
    Posts
    2

    Default problem with JPivot "clickable" tag

    Hello everyone,
    I am writing to see if someone can help me to use the clickable tag in my OLAP web application, that uses Mondrian and JPivot.
    I try to explain what is my problem: with my OLAP cube I want to calculate the number of documents by author, date of publication, topic, etc..
    I also added a dimension Document, with the level named Document, to store the path/url of each document.
    Using the clickable tag in mondrian.jsp, I can see the members of the Document level as hyperlink but when I click on one of them it gives me an error page.


    This is what I put it in my mondrian.jsp




    <jp:mondrianQuery
    id="query01"

    select
    {[Measures].[Count_Doc]}on columns,
    {[Document].[All Document].Children}on rows

    from Fact_table

    <jp:clickable urlPattern="/otherpage.jsp?param={0}" uniqueName="[Document]"/>
    </jp:mondrianQuery>




    Can someone help me?
    Thanks in advance
    Greetings
    ticemba

  2. #2
    Join Date
    Sep 2013
    Posts
    2

    Default

    Hello everybody,
    I've solved the problem in this way:

    1) I added the following string in the ..\mywebapp\WEB-INF\queries\mondrian.jsp

    <jp:mondrianQuery
    id="query01"

    select
    {[Measures].[Count_Doc]}on columns,
    {[Document].[All Document].Children}on rows

    from Fact_table

    <jp:clickable urlPattern="/test/otherpage.jsp?param={0}" uniqueName="[Document]"/>
    </jp:mondrianQuery>

    2) Then I created the jsp page ..\mywebapp\test\otherpage.jsp with the following code


    <%
    String par = request.getParameter("param1");
    // New location to be redirected
    String site = par.substring(par.lastIndexOf('[')+1,par.lastIndexOf(']'));
    response.setStatus(response.SC_MOVED_TEMPORARILY);
    response.setHeader("Location", site);
    %>

    Greetings
    ticemba

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •