Objectives
After completing this lesson, you will be able to:
The dimension objects in the list come from different universes, so Web Intelligence cannot automatically merge the dimensions. If you try to combine data from the two objects in a single block, Web Intelligence will not automatically be able to interpret the relationship between them.
See the following video to learn more about synchronizing data from multiple sources.
In this demonstration, you show learners how to merge dimensions manually from queries on the eFashion.unx and the eStaff.unx universes.
Continue working with the Multi Block 4 document.
In the Show document objects area, select the Store object.
The Store object, an object that you used in the Employee query, is highlighted.
Note
All the other dimension objects listed in the Show document objects panel are now displayed in italics. These objects are highlighted in italics because they are all the same type of object as the Store object: that is, they are all dimension objects.
Web Intelligence indicates that you could choose to merge the selected object with any of the other dimension objects in the queries in this document. In this case, you want to merge the Store object with the Store name objects used in the queries you built using the eFashion universe. The names of these objects are different, but they retrieve the same type of data.
Press and hold the Ctrl key, and choose Store Name.
Choose the ellipsis icon next to Store Name, and choose Merge.
In the Show document objects area, the merged Store name dimension includes the Store object from the eStaff.unx universe, and the number of employees aggregates correctly. This is known as synchronizing data using merged dimensions.
When you project data into a block using this merged Store name dimension, it retrieves data from the Employee query also, using the eStaff.unx universe and data source. When you merge dimensions, Web Intelligence creates a new dimension that retrieves all the values from all the original dimensions that make up the merged dimension.
Note
You may have to refresh the document after merging dimensions.Save the document as Multi Block 5.
You use this document in the next demonstration.
There are a number of rules to remember when merging objects from multiple queries.
Examples of dimension and attribute objects are Store name and Store.
If one object is character-based and the other object is numeric, you cannot link the objects as they do not share a common data format.
Even though the objects FY13 and the 2013 both refer to a year, they are in a different format and therefore have two separate values. Extra spaces in some values can also mean that the objects cannot be merged.
There are many possible advantages of merging personal data to universe data, including the ability to do the following:
Synchronize the data from the universe and the local data provider, just like when you combine data from separate universes. Use Merge to select common objects from queries on different data sources and merge them into a single object.
Remember that the objects must be the same data type and retrieve semantically related data in order for them to qualify as merged.
Log in to track your progress & complete quizzes