We have created the Analytic model to view the plantwise sales quantity. Let see how to build the report using the view on Analysis for Microsoft Excel.
- Goto Start menu > Program > Businessobjects > Analysis for Microsoft Excel.
- Goto Analysis tab and Select data source.
- Skip the logon screen to use the Local ODBC connection to HANA
- Select the HANA ODBC connection. Press next.
- Navigate to folder. Select the Analytic or Calculation views from the Package.
- Report will be generated based on the view.
- To Further build the report drag and drop the measures and dimensions in the columns and rows.