Skip to Questions

Fast Answers - Find an answer or "Ask Us!" for sources.

Useful Tip: Type keywords rather than proper names; e.g., companies or countries rather than Apple or China

Prowess: Screening and Reporting

How can I screen for Indian companies by industry and retrieve sales data for all of the years available
Last Updated: Aug 05, 2011  |  1102 Views

Was this helpful? 0   0


In Prowess the Screening/Selection process is not separated from the reporting, so you have to include all of your report elements in the screen.  For example, to retrieve all annual sales data for all years for cotton textile companies in India, do the following:

  1. Open the application and log in.
  2. To select textile companies check Main Product/Services Group of Company under Query by Business Segments & Products in the Query Builder.  A list of product service classes will appear in the work area.

    prowess query builder industry


  4. Select the desired industries by opening the collapsed industries.  Note Bene: Selecting a broader industry category does not automatically select all of the subcategories. You must keep expanding and selecting to get a complete set.
  5. After you have made your selections, click on Add to Current OSC (output sheet of companies) in the execute window.

    Add selection to OSC

  6. Now go through a similar process for annual (or interim) sales data.  Click on Annual Financial Statements under Query by Financial Statements & Ratings in the main menu of the query builder.  Expand and select the data elements that you want.  Note Bene: the default is to select just the latest data. Click on the ? by Query on Date/s to see all of the date options and type the option you want under either the query date or output date.  Note Bene:  Select the Domain Companies in the Current OSC so you are not searching the entire Prowess database.  Now you can Click "Add data to OSC" to get the sales data in your report.

    add sales data to osc

  7. Click on Output sheet in the main menu banner of the application to view and save your data.

Other Answers / Comments (0)

    Other Ways to Contact Us

    Ask us.  Get Fast Answers.

    For Harvard affiliates or on-site visitors.  

    Request a research consultation.

    Hours of service.

    Baker Library | Bloomberg Center, Harvard Business School, Soldiers Field, Boston, MA 02163, 617-495-6040