Creating a query on the Business Layer using Query Panel

Now, on the Business Layer defined previously we can create a query using Query Panel, and then execute it. We can do this by following these steps:

1. Choose Queries on the Business Layer panel:

1. Click on the Insert Query button to open Query Panel
2. Expand each of the folders listed in the previous table and drag the corresponding dimension and measures to Result Objects for Query Panel
3. Choose OK
4. Now execute the query by clicking on the Execute Query button

Publish the Business Layer as a Universe to the BI platform repository:

1. Choose the UNI_relational_data project File | Save All
2. Right-click UNI_eFashion and choose Publish | To a Repository
3. Choose Check all, click on the Check Integrity button, and click Next
4. Choose Finish

We just created a Universe with the IDT that accesses a SAP HANA database. The same can be done for all other data sources. As discussed earlier, data sources (SAP HANA and SAP BW) can be directly accessed without using a Universe. By following these steps to directly access the data sources (SAP BW and SAP HANA ), the readers create their own, as a kind of assignment for this chapter.