Integration with CSA

The data from the below data sources is integrated with the data from CSA and displayed in the CSA CAP pages, KPIs, and Metrics. For details, see CSA_Demo and CSA CAPs .

• Amazon Web Services (AWS) is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help businesses scale and grow.

• Amazon CloudWatch (AWSCW) monitors your Amazon Web Services resources and the applications you run on AWS in real-time. You can use CloudWatch to collect and track metrics, which are the variables you want to measure for your resources and applications. CloudWatch alarms send notifications or automatically make changes to the resources you are monitoring based on rules that you define. For example, you can monitor the CPU usage and disk reads and writes of your Amazon Elastic Compute Cloud (Amazon EC2) instances and then use this data to determine whether you should launch additional instances to handle increased load. You can also use this data to stop under-used instances to save money. In addition to monitoring the built-in metrics that come with AWS, you can monitor your own custom metrics. With CloudWatch, you gain system-wide visibility into resource utilization, application performance, and operational health.

• Azure is Microsoft cloud computing platform, a growing collection of integrated services like analytics, computing, database, mobile, networking, storage, and web, for moving faster, achieving more, and saving money.

• Virtual Performance Viewer (vPV) is a web-based analysis and visualization tool that analyzes performance trends of elements in virtualized environments. vPV gives you at-a-glance visibility across your virtual environment for real-time insights into performance, capacity, and health. This helps you to optimize your infrastructure and quickly solve virtualization and cloud performance issues. It enables virtualization monitoring by providing an overview of the environment, near-real-time and historical data analysis and triaging using an interactive dashboard. It also enables monitoring for cloud and hypervisor environments. HPE vPV provides performance monitoring, graphing, and reporting in a single interface.

• Cloud Optimizer (CO) is a web-based analysis and visualization tool that analyzes performance trends of elements in virtualized environments. CO gives you at-a-glance visibility across your virtual environment for real-time insights into performance, capacity, and health. This helps you to optimize your infrastructure and quickly solve virtualization and cloud performance issues. It enables virtualization monitoring by providing an overview of the environment, near-real-time and historical data analysis and triaging using an interactive dashboard. It also enables monitoring for cloud and hypervisor environments. CO provides performance monitoring, graphing, and reporting in a single interface.

• Server Automation (SA) enables you to govern the full spectrum of your software management requirements. With SA policy-based software management you can automate software installation and application configuration, and ensure that managed servers are compliant with software policies.

To help you convert the billing amount to different currencies, ITBA has pre-configured their default exchange rates.

If you want to change the default exchange rate of each currency, open the $HPBA_HOME/ContentPacks/CSA/EXTERNAL/EXCHANGE.csv file and change the rates.

1. Log on to the BA application.

2. Click ADMIN > Data Management, click Install Content Pack to install the CSA Content Pack. For details, see Data Management - Install Content Pack.

   

1. Log on to the BA application.
2. Make sure you have installed the Content Pack (see above).

3. Click ADMIN > Data Management and the click Connect Data Source .

4. Click Add data source.

   

5. Select the CSA data source type and press Next.

   

   If the Next button does not appear in the Wizard dialog box, click the edge of the Data Source Wizard and when the black cross appear, move the window upwards until you see the Next button.

   

   

   User interface elements are described below:

   Note If the CSA configuration is for a named instance connection, make sure to enter the named instance port.

   UI Element	Description
   Instance name	Enter a name for the data source instance you are activating.
   CSA Version	Select the relevant version. . For details, see the ..
   Time Zone	Select the time zone for the data source.
   Data Source Type	CSA This parameter is read only.
   Username	Enter your admin username used to log on to CSA. The default username is admin.
   Password	Enter your admin password used to log on to CSA. The default admin password is cloud.
   Hostname/IP Address	Enter the CSA server hostname or IP address.
   Port	Port for REST API (default value is 8444).
   Initial Load Period (months)	Select the number of months from which you want the initial data loaded.

6. Enter the CSA configuration parameters and click Next to validate the parameters.

   

After adding the CSA data source, you need to run the ETL to pull data from CSA source.

You can schedule the running of the ETL process. For details, see Data Management - Run ETL - Content Flow Management.

1. Log on to the BA application.
2. Make sure you have installed the Content Pack (see above).
3. Make sure you have activated the data source (see above).
4. Click ADMIN > Data Management > Run ETL.

5. Click Add Scheduler to schedule the ETL run or click >. This loads the data from the CSA data source.

   

   Note The ETL run might last some time depending on the volume of data it has to load.

Activate the CSA_Demo CAP for demo purposes or activate the CSA CAP for live data into BA.

1. Log on to the BA application.

2. Ignore the Unreachable Java Applet. Click OK.

   

3. Log on to the BA application.
4. Make sure you have installed the Content Pack (see above).
5. If you plan to activate the CSA_Demo proceed to the next step. If you plan to activate the CSA, make sure you have executed the ETL (see Execute the ETL process).

6. Click ADMIN > Data Management and click Activate CAP.

7. Select the CSA or the CSA_Demo in the list of CPs, and click Activate to activate the CAP. Click Yes to begin the activation process.
   Then wait until the CAP activation is successful.
8. Close the ADMIN tab.

1. Log on to the BA application.

2. Click the STUDIO tab and click the calculation tool and select Recalculate.

   

   1. Select the CSA_CloudOptimization in the Universe/Context for recalculation list.
   2. Select the recalculation start date.
   3. Check the check box.

   4. Click Calculate.

      The calculation may take a few minutes.

3. To check the KPI calculation status, click the calculation tool and select Calculation monitoring.

4. Select Calculations running now in the Monitoring options.

   

   If No items to show is displayed, the KPI calculation is finished.

   Now you can view the CSA dashboard pages with live data.

   You can schedule the Scheduled calculation of the KPI. For details, see Calculation Scheduling .

1. Create a user in ITBA with the same login name as in CSA.

   1. From the ITBA ADMIN tab, create an ITBA user account with same login name as CSA (admin). The password does not need to be the same. The password needs to be complex.

      

      

   2. Log out from ITBA, and log on again in as the administrator.
   3. Select the pages relevant to CSA and make sure you can see the pages with live data.

2. Configure single sign-on:

   1. Enable SSO between the CSA Cloud Service Management Console (SMC) and BA. For details, see "Enabling the Cloud Analytics Secondary Tiles" in the HP Cloud Service Automation Configuration Guide.

      Enable SSO between the Marketplace Portal (MPP) and BA. For details, see "Configure the Showback Report Tile" in the HP Cloud Service Automation Configuration Guide.

   2. In CSA, initString is configured in the crypto element in the
      %CSA_HOME%\jboss-as-7.1.1.Final\standalone\deployments\csa.war\WEB-INF\hpssoConfiguration.xml file.

      The initString value represents a secret key and should be treated as such in your environment.

      Navigate to the <crypto> tag and enter the relevant value in the initString parameter. 

   3. In BA, click ADMIN > Settings > Single Sign-on and set the LW-SSO Token Creation key (initString) with the key above (without the double-quote and without the string “initString”). Change the domain name to the BA server domain (CSA server should have the same domain name). Click Save.

      

3. Configure the embedded page URL:

   1. In CSA server, backup the %CSA_HOME%/jboss-as-7.1.1.Final/standalone/deployments/csa.war/dashboard/config.json file (where %CSA_HOME% is the directory in which Cloud Service Automation is installed).
   2. Edit the config.json file.

   3. Search for the id: executive_scorecard tile (beware there are two such tiles), start from the second (type = secondary) as shown below:

      

   4. Under the tiles node, change “enabled”: false to “enabled”: true, for the following ids:

      1. Executive_scorecard_resource_manager
      2. Executive_scorecard_service_business_manager
      3. Executive_scorecard_showback_report
   5. Do not change it in the id: executive_scorecard_standalone.
   6. Change “enabled”: true to “enabled”: falsein the id: assistance_executive_scorecard.

   7. For all tiles that are under the id: executive_scorecard, in the data section, change <CONFIGURE_HOST_NAME> to match the hostname of your Business Analytics installation. For example xs.example.com.

      

4. Access BA pages in the CSA system:

   1. Log on to CSA using the full qualifier domain name (FQDN) URL.

      

   2. Open the embedded BA pages in the CSA system.

      

      

1. Edit EXCHANGE.csv.

2. Upload EXCHANGE.csv to $HPBA_Home/ContentPacks/CSA/EXTERNAL in the BA server.

3. Run the ETL to import exchange data. For details, see Data Management - Run ETL - Content Flow Management.

In this section, we simulate the CSA Consumer Organization administrator use case that leverages two existing groups in the LDAP server. Each group can only see its own group's data. CSAEngineers group can only see the engineering group data and the CSAHR group can only see the HR group data. For details, see also Setting access restrictions on a universe in the Universe Designer for BusinessObjects XI 3.1.

Step 1 - Configure resource, user and permission

1. In the CSA integrated LDAP server, select 2 groups: CSAHR and CSAEngineers.

   

2. In the ITBA application, configure LDAP. For details, see Users and Roles - LDAP Management.

   

   Create the CSAengineers and CSAHR groups and assign them users.

   

3. Create the resource for the CSA-Showback for Consumer Organization Admin page.

   

4. Create the CSAreportviewer role.

   

5. Assign the role CSAreportviewer to two groups.

   

6. Configure LDAP with BOE. For details, see LDAP in BusinessObjects.

   

7. Configure the group permission in the BOE server:

   1. Log on to BusinessObjects Central Management Console (http:// <local BOE server name>:8080/BOE/CMC) using the administrator name and password and configure LDAP with BOE. For details, see LDAP in BusinessObjects.

   2. Open the Connections:

      

   3. Select the XS_DWH_JDBC connection that your report uses and click User Security.

      

   4. Grant the View On Demand permission to the two groups.

      

8. Open the Universes.

   

9. Select the CloudBilling universe that your report uses and click Universe Security.

   

10. Add the Private security to the two groups.

    

11. Grant the View on Demand permission to the 2 groups in User Security.

    

    

12. Select Folders.

    

13. Select the Showback for Consumer Organization Admin report and click User Security.

    

14. Grant the View On Demand to the 2 groups.

    

Step 2 - Configure the restriction of Cloud Billing universe

1. Configure the restrictions of the Cloud Billing universe:

   1. On the BOE server, install SAP BusinessObjects BI platform 4 Client Tools. Unzip the bip-client.ZIP file from installation file and click setup.exe to install it.

      

   2. Open the Universe Design Tool.

      

   3. Log on to the Universe Design using the BOE administrator.

      

   4. Click the Import button.

      

   5. Open the Cloud Billing universe.

      

      

   6. Add the relevant restrictions in the Manage Access Restrictions wizard:

      • Engineer_restriction is set for CSAengineers which is configured to see only the engineering group’s data.
      • HR_restriction is set for CSAHR which is configured to see only the HR group’s data.

      

   7. Create the restriction.

      1. Click New in the wizard.

      2. Click the Rows tab and click Add....

         

      3. Select the XS_BUSINESS_UNIT_DIM_V table in the Table list, and set the SQL query in as follows:

         

         

      4. Click OK.

      5. Add restrictions1 as XS.BUSINESS_UNIT_DIM_V.Name = ‘Engineering’.

         

      6. Click OK.

   8. Repeat the steps from Create the restriction. to create the second restriction.

      

2. Click the Add user or Add group button, select the user and click the > button.

   

3. Click OK.

   

4. Select Engineers_Restriction in Available Restrictions area, select the CSAengineers group in the Available groups and users area, and then click the >>Apply button.

   

5. Repeat the previous step for the HR_Restriction and the HR group.

   

6. Click Export...

   

7. Click OK.

8. Log on to BA as the HR group one user and open the CSA billing report in the Dashboard.

9. Click the Refresh button to display the following value for Org Name.

   

10. Log on BA as the Engineers group one user and open the CSA billing report in the Dashboard.

11. Click the Refresh button to display the following value for Org Name.

    

Step 3 - Configure the Business Analytics tile in the CSA Market Place Portal

To enable and configure the Showback report on the CSA Market Place Portal for the Consumer Organization Administrator persona:

1. Locate the %CSA_HOME%\portal\conf\dashboard.json file.

2. In the file, locate the section below and in the highlighted url replace the <CONFIGURE_HOST_NAME> placeholder with the host name of the BA instance.

   {
       "label": "common.section.ADMINISTRATION.label",
       "role": ["CONSUMER_ORGANIZATION_ADMINISTRATOR"],
       "tiles": {
         "default": {
           "className": "light-gray"
         },
         "items": [{
           "label": "common.items.MANAGE_USER_SUBSCRIPTIONS",
           "icon": {
             "className": "icon-manage-subscriptions"
           },
           "link": "#/user/manage"
         }, {
           "label": "common.items.SCORECARD",
           "icon": {
             "className": "icon-status"
           },
           "link": {
             "url":"https://<CONFIGURE_HOST_NAME>/fndwar/loadEmbeddedPage.jsp?com.hp.bsm.uim.pageUID=ef63ab7f-b86b-43c8-b8d8-bb81869b73dc",
             "target": "_blank"
           }
         }]
       }
     }

3. Save.

The following is an example of the CSA Activation page.

User interface elements are described below:

For a list of the KPIs and Metrics related to the Cloud Service Automation data source, see KPIs and Metrics.

Reports