In this chapter, we're going to cover how to construct the analysis in Presentation Services. We've already discussed the back-end side of the BI Server. Now we're going to learn how to use the presentation tables that are stored in the BI repository.
After building the BI repository, it's time to execute queries against the organized data by using a set of graphical tools. OBIEE enables end users to construct web-based reports easily. We don't have to install anything on the computers to construct analysis. We're just going to log in to Presentation Services and access the Analysis Editor.
So we're going to create a simple analysis and then explore the default properties of the analysis. Formatting techniques are going to be covered in this chapter and we'll also learn how to eliminate some rows from the result set by using filters, selections, and column prompts. This will allow end users to create their own reports and focus only on certain business data.