Showing entries 1 to 1
Displaying posts with tag: mondrian mdx formatting olap4j (reset)
Formatting MDX as plain text

When Mondrian tools output MDX results as text, such as in the cmdRunner utility, we've been using the same old crappy format for years. For example, the query

select
crossjoin(
{[Time].[1997].[Q1], [Time].[1997].[Q2].[4]},
{[Measures].[Unit Sales], [Measures].[Store Sales]}) on 0,
{[USA].[CA].[Los Angeles],
[USA].[WA].[Seattle],
[USA].[CA].[San Francisco]} on 1
FROM [Sales]

is formatted as

Axis #0:
{}
Axis #1:
{[Time].[1997].[Q1], [Measures].[Unit Sales]}
{[Time].[1997].[Q1], [Measures].[Store Sales]}
{[Time].[1997].[Q2].[4], [Measures].[Unit Sales]}
{[Time].[1997].[Q2].[4], [Measures].[Store Sales]}
Axis #2:
{[Store].[All Stores].[USA].[CA].[Los Angeles]}
{[Store].[All Stores].[USA].[WA].[Seattle]}
{[Store].[All Stores].[USA].[CA].[San Francisco]}
Row #0: 6,373
Row #0: 13,736.97
Row #0: 1,865
Row #0: …
[Read more]
Showing entries 1 to 1