e-dokumen.id

Section 1.2.7, “Reporting Console,” on page 12 Section 1.2.8, “Operations Center Dashboard,” on page 131.2.1Data MartData Mart is a SQL Server database that Analysis Center creates for each AppManager Data Source.A Data Mart collects and processes data from Data Sources, and then stores it in fact and dimensiontables to be used by the Data Warehouse. A Data Mart serves the following purposes: Stores the data copied from the source databases for processing. Stored procedures process the copied data. Fact and dimension tables store the processed data. The fact tables function as a component of the Data WarehouseThe SQL Server agent uses SQL Server Integration Services (SSIS) packages to copy the data fromthe Data Source to the Data Mart, and then to the Data Warehouse.1.2.2Data WarehouseThe Data Warehouse consists of two relational databases and a multidimensional database. TheAC Warehouse and AC OLAP databases are used for AppManager reporting.The AC Configuration relational database includes: The status of the SSIS packages that are responsible for copying data from one database toanother. Custom schedule configuration.The relational database AC Warehouse serves as the immediate source of data for themultidimensional database and is managed by Microsoft SQL Server. It contains the dimensionaldata copied from the Data Marts and views linked to the fact tables in the Data Marts.The multidimensional database AC OLAP is managed by Microsoft SQL Server Analysis Services. Itcontains aggregations (for example, maximum, minimum, average) of the data copied from thesource databases. These aggregated values are stored in cubes designed to facilitate the rapid queryof large amounts of data.Each Data Mart contains the following cubes: Data organized by the local time on the AppManager computer. Data organized by the UTC time (Greenwich Mean Time).A cube is a structure for data that uses hierarchical dimensions as an organizing principle.Dimensions describe data from a particular point of view. For example, the computer and applicationfrom which it was generated, or the date and time during which it was generated. The hierarchicalstructure of dimensions allows you to select data from any point in the hierarchy. For example, alldata generated during 2005; all data generated during December 2005; or all data generatedDecember 1, 2005. Given this structure and organization of aggregate values you can create reportssuch as the following: The average, minimum, and maximum use of memory resources by all Exchange Servers for theyear 2005.Introducing Analysis Center11

The average growth rate for all SQL Server databases for the month of December 2005. The average daily use of CPU for all Domino servers for 2004 and 2005.1.2.3Reporting Center Configuration DatabaseThe NQRConfig relational database includes: Analysis Center security information, such as the level of privileges for each Analysis Center roleand which users are assigned to which roles. Connection information such as the SQL server and database names used during thegeneration of AppManager reports. The status of scheduled reports.1.2.4Web ServiceThe Web Service runs on a Microsoft Internet Information Services (IIS) Web server and is thecentralized point of access to all your databases. It serves as the layer between the ReportingConsole and the source databases, running the SQL queries that gather report data, and thenreturning the data to the Console. In addition to authenticating source database connections, it alsoauthenticates connections to the Reporting Services Data Extension, which in turn publishes yourreports to SQL Server Reporting Services (SSRS).1.2.5SQL Reporting Services and Data ExtensionReporting Center allows you to deploy reports to SSRS that lets you create and manage reports, anddeliver them on a schedule. When you deploy a report from Reporting Center, the Reporting ServicesData Extension communicates with SSRS through the Reporting Center Web Service to deliver theinformation. SSRS publishes the report that you can view in a Web browser.1.2.6Admin ConsoleAdmin Console lets you perform the following administrative tasks: Managing Data: Lets you clean up data, rename or delete metrics, and delete machines. Managing Data Sources: Lets you add, delete, enable, or disable Data Sources. Managing ETL Filters: Lets you view or modify existing ETL filters, define new filters, ordisable filters. ETL filters let you control the amount of data that Analysis Center collects fromAppManager. Managing Jobs: Lets you view jobs. You can also start, stop, enable, or disable jobs. Data Processing: Lets you to reprocess the OLAP partitions when you want to optimizeAnalysis Center performance. Migrating Reports: Lets you migrate the Analysis Center 2.9 or later reports to ReportingCenter.1.2.7Reporting ConsoleReporting Console lets you run and generate reports. Use the Console to perform the following tasks: Customize the look and feel of a report12Introducing Analysis Center

Determine the amount of data displayed in a report Create dashboard reports that contain multiple related reports Configure deployment settings Configure subscriptions for SSRS Set the report context such as setting a time frame and selecting data series1.2.8Operations Center DashboardThe Dashboard is a web application, which also functions as a client to the Operation Center Server.The Operations Center Server, the Dashboard Application, and the Dashboard Client are thecomponents of the Operations Center solution. The Operations Center Server connects to the WebService, which collects the data and displays the reports in the Dashboard client.For more information on Operations Center Dashboard, see the Operations Center DashboardGuide.Introducing Analysis Center13

14Introducing Analysis Center

2Navigating the Reporting Console2This chapter provides information about how to use the Reporting Console to perform tasks suchmanaging Data Source connections, setting security permissions, configuring reporting services. Section 2.1, “Starting Reporting Center,” on page 15 Section 2.2, “Navigating Reporting Console,” on page 16 Section 2.3, “Using the Reporting Console,” on page 172.1Starting Reporting CenterWhen you log in to the Reporting Console, the Web Service uses IIS to validate the accountcredentials based on the Web Service configuration details you provided during installation.To start Reporting Center:1 Log in to the computer where you installed the Reporting Console.2 Launch the programs on the Start menu and click NetIQ NetIQ Reporting Center ReportingCenter Console.3 Provide the required information in the Logon dialog box and click Logon.FieldDescriptionWeb ServiceEnter the URL of the Reporting Center Web Service in the following format:http://computer hosting Web Service/Web Service virtual directory.The URL is defined during the installation of the Web Service.Use Current WindowsAccount CredentialsSelect this option to log on with the Windows account that you used to loginto the domain.Clear this option to enable the User name and Password options.User nameSpecify the login name for the account you want to use to connect to theWeb Service using the format domain\user name.PasswordSpecify the password for the account you want to use to connect to the WebService.Sign me in automaticallySelect this option to automatically sign you in during your subsequent loginsin the following scenarios: You connect to the same Web Service You use your current Windows credentials to connect to the WebServiceHowever, if you start the Console using a different Windows account, theConsole does not automatically sign you in and displays the Login dialogbox.Navigating the Reporting Console15

2.2Navigating Reporting ConsoleReporting Console consists of three panes from which you can perform all the tasks related to DataSource Connections, Security Settings, and Reports.2.2.1Navigation PaneThe Navigation pane is the starting point for Reporting Console. Use the Navigation pane to initiatetasks such as choosing a data source connection and selecting a report. The information in the otherpanes change according to what you do in the Navigation pane.Reporting Center Home is at the top of the Navigation Tree and allows you to start managing security,data source connections, and reports. When you click Reporting Center Home from the NavigationPane or the toolbar, the Reporting Console displays links to start each of the tasks, along withinformation about your current security settings, data source connections, and reports.2.2.2Results PaneThe center of the Reporting Console contains the Results pane that displays information related tothe folder, report, or data source connection you select in the Navigation pane. For example, thispane displays the contents of a report or the details of a data source connection. When you modifyreport properties in Reporting Console and run a report, the Results pane displays the report with thechanges.2.2.3Tasks PaneThe Tasks pane contains common functions you perform in Reporting Console. The contents changeaccording to what you select in the Navigation pane. For example, if you select an individual report inthe Navigation pane, the Tasks pane displays a list of the report-related tasks along with the ReportContext tab, which contains the context controls for the report.16Navigating the Reporting Console

2.3Using the Reporting ConsoleUse the Reporting Console to set up your reporting environment: Section 2.3.1, “Managing Data Source Connections,” on page 17 Section 2.3.2, “What’s Next?,” on page 182.3.1Managing Data Source ConnectionsData Source connections are the basis for the reports that you run with Reporting Center. The setupprogram automatically configures your initial data source connections according to the informationyou provide during installation. These data source connections point to specific database servers thatprovide the data for your reports. Data source connections use either Windows authentication or SQLauthentication depending on the security configuration of the source SQL Server and the choices youmake when installing SQL Server. After installation, you can configure additional data sourceconnections and modify connection properties in the Reporting Console.Adding a New Data Source Connection1 In the Navigation pane of the Reporting Console, right-click Data Source Connections and clickAdd New Data Source Connection.2 Click the General tab.3 Specify the Data Source connection name and description.4 (Conditional) If you want to set this Data Source connection as default, select the DefaultConnection option.5 Select the Data Source Type as Analysis Center.6 In the SQL tab of the Connection Details panel, specify the following:6a In the Server Name option, specify the SQL Server Instance name where AC Warehouse isinstalled.6b In the Database Name option, specify AC Warehouse.6c Select the authentication type.6d (Conditional) If you chose SQL Server Authentication, then specify the credentials to loginto the SQL Server.7 In the OLAP tab of the Connection Details panel, specify the following:7a In the Server Name option, specify the SQL Server Instance name where AC OLAP isinstalled.7b In the Database Name option, specify AC OLAP.8 Click OK.Specifying a Default Data Source ConnectionBefore you run reports for the first time, NetIQ Corporation recommends that you specify a defaultdata source connection for each connection type.To specify a default connection:1 In the Navigation pane of the Reporting Console, click Data Source Connections and right-clicka connection.Navigating the Reporting Console17

2 Click Data Source Connection Properties General and select Default Connection.3 Click OK.2.3.2What’s Next?After you install Reporting Center and get familiar with the Console and Data Source connections, getstarted with performing the following tasks. This is a suggested order, but the order in which youperform these tasks might vary depending on your organization requirements:1 Create reports from templates provided. For more information, see Chapter 3, “UnderstandingReport Templates,” on page 19.2 Deploy a report to SSRS and set up a subscription for it. For more information, see Section 4.5,“Deploying Reports,” on page 33.3 Create a hierarchy of Reporting Center users and groups. For more information, see ConfiguringReporting Center Security in the NetIQ Analysis Center Administrator Guide.4 Set up permission sets for the users and groups and assign them to objects. For moreinformation, see Configuring Reporting Center Security in the NetIQ Analysis CenterAdministrator Guide.18Navigating the Reporting Console

3Understanding Report Templates3Analysis Center 3.0 includes report templates that you can use as a base to create your own reports.These templates are available in the AppManager Templates folder located in the Navigation pane ofthe Reporting Console. Section 3.1, “Derivation Templates,” on page 19 Section 3.2, “Non-Derivation Templates,” on page 223.1Derivation TemplatesDerivation templates are one-to-many templates that let you derive multiple reports from a singletemplate. The default report that generates when you run the template displays all the contexts (dataseries) applicable for the template as headers in the table view. To derive a new report from thetemplate, manipulate the presentation of the data series in the default report.For example: Aggregate Template is a Derivation template that you can use to derive reportsdisplaying AppManager data in the following combinations: Knowledge Script on X-axis and Machines on Y-axis or vice-versa. Knowledge Script on X-axis and Measure on Y-axis or vice-versa. Machine on X-axis and Measure on Y-axis or vice-versa.For more information about deriving new reports from a Derivation template, see Section 3.1.1,“Deriving New Reports From Derivation Template,” on page 19.3.1.1Deriving New Reports From Derivation Template1 In Reporting Console, select the template from which you want to derive the report.2 Click Run Report.3 Manipulate the report data presentation:3a In the Data Presentation option, select Cross Bound.3b In the Grouping Data Series option, select the data series by which you want to group thedata on Y-axis.3c In the X-Axis Data Series option, select the data series that you want to display on X-axis.3d In Data Data Series option, select AggregateDateSource1, which provides the aggregatevalue of all the AppManager Data Sources.4 Click OK.5 Click the Report Save Template As Report option and save the report.6 (Conditional) To derive multiple reports from the template, repeat Step 1 through Step 5 for everynew report you want to derive.Understanding Report Templates19

3.1.2Types of Derivation TemplatesThe following sections list the templates that you can use to derive multiple reports. For informationabout deriving reports from a Derivation template, see Section 3.1.1, “Deriving New Reports FromDerivation Template,” on page 19. “Aggregate Templates” on page 20 “Day of the Week Templates” on page 21 “Time Range Templates” on page 21Aggregate TemplatesTemplate NameDescriptionAggregate TemplateGenerates a default report that displays AppManager data forthe Knowledge Script, Machine, and Measure data series.To derive a new report, manipulate the data presentation of anytwo of the following data series, which you want to display in thenew report: Knowledge Script Machine MeasureAggregate Template MetricGenerates a default report that displays AppManager data forthe Machine, Measure, and Metric data series.To derive a new report, manipulate the data presentation of anytwo of the following data series, which you want to display in thenew report: Machine Measure Metric20Understanding Report Templates

Day of the Week TemplatesTemplate NameDescriptionDay of the Week TemplateGenerates a default report that displays AppManager data for theKnowledge Script, Machine, and Measure data series overdifferent week days.To derive a new report for different week days, manipulate thedata presentation of any one of the following data series by whichyou want to group the data in the new report: Knowledge Script Machine MeasureDay of the Week Template MetricGenerates a default report that displays AppManager data for theMetric data series over different week days.To derive a new report for different week days, manipulate thedata presentation to group the data by Metric data series in thenew report.Time Range TemplatesTemplate NameDescriptionTime Range TemplateGenerates a default report that displays AppManager data forthe Knowledge Script, Machine, and Measure data series over aspecific time range.To derive a new report over a specific time range, manipulate thedata presentation of any one of the following data series bywhich you want to group the data in the new report: Knowledge Script Machine MeasureTime Range Template MetricGenerates a default report that displays AppManager data forthe Metrics data series over a specific time range.To derive a new report for a specific time range, manipulate thedata presentation to group the data by Metric data series in thenew report.Understanding Report Templates21

3.2Non-Derivation TemplatesNon-Derivation templates are one-to-one templates that lets you derive one report per template. Afteryou derive a report from the template you must save the derived report before you deploy it. For moreinformation about deriving a new report from a Non-Derivation template, see Section 3.2.1, “Derivinga Report From the Non-Derivation Template,” on page 22. Section 3.2.1, “Deriving a Report From the Non-Derivation Template,” on page 22 Section 3.2.2, “Types of Non-Derivation Templates,” on page 223.2.1Deriving a Report From the Non-Derivation Template1 In Reporting Console, select the template from which you want to derive the report.2 Click Run Report.3 Click the Report Save Template As Report option and save the report.3.2.2Types of Non-Derivation TemplatesThe following sections lists the templates that you can use to derive a report: “Compare Templates” on page 23 “Dashboard Templates” on page 24 “Drill-Down Templates” on page 24 “GAP Templates” on page 25 “Prediction Templates” on page 25 “Target Templates” on page 25 “Top N Templates” on page 25 “UpTime Templates” on page 2622Understanding Report Templates

Compare TemplatesTemplate NameDescriptionKS Compare By Number Time RangeGenerates report that compares AppManager data for theKnowledge Script data series over different time range:KS Compare By Two Time Range:Generates reports that compares AppManager data for theKnowledge Script data ser

The fact tables function as a component of the Data Warehouse The SQL Server agent uses SQL Server Integration Se rvices (SSIS) packages to copy the data from the Data Source to the Data Mart, and then to the Data Warehouse. 1.2.2 Data Warehouse The Data Warehouse consists of two relational databases and a multidimensional database. The