Creating a SAP BusinessObjects Analysis workbook based on an existing BEx query

Now, let's see how we can create a SAP BusinessObjects Analysis workbook based on an existing BEx query: 

1. Start BusinessObjects Analysis, the Microsoft Excel edition, go to the options and then mark Preferred Platform as Selectable.
2. Like before, this will allow us to choose either NetWeaver or BI platform so that we can save our workbooks.
3. Insert the BEx query U00_SAPB1_Q1 starting at cell A1 (this query is available via the connection BW_RWB_OLAP, in the Area BW training. Go to Customer Training | T_SAPBI | eFashion cube. As we would be using the same template data, use query and Universe from eFashion).
4. The system will prompt for a username and password for BI platform; enter these details.
5. In the query, remove all the attributes from ROWS, and then add STATE, STORE, and CATEGORY, in this order. Then, swap the STATE and STORE columns directly in the body of the workbook. Change the order of Measures.
6. Restore the initial order of Measures and characteristics. Make sure that the report does not refresh after each action.
7. Remove the STORE attribute from ROWS and define the following filter settings for STATE:
   1. Display California and Florida
   2. Display all again
   3. Display all except California

1. The mock up data has an organization of categories called category hierarchy one related to gender. We can display this hierarchy in our workbook. 

1. Now we will just keep CATEGORY and STATE in ROWS, and sort the result set by CATEGORY (descending).
2. Filter the result set by the AMOUNT_SOLD measure to only include the top three amounts sold.
3. Remove the top N filter on AMOUNT_SOLD and add a custom local calculation percent contribution by AMOUNT_SOLD.
4. We can save STATE of our analysis as an analysis view called BW_State_and_Category.
5. Save our workbook in the BI platform and reopen and refresh the workbook we have just saved.