Data Store Merge at View Level

Check out the given walk-through on how to create a Data Store Merge at the view level.

Data Store Merge at the View level

The users can merge multiple data stores at the view level to compare different measure values across the merged datastores.

• Navigate to the Design New page.

• Drag and drop dimension(s) and measure(s) from the selected Data Store onto the canvas to create a view.

• Click the ALL DATA STORE option.

Creating a View by using the Design page with the first Data Store

• The Data Store dialog box opens.

• Search for a Data Store using the search bar.

• Click the Merge icon for the selected Data Store.

• The user gets redirected to select a related field from the drop-down menu.

• Click on the MERGE option.

• A success message appears to confirm the merge of the selected Data Stores.

• The selected Data Store gets added to the Data Store space, and a drop-down icon appears to choose any one Data Store out of the given choices.

• Drag and drop a measure from the newly added Data Store to create a comparative view.

Creating a comparative view by dragging a measure from another Data Store

• The user can add multiple Data Stores by using the same set of steps.

• Drag the required measures to add the corresponding fields in the view.

• Click the Save icon.

Saving the comparative View with based on Multiple Data Store

• A success message appears, and the view gets added to the storyboard.

• Click the Save icon from the storyboard to save the entire Story.

Saving the comparative view on the Storyboard

Please Note:

• All the merged data stores can be accessed for the saved view by using the ‘Edit’ option from the storyboard.

  • The user can modify the view by selecting the Edit option from the storyboard.

  

  • All the merged Data Stores can be accessed for that view even in the ‘Edit’ mode.

  • The user can change the title of a Saved View title by opening the Design New page of the view via the ‘Edit’ option.

• The Merged Data Stores do not get saved in the ‘ALL DATA STORE’ menu, so to add the subsequent new view based on merged data stores into the same business story, the users need to merge the data stores yet again.