<%// UseOLAPData:%>

    <%
    // To use OLAP data, you must know the name of the OLAP host server and
    // connect to that server using a valid username and password. To build
    // a graph, you can pass a valid MDX query statement to the OLAP server.

    /************************************************************************
     * To run this sample, you must edit the String and int declarations    *
     * below so that they define a valid MDX query, username, and password  *
     * for accessing your OLAP data                                         *
     ************************************************************************/

    // This sample application generates a pie chart that shows product sums
    // for selected products, years, and countries. The sample
    //    1) Creates strings to store the MDX query, the OLAP server name,
    //       and the connection port. The result set from the query is
    //       used to create an OLAPDataSet.
    //    2) Creates a PieChartOLAPDataModel. The model's constructor
    //       specifies the OLAPDataSet as an argument.
    //    3) Creates an OLAPPieChart and specifies the
    //       PieChartOLAPDataModel as its data model.
    %>

    <%@page import="
            com.sas.servlet.tbeans.olapgraphics.html.OLAPPieChart,
            com.sas.graphics.components.piechart.PieChartOLAPDataModel,
            com.sas.storage.olap.sasmdx.OLAPDataSet"
    %>

    <%
       // 1) Create strings to store the MDX query, the OLAP server name,
       // and an int to store the connection port.

       /******* modify query to access your data **********/
       String OLAP_QUERY="SELECT CROSSJOIN({[GEOGRAPHIC].[COUNTRY].MEMBERS},"
                       + "{[PRODUCTLINE].[PRODUCT].MEMBERS}) ON COLUMNS,"
                       + "{[TIME].[YEAR].MEMBERS} ON ROWS "
                       + "FROM PRDMDDB WHERE ([Measures].[ACTUAL_SUM])"; // specify valid OLAP source
       String OLAP_SERVER="myOLAPServer.com"; // specify a valid server name
       int OLAP_PORT=9999;  // specify a valid port

       // 2) Create a PieChartOLAPDataModel and specify
       // an OLAPDataSet as an argument on the constructor.
          PieChartOLAPDataModel olapDataModel = null;
          try {
              // OLAPDataSet arguments: host, port, username, pwd, query
                 olapDataModel=new PieChartOLAPDataModel(
                 new OLAPDataSet(OLAP_SERVER, OLAP_PORT, "myLoginName", "myPwd",
                                 OLAP_QUERY), true);
              } catch (Exception ex) { ex.printStackTrace(); }
    %>

    <%
       // 3) Create an OLAPPieChart and specify the
       // PieChartOLAPDataModel as its data model.
          OLAPPieChart pieChart=new OLAPPieChart();
          pieChart.setDataModel(olapDataModel);

       // Set a width and height for the chart
          pieChart.setWidth(640);
          pieChart.setHeight(520);

       // Set HTTP-specific response and request functionality
          pieChart.setResponse(response);
          pieChart.setRequest(request);

       // Write the chart to the display
          pieChart.write(out);
    %>