User manual BUSINESS OBJECTS WEB INTELLIGENCE RICH CLIENT XI 3.0

[. . . ] Web Intelligence Rich Client User's Guide BusinessObjects Web Intelligence Rich Client XI 3. 0 Copyright © 2008 Business Objects, an SAP company. patents, which may cover products that are offered and licensed by Business Objects: 5, 295, 243; 5, 339, 390; 5, 555, 403; 5, 590, 250; 5, 619, 632; 5, 632, 009; 5, 857, 205; 5, 880, 742; 5, 883, 635; 6, 085, 202; 6, 108, 698; 6, 247, 008; 6, 289, 352; 6, 300, 957; 6, 377, 259; 6, 490, 593; 6, 578, 027; 6, 581, 068; 6, 628, 312; 6, 654, 761; 6, 768, 986; 6, 772, 409; 6, 831, 668; 6, 882, 998; 6, 892, 189; 6, 901, 555; 7, 089, 238; 7, 107, 266; 7, 139, 766; 7, 178, 099; 7, 181, 435; 7, 181, 440; 7, 194, 465; 7, 222, 130; 7, 299, 419; 7, 320, 122 and 7, 356, 779. Business Objects and its logos, BusinessObjects, Business Objects Crystal Vision, Business Process On Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications, Crystal Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal Vision, Desktop Intelligence, Inxight and its logos , LinguistX, Star Tree, Table Lens, ThingFinder, Timewall, Let There Be Light, Metify, NSite, Rapid Marts, RapidMarts, the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or registered trademarks in the United States and/or other countries of Business Objects and/or affiliated companies. SAP is the trademark or registered trademark of SAP AG in Germany and in several other countries. [. . . ] But it does not make sense to merge unrelated dimensions even when their data types are the same. For example, it does not make sense to merge a dimension containing customer names with a dimension containing sales regions. Merged dimensions often have the same name in both data sources, but this is not obligatory. It can make sense to merge dimensions with different names if they contain related data. To merge dimensions correctly you need to be aware of the semantics of the data (what the data refers to) in the different data sources. The dimension data types and names are an approximate guide only to dimensions' suitability for merging. 142 Web Intelligence Rich Client User's Guide Working with reports Merging dimensions from multiple data providers 10 Merged dimension example The following example with two data providers illustrates the effect of merging dimensions: Example: Merging City dimensions Data Provider 1: Country US US France France City New York Los Angeles Paris Toulouse Data Provider 2: City New York Los Angeles Paris Toulouse Revenue 100000 75000 90000 60000 If you merge the City dimensions and display the Country, merged City dimensions and Revenue measure in a table, Web Intelligence returns the following result: If the City dimensions are not merged, Web Intelligence displays the following result: Web Intelligence Rich Client User's Guide 143 10 Working with reports Merging dimensions from multiple data providers Country US US France France City New York Los Angeles Paris Toulouse Revenue 325000 325000 325000 325000 Because there is no link between the two data providers through a merged dimension, Web Intelligence is unable to relate the city revenues to countries. As a result Web Intelligence displays the total revenue against each Country/City pair. If the City dimensions are merged, Web Intelligence displays the following result: Country US US France France City New York Los Angeles Paris Toulouse Revenue 100000 75000 90000 60000 Forcing merged calculations with the ForceMerge function By default, Web Intelligence does not account for merged dimensions in calculations if the merged dimensions do not explicitly appear in the calculation context. 144 Web Intelligence Rich Client User's Guide Working with reports Merging dimensions from multiple data providers 10 Example: Calculating revenue with ForceMerge This example has two data providers as follows: Data Provider 1: Country US US France France City New York Los Angeles Paris Toulouse Data Provider 2: City New York Los Angeles Paris Toulouse Revenue 100000 75000 90000 60000 If you merge the [City] dimensions, then create a table with [Country] and [Revenue], Web Intelligence displays the following result: Country US US France Revenue 325000 325000 325000 Web Intelligence Rich Client User's Guide 145 10 Working with reports Merging dimensions from multiple data providers Country France Revenue 325000 Because [City], the merged dimension, does not appear in the table, Web Intelligence does not take the merge into account when calculating revenue. Web Intelligence lists the total revenue in the second data provider against each country. To display the correct result, replace [Revenue] in the second column with the formula ForceMerge([Revenue]): City US US France France Revenue 175000 175000 150000 150000 Web Intelligence now takes the relationship between countries and cities into account when calculating revenue. Note: If [Revenue] is a smart measure in the above example, ForceMerge([Rev enue]) returns #MULTIVALUE. This is because the grouping set (Country) does not exist for the [Revenue] measure. ForceMerge([smart_measure]) always returns #MULTIVALUE, unless by chance no aggregation is required to calculate the measure. 146 Web Intelligence Rich Client User's Guide Working with reports Merging dimensions from multiple data providers 10 Creating, editing and deleting merged dimensions To merge dimensions 1. Select the dimensions you want to merge in the boxes at the top of the dialog box. When you select a dimension, all dimensions of different data types are disabled because you cannot merge dimensions of different data types. You use this dialog box to specify the properties of the merged dimension. The source dimension provides the default name, description and number formats for the merged dimension. Type the merged dimension name in the Merged Dimension Name box and the merged dimension description in the Description box. The merged dimension name appears in the "Merged Dimensions" box and the dimensions that are part of the merged dimension appear in the boxes alongside it. Because an original dimension can be part of one merged dimension only, it no longer appears in the box above that lists the original dimensions in the query. Web Intelligenceadds the merged dimensions to the list of merged dimensions in the Data tab. To define a merged dimension You define a merged dimension in the "Create Merged Dimension" dialog box. Type the merged dimension description in the Description box Web Intelligence Rich Client User's Guide 147 10 Working with reports Merging dimensions from multiple data providers 3. To use the name and description of one of the source dimensions in the merged dimension, select the source dimension from the Source Dimension list. [. . . ] All four digits for year. `2003' with the format yy gives `03' `2003' with the format yyyy gives `2003' yyyy Web Intelligence Rich Client User's Guide 267 10 Working with reports Formatting numbers and dates Character(s) Display(s) Example h:mm:ss a The hour with no leading zeros and the minutes `21:05:03' with the format and seconds with leading h:mm:ss a gives `9:05:03 zeros. The hour according to the `21:00' with the format HH 24-hour clock. gives `21' The hour according to the `21:00' with the format hh 12-hour clock. `7. 15 am' with the format HH:mm gives `07:15' HH hh HH:mm HH:mm:ss The hour, minutes, and `7. 15 am' with the format seconds with leading ze- HH:mm:ss gives ros. [. . . ]