Viewing published data

Space Admins can view their published data through Space Management.

1. From Space Management, select View Published Data.
   

   

   
   
2. Data is split in to three menus: Dimension Data, Measure Data, and Stage Data.
   
3. Rest your cursor over the item and select either Preview Data or View Profile to learn more about the published data.
4. When viewing the processed data, users can modify information in the Data query and use Run Query to view the results of the data query.
   
5. Data shown in this view can be ordered, using the "ORDER BY" parameter.
6. When attempting to use order by with a measure column, you may face the following error: "Unable to retrieve results of query". This error is because you can't have an ORDER BY clause on an aggregated measure and a different aggregation on the same measure in the projection list of the SELECT, for example [Sum: Quantity] and [Max: Quantity]. Remove the extra aggregations for that measure in the SELECT statement and run the query again.