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 ...

Get Special Edition Using® Crystal Reports® 10 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.