You can drag different measures and dimension values to the Layout panel to create a Crosstab and Chart in the Analysis pane. You can see the name of InfoCube/Modeling View under Data tab in the Task panel.
When you click the OK button, all the measures and dimension values will be added to metadata explorer under the new workspace. Select InfoCube from the source system and click the OK button. You can also perform a search with the name of InfoCube/Modeling View in the source system. When you select “All” from the dropdown list, you can see −Ĭlick the Next button and you will see a list of all the Modeling Views/InfoCubes in the source system that are pointed using this OLAP connection. You can select from the dropdown list to view all the connections or the connections pointing to Cube/InfoProvider or to Query/Query View to connect to BW OLAP source. When you click the New button, you will be prompted to select a data source. To create a new workspace, you have to click the New button - Create a new workspace. You can swap axis, create sub-analysis, define nulls and zeros, etc. Insert ─ Under the Insert tab, you can add Crosstabs and insert different type of charts.ĭisplay ─ Under the Display tab, you can manipulate data under crosstab. Crosstab and Charts are based on the values selected in the Layout panel.Īnalyze ─ Under the Analyze tab, you have an option to apply Filter and Sort. In the right pane, you have Analysis Panel, Crosstab, and Chart. You can use the Background option to filter the data in background based on Dimension values. You have to drag different measures and dimensions to the corresponding columns and rows. In the middle pane, you have the Layout option, which defines the layout of Crosstab. You can see different measure and dimension values. On the left side you have a metadata explorer, where all the objects from OALP data source is displayed. You can even change an OLAP connection or remove a connection in the workspace. Once you select the connection, you will be prompted to select an OLAP model.įollowing panels are available under the user interface −Īt the top, you have the task panel where you can perform different operations - Creating a new workspace, Open option, Save Option. It shows you a list of all OLAP connections to different database. When a new workspace is created, you have to select the data source. Analysis Edition for OALP tool can be opened via BI Launchpad. When a new workspace is opened, you can see different icons and panels in the user interface. How are products selling in each region at different times? (Product by Region and Time) How are products selling in each region? (Product by Region) How are products selling at different times of year? (Product by Time) Using a data cube, you can analyze the data in different ways to meet different business requirements. OLAP data model is also called a data cube. OLAP data source also allows hierarchy of data where you can drill to different data levels. Aggregated data can be analyzed much faster than relational data.
OLAP data represents the hierarchical aggregations of the individual transactions. What is an OLAP Data Source?Ī relational data source contains data in one format and to meet the business requirements, you need to create a multidimensional product. You can distribute Analysis workspace to large number of users over the web. You can also access SAP BO Analysis for Microsoft Office, which integrates Analysis with Microsoft Excel and PowerPoint.Īll the connections and Analysis workspaces are managed in Central Management Console (CMC). You should have tool installed on SAP BusinessObjects server and a connection from the local system to BI platform. You can see Analysis Edition for OLAP tool in the dropdown list. To open the application, navigate to Applications dropdown at the top of the screen. When you have BI server on the same system on which you are trying to access BI Launchpad, you can use the local host in the URL, otherwise you have to mention the name of BI server to open BI Launchpad. In the above link, localhost represents the Name of BI server. This tool can be accessed via BI Launchpad in a web browser using the following link − For example, you can have a workspace where data comes from SAP BW cube and also from Microsoft Analysis Cube. In Analysis edition for OLAP, you can connect to multiple data providers simultaneously. You create a new workspace, then add charts and crosstab objects and OLAP data sources to get the data into these objects. It helps business managers in decision making, and to analyze business data. Analysis edition for OLAP is a BI reporting tool using which you can connect to OLAP data sources.