Dashboard Development in DD

When the query is built on top of the Universe, next is to bound the result into a spreadsheet and map the Dashboard components with data. Now to insert the query result into a spreadsheet, select a particular result object and use the option "Insert in Spreadsheet" at the left bottom corner of the screen. This will bind the result set of that object to the "Select Range" dialog box.

Insert in Spreadsheet

In the above screenshot, you can see .unx file that shows the Universe name on which the query is created. Below that you have Result Objects - objects selected at the time of query building. On the right side of the screen, you have a spreadsheet where the result set from the query is bound.