Configuring a Microsoft Analysis and Reporting …

1 Configuring a Microsoft Analysis and ReportingServices Resource in Metadata Manager 2009 InformaticaAbstractThis article shows how to create and configure a Microsoft Analysis and Reporting services resource in Metadata Versions Metadata Manager of ContentsMicrosoft Analysis and Reporting 2 Configuring Microsoft Analysis and Reporting 2 Install the Metadata Manager 3 Install Microsoft Internet Information 3 Configure 3 Creating a Microsoft Analysis and Reporting services 5 Objects Extracted from Reporting 5 Objects Extracted from Analysis 6 Data 6 Microsoft Analysis and Reporting ServicesYou can create and configure a Microsoft Analysis and Reporting services resource to extract metadata from the followingsources: Microsoft SQL server Reporting services .

2 Metadata Manager extracts Reporting metadata from ReportingServices. Microsoft SQL server Analysis services . If Analysis services is the data source for the Reporting Servicesreports, Metadata Manager can extract the Analysis schema from Analysis services . During the resource load,Metadata Manager links the Reporting services and Analysis services sources. You can view data lineage acrossthe can also configure connection assignments from the Microsoft Analysis and Reporting services resource to relationaldatabase resources to display data lineage across these Microsoft Analysis and Reporting ServicesBefore you create a Microsoft Analysis and Reporting services resource, you must configure the metadata source.

3 If you donot correctly configure the metadata source, the metadata load can fail or the metadata can be incorrectly loaded in theMetadata Manager configure Microsoft Analysis and Reporting services , complete the following tasks: Install the Metadata Manager Agent. Install Internet Information services . Configure the Metadata Manager AgentThe Metadata Manager Agent is a program that Metadata Manager uses to access metadata sources and extract sourcemetadata. By default, the Metadata Manager Agent runs on the nodes where the Metadata Manager Service Metadata Manager Agent and Reporting services must be on the same machine. If Reporting services is not on thesame machine as the Metadata Manager Service, install the Metadata Manager Agent on the same machine as Microsoft Internet Information ServicesIf you are using Reporting services version 2005, you must install Microsoft Internet Information services or later on themachine running Reporting PermissionsBefore you configure a Microsoft Analysis and Reporting services resource, configure the permissions for the user accountthat you use to connect to Analysis and Reporting Metadata Manager Agent uses Windows authentication to connect to Analysis and Reporting services .

4 The Windowsuser who starts the Metadata Manager Agent must have read permission on the objects that the Metadata Manager a Microsoft Analysis and Reporting services ResourceBefore creating a Microsoft Analysis and Reporting services resource, you must configure the Microsoft Analysis andReporting services create a Microsoft Analysis and Reporting services the Load tab, click Actions > New Resource .The Resource Selection window Business Intelligence > Microsoft Analysis and Reporting services . Properties page the following information:PropertyDescriptionNameName for the resource. The resource appears in the Resources panel with this name. The name mustbe unique and have from 1 through 256 characters.

5 It cannot include the following characters:/ \ : * ' ? " < > | [ ]DescriptionDescription for the resource. Description cannot exceed 4000 Configuration page the following resource properties:PropertyDescriptionAgent URLHost name and port number of the Metadata Manager Agent. The Metadata Manager Agent must beon the same machine as Reporting System VersionName and version of the resource. You cannot edit this server VersionVersion of Microsoft SQL server Reporting services . Select one of the following options:-SQL server 2008-SQL server 2005 Report server URLURL of the Report server . For a Report server running in native mode, enter the URL to the ReportServer using the following format:http://<host_name>:<portnumber>/<web_service_virtual_directory>For example:http://cas12307:80/ReportServerF or a Report server running in the SharePoint integrated mode, enter the URL to the site containingthe deployed reports.

6 Use the following format:http://<host_name>Report server ContentFolder path in Reporting services that contains the reports that you want to extract. Use "/" toindicate the root repository path, or use "/<folder_name>/<folder_name> to indicate a single indicate multiple folder paths, use a semicolon to separate the paths. For example, "/<folder_name>/<folder_name>;/<folder_name>."To extract all reports in a folder and its subfolders, specify a folder path. To extract all reports thatuse a shared data source, specify the data source ServerInstanceHost name or IP address of the machine running Analysis services if Analysis services is the datasource for the Reporting Service reports.

7 During the resource load, Metadata Manager extracts theanalysis schema from Analysis services . If the Analysis services instance was named duringinstallation, enter the host name using the following syntax:<host_name>\<instance_name>If you do not want to extract from Analysis services , do not enter a AssignConnectionsMetadata Manager configures connection assignments to relational database resource types duringthe resource load. If you disable this option, you must configure connection assignments in theresource properties after you create the Test Connection to test the connection to the source system and validate the Metadata Manager Metadata Manager cannot connect to the source system or validate the agent URL, an error message any errors and test the connection Schedules window add a schedule, select Attach a Schedule, and select a schedule in the Schedule you have not created a schedule.

8 You can assign a schedule to the resource after you create the Click resource appears in the Resources panel on the Load I create or load a Microsoft Analysis and Reporting services resource, Metadata Manager reports thefollowing error:Could not login to Report server or Analysis server URL/instance using Windows Authentication: A connection cannot be made. Ensure that the server is running.. Please check the server name and make sure the Windows Account the application uses has privileges to access the Report server or Analysis error can occur for the following reasons: The Report server URL or Analysis server Instance properties contain invalid values.

9 Verify that the values arecorrectly entered in the resource properties. The Report server or Analysis server is not running. The Report server or Analysis server is not accessible through the browser using Windows authentication. TheMetadata Manager Agent uses Windows authentication to connect to Analysis and Reporting services . Verify thatthe Windows user who starts the Metadata Manager Agent has read permission on the objects that the MetadataManager Agent I load a Microsoft Analysis and Reporting services resource, the Metadata Manager Agent reports thefollowing error:Not enough storage is available to process this load a large amount of metadata for a Microsoft Analysis and Reporting services resource, you can increase the JavaVirtual Machine (JVM) heap size for the Metadata Manager Agent to increase performance.

10 For example, increase the JVMheap size to 1 increase the JVM heap from the following location in a text editor:<Metadata Manager Agent Installation Directory>\ the following option to the <RunTime> section:<Options>-Xmx1024m</Options> the Metadata Manager Agent creating and loading a Microsoft Analysis and Reporting services resource, you can view and run data lineage on themetadata objects that Metadata Manager Extracted from Reporting ServicesMetadata Manager extracts the following objects from Reporting services : Report server Report database Report project SSRS report Data source Cube5 Dimension Dimension attribute Measure Data set Column Filter Report Report attribute Report parameterObjects Extracted from Analysis ServicesMetadata Manager extracts the following objects from Analysis services : Analysis server Analysis database Dimension Dimension attribute Hierarchy Level Level attribute Database catalog cube Measure group Measure Key performance indicator (KPI) Calculated measure Data source view Table Column Logical table Logical column JoinMetadata Manager does not extract the following objects from Microsoft Analysis services .