O'Reilly logo

Special Edition Using® Crystal Reports® 10 by Roger Sanborn, Steve Lucas, Kathryn Hunt, Joe Estes, Michael Voloshko, James Edkins, Bob Coates, Naisan Geula, Ryan Marples, Neil FitzGerald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Crystal Analysis in the Real World—MDX

As mentioned in the previous section, the primary exposure that a Crystal Analysis designer has to MDX or Crystal OLAP Syntax is in the creation of custom calculations not already available in the data source. This section provides some real-world examples of MDX in action to facilitate some quick learning. Table 20.5 highlights a few sample calculations, their purpose and a quick explanation of their components.

Table 20.5. MDX Samples
CalculationDescriptionMDX and/or Crystal OLAP Syntax
Member NameOften in Financial Reporting, the repetition of the Member Name is required in the middle of the worksheet (see Figure 20.19). This can be accomplished using the MDX CurrentMember and Name functions. In Figure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required