Loading...
Helix SwarmHelix Swarm
Loading...

taglib.jsp

  • //
  • guest/
  • paul_dymecki/
  • mondrian/
  • webapp/
  • taglib.jsp #1
  • View
  • Commits
  • Open Download .zip Download (4 KB) 
  1. <%@ page language="java" %>
  2. <%--
  3. // $Id: //guest/paul_dymecki/mondrian/webapp/taglib.jsp#1 $
  4. // This software is subject to the terms of the Common Public License
  5. // Agreement, available at the following URL:
  6. // http://www.opensource.org/licenses/cpl.html.
  7. // (C) Copyright 2002 Kana Software, Inc. and others.
  8. // All Rights Reserved.
  9. // You must accept the terms of that agreement to use this software.
  10. //
  11. // Andreas Voss, 27 March, 2002
  12. --%>
  13. <%@ taglib uri="/WEB-INF/mdxtable.tld" prefix="mdx" %>
  14. <html>
  15. <head>
  16.   <title>Mondrian MDX Table Taglib Demo</title>
  17. </head>
  18. <body>
  19.  
  20. <mdx:query name="query1" resultCache="true">
  21. select
  22.   {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,
  23.   CrossJoin(
  24.     { [Promotion Media].[All Promotion Media].[Radio],
  25.       [Promotion Media].[All Promotion Media].[TV],
  26.       [Promotion Media].[All Promotion Media].[Sunday Paper],
  27.       [Promotion Media].[All Promotion Media].[Street Handout] },
  28.     [Product].[All Products].[Drink].children) on rows
  29. from Sales
  30. where ([Time].[1997])
  31. </mdx:query>
  32.  
  33. <mdx:query name="query2" resultCache="true">
  34. select
  35.   [Product].[All Products].[Drink].children on rows,
  36.   CrossJoin(
  37.     {[Measures].[Unit Sales], [Measures].[Store Sales]},
  38.     { [Promotion Media].[All Promotion Media].[Radio],
  39.       [Promotion Media].[All Promotion Media].[TV],
  40.       [Promotion Media].[All Promotion Media].[Sunday Paper],
  41.       [Promotion Media].[All Promotion Media].[Street Handout] }
  42.     ) on columns
  43. from Sales
  44. where ([Time].[1997])
  45. </mdx:query>
  46.  
  47. <mdx:query name="query3" resultCache="true">
  48. select
  49.   {[Measures].[Unit Sales], [Measures].[Store Sales]} on columns,
  50.   Order([Product].[Product Department].members, [Measures].[Store Sales], DESC) on rows
  51. from Sales
  52. </mdx:query>
  53.  
  54. <mdx:query name="query4" resultCache="true">
  55. select
  56.   [Product].[All Products].[Drink].children on columns
  57. from Sales
  58. where ([Measures].[Unit Sales], [Promotion Media].[All Promotion Media].[Street Handout], [Time].[1997])
  59. </mdx:query>
  60.  
  61. <mdx:query name="query5" resultCache="true">
  62. select
  63.   NON EMPTY CrossJoin([Product].[All Products].[Drink].children, [Customers].[All Customers].[USA].[WA].Children) on rows,
  64.   CrossJoin(
  65.     {[Measures].[Unit Sales], [Measures].[Store Sales]},
  66.     { [Promotion Media].[All Promotion Media].[Radio],
  67.       [Promotion Media].[All Promotion Media].[TV],
  68.       [Promotion Media].[All Promotion Media].[Sunday Paper],
  69.       [Promotion Media].[All Promotion Media].[Street Handout] }
  70.     ) on columns
  71. from Sales
  72. where ([Time].[1997])
  73. </mdx:query>
  74.  
  75. <mdx:query name="query6" resultCache="true">
  76. select from Sales
  77. where ([Measures].[Store Sales], [Time].[1997], [Promotion Media].[All Promotion Media].[TV])
  78. </mdx:query>
  79.  
  80.  
  81.  
  82. <h1>Mondrian Taglib Examples</h1>
  83.  
  84. <h3>CrossJoin Example 1</h3>
  85.  
  86. The current slicer is <strong><mdx:transform query="query1" xsltURI="/WEB-INF/mdxslicer.xsl" xsltCache="true"/></strong>.
  87. <p>
  88. <mdx:transform query="query1" xsltURI="/WEB-INF/mdxtable.xsl" xsltCache="false"/>
  89.  
  90.  
  91. <h3>CrossJoin Example 2</h3>
  92.  
  93. The same thing the other way round. The current slicer is <strong><mdx:transform query="query2" xsltURI="/WEB-INF/mdxslicer.xsl" xsltCache="true"/></strong>.
  94. <p>
  95. <mdx:transform query="query2" xsltURI="/WEB-INF/mdxtable.xsl" xsltCache="false"/>
  96.  
  97.  
  98. <h3>Simple Table</h3>
  99. <mdx:transform query="query3" xsltURI="/WEB-INF/mdxtable.xsl" xsltCache="false"/>
  100. <p>
  101.  
  102. <h3>1-dim Table</h3>
  103. A One dimensional table. Slicer is 
  104. <strong>"<mdx:transform query="query4" xsltURI="/WEB-INF/mdxslicer.xsl" xsltCache="false"/>"</strong>
  105.  
  106. <p>
  107. <mdx:transform query="query4" xsltURI="/WEB-INF/mdxtable.xsl" xsltCache="false"/>
  108.  
  109.  
  110. <h3>CrossJoin on both axes</h3>
  111. Here is the slicer: <strong>"<mdx:transform query="query5" xsltURI="/WEB-INF/mdxslicer.xsl" xsltCache="false"/>"</strong>
  112. <p>
  113. <mdx:transform query="query5" xsltURI="/WEB-INF/mdxtable.xsl" xsltCache="false"/>
  114.  
  115. <h3>0-dim example</h3>
  116. 0-dim "tables" may be useful, if you want to display calculated numbers in a form or
  117. text. For example, the Store Sales were
  118. <mdx:transform query="query6" xsltURI="/WEB-INF/mdxvalue.xsl" xsltCache="false"/>
  119. in 1997 for TV promoted products.
  120. <p>
  121. </body>
  122. </head>
# Change User Description Committed
#1 1820 Paul Robert Dymecki mondrian: Integrate latest from //guest/julian_hyde 23 years ago
//guest/julian_hyde/mondrian/webapp/taglib.jsp
#1 1603 Julian Hyde mondrian:
Add Andreas' taglib;
Rename 'mondrian.rolap.Util.assert' to 'assertTrue', becau...se 'assert' is a keyword in jdk 1.4;
Fix 'NON EMPTY';
JUnit framework for tests;
Add Oracle dataset. «		 23 years ago