<%@ page language="java" %>
<%--
// $Id: //guest/julian_hyde/mondrian/webapp/taglib.jsp#1 $
// This software is subject to the terms of the Common Public License
// Agreement, available at the following URL:
// http://www.opensource.org/licenses/cpl.html.
// (C) Copyright 2002 Kana Software, Inc. and others.
// All Rights Reserved.
// You must accept the terms of that agreement to use this software.
//
// Andreas Voss, 27 March, 2002
--%>
<%@ taglib uri="/WEB-INF/mdxtable.tld" prefix="mdx" %>
Mondrian MDX Table Taglib Demo
select
{[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} on columns,
CrossJoin(
{ [Promotion Media].[All Promotion Media].[Radio],
[Promotion Media].[All Promotion Media].[TV],
[Promotion Media].[All Promotion Media].[Sunday Paper],
[Promotion Media].[All Promotion Media].[Street Handout] },
[Product].[All Products].[Drink].children) on rows
from Sales
where ([Time].[1997])
select
[Product].[All Products].[Drink].children on rows,
CrossJoin(
{[Measures].[Unit Sales], [Measures].[Store Sales]},
{ [Promotion Media].[All Promotion Media].[Radio],
[Promotion Media].[All Promotion Media].[TV],
[Promotion Media].[All Promotion Media].[Sunday Paper],
[Promotion Media].[All Promotion Media].[Street Handout] }
) on columns
from Sales
where ([Time].[1997])
select
{[Measures].[Unit Sales], [Measures].[Store Sales]} on columns,
Order([Product].[Product Department].members, [Measures].[Store Sales], DESC) on rows
from Sales
select
[Product].[All Products].[Drink].children on columns
from Sales
where ([Measures].[Unit Sales], [Promotion Media].[All Promotion Media].[Street Handout], [Time].[1997])
select
NON EMPTY CrossJoin([Product].[All Products].[Drink].children, [Customers].[All Customers].[USA].[WA].Children) on rows,
CrossJoin(
{[Measures].[Unit Sales], [Measures].[Store Sales]},
{ [Promotion Media].[All Promotion Media].[Radio],
[Promotion Media].[All Promotion Media].[TV],
[Promotion Media].[All Promotion Media].[Sunday Paper],
[Promotion Media].[All Promotion Media].[Street Handout] }
) on columns
from Sales
where ([Time].[1997])
select from Sales
where ([Measures].[Store Sales], [Time].[1997], [Promotion Media].[All Promotion Media].[TV])
Mondrian Taglib Examples
CrossJoin Example 1
The current slicer is .
CrossJoin Example 2
The same thing the other way round. The current slicer is .
Simple Table
1-dim Table
A One dimensional table. Slicer is
""
CrossJoin on both axes
Here is the slicer: ""
0-dim example
0-dim "tables" may be useful, if you want to display calculated numbers in a form or
text. For example, the Store Sales were
in 1997 for TV promoted products.