Skip to main content
Penn Information Systems & Computing Systems Home

Search form

System Status
  • Get Started
    • IT Staff
    • Faculty
    • Staff
    • Students
    • Alumni & Guests
    • ISC Staff
  • Services
    • — Services A to Z —
    • Accounts, Access & Security
      • Access Management Services
      • Active Directory
      • Identity Management Services
      • Information Security Services
    • Applications & Data Analytics
      • Application Development & Delivery
      • Data Analytics
        • Data Analytics at Penn
      • Integration Development & Delivery
    • Backup, Storage & Platforms
      • BackItUp
      • Cloud Solutions
      • Data Center & Colocation Solutions
      • Database & Application Platform Support & Consulting
      • Endpoint Management
      • Recovery Solutions
      • Storage
      • Virtual Desktop
      • Virtual Server Hosting
    • Community, Support & Learning
      • Classroom Technology Services
      • Desktop Engineering
      • IT Community Events
      • LinkedIn Learning
      • Tech Center
    • Consulting & Professional Services
      • Brokered Products
      • HireIT
      • Systems Support & Consulting
      • Technology Forecasting
    • Email, Calendaring & Collaboration
      • Classlists
      • Penn Email Routing
      • PennBox
      • PennNet Mailing Lists
      • PennO365
      • PennZoom
      • SMTP-Relay
      • Secure Share
    • Networks & Connectivity
      • Firewall Services
      • Network Design & Installation
      • PennNet
        • Network Names & Numbers
        • MAGPI (Penn's Internet2 Regional Optical Network)
      • PennNet Ethernet Ports
      • Wireless at Penn
    • Phone, TV & Video
      • Broadcasting Studio
      • Contact Center
      • Live Video Streaming
      • Penn Video Network
      • PennFlex Phone
      • PennNet Phone
      • Traditional Telephony
      • Video Content Management
      • Video Production
        • Producing Video Content
    • Web Hosting
      • Web Services
    • — Service Rates —
    • — Service Level Agreements —
  • Security
    • Office of Information Security
    • Security Services
    • Special Projects
    • Policies & Procedures
    • Training & Awareness
  • Collaborations
    • Computing Policies
    • Engaging Penn’s IT Community
    • Identity & Access Management
    • Penn IT Strategic Plan
    • Cloud First
    • Next Generation Unified Communications
    • Penn Bot
    • IT Advisory Groups
      • Common Solutions
      • IT Roundtable
      • Network Policy Committee
      • Penn Technology Investment Committee (PTIC)
        • About PTIC
        • The PTIC IT Development Fund
    • Special Interest Groups (SIGs)
      • Audio-Visual (AV-SIG)
      • Cloud Computing (Cloud-SIG)
      • Data Visualization (DataViz-SIG)
      • Developer SIG (Dev-SIG)
      • High-Performance Computing (HPC-SIG)
      • Instructional Technology SIG
      • Linux SIG
      • Macintosh Networking Group (MacNet)
      • Mobile Technologies (Mobile-SIG)
      • O365 Special Interest Group
      • PC Networking Group (PC-Net)
      • Project Partners SIG
      • Security SIG
      • Social Media SIG
      • Splunk Special Interest Group
      • Super User Group (SUG)
      • Web SIG
    • Technology Services Strategy Review Board
  • News
  • Events
  • About
    • Overview
    • Leadership & Groups
    • Purpose & Values
    • Strategic Goals
    • Recognition
    • Staff Profiles
    • Tech Jobs @ Penn
    • Contact Us
  • Hot Topics
  • Get IT Help
    • Help for Students
    • Help for Faculty & Staff
    • Help for Alumni
    • Help for Guests & Others
    • Resources for IT Staff

You are here

Home » BusinessObjects Tips & FAQs

BusinessObjects Tips & FAQs

Click on a category to show or hide its questions and tips. To view the answer for a specific question/tip, click on the question -- the answer will open in a new tab.

General Information
  • What is BI launch pad?
  • In order to receive access to BusinessObjects is training required?
  • Setting your Preferences
  • I changed my BI launch pad preferences from HTML mode to Applet (Java) mode in but it looks like I'm still in HTML mode when I log on. How can I fix this?
  • Why is there a tilde ( ~ ) in the name of my Web Intelligence folder in My Favorites? Is that a default folder and if so, what goes into it?
  • What's a "filter" and why should I use one (or several)?
  • Can I work in multiple documents at the same time?
  • Working with Timeouts
  • How can I navigate between editing a report and editing a query?
  • How can I navigate easily between report tabs or query tabs?
Working with Reports

General

  • Searching for corporate ("canned") reports in the repository
  • How can I print when I have multiple tabs in a report but don't want them all printed?
  • Is there any way to document in the Webi document what your query is about/doing/etc.?
  • How can I copy a specific data value from a table, so I can paste it into something outside BusinessObjects?
  • How do I purge the data from a report?
  • When I open a report, I get a blank grey window. How can I fix that?
  • When I login there's always a report that opens. Is there any way to set it so that just the Documents tab is open when starting?
  • My Status bar is gone! How can I get it back?
  • I deleted a report! How can I get it back?

Copying, Sharing, Saving, Exporting

  • How can I make a copy of or edit a repository/corporate report?
  • How do I create a shortcut to a corporate report and why not just copy the report?
  • How can I share a copy of my report with someone else?
  • I saved a report to my computer in Excel, where do I find it?
  • When I download reports (using 'Save to my computer as Excel') and attempt to enter formulas, the formulas appear as text and don't compute. How can I fix this?
  • For some reports, when saved as an Excel file, the report begins in row 2 and/or column B. How can I make my report begin at Cell A1?
  • How can I export Webi report headers to Excel?
  • When I save results to Excel, I don’t have the option to just open the results and work with them. I am forced to save first – how can I get around this extra step?
  • When I save a report with data as a CSV file, all of the leading zeros are cut off any numbers when I open the file in Excel. How can I keep the zeros?

Page Setup

  • Is there a feature to delete trailing blanks?
  • How can I change the name of a column?
  • Why am I getting a "Table or View does not exist" message?
  • How can I see the order of the report sorts or breaks, and how can I change them?
  • Formatting Reports by Right Clicking
  • How do I show all values of a column when I make a break?
  • What and where are the tools to help format reports?
  • Why do I see 2-digit years and inconsistent number formats?
  • How can I break on multiple columns at once (e.g., Name and Penn ID together)?
  • How can I hide a column in a table?
  • How can I undo an action that I just took when formatting my report?
  • How can I create a pivot table (or crosstab)?
  • How can I add a 'date last refreshed' to my report header?
  • How can I add a section to a report? I'm dragging the object onto the report pane and it isn't working.

Analysis

  • What's the difference between Count and Count ALL?
  • I'm using the user response to a date prompt in a variable, but want to see it just as the date, without the time. How can I do this?
  • What kind of a date formula can you create to add a specified number of days to a date?
  • How can I add a report filter?
  • How can I see and work with all of the filters applied on a report at once?
  • Why do some rows show a MULTIVALUE warning for an amount in my table, while others show the actual amount?
Working with Queries
  • Why doesn't my "in list" work? For example: Divisions in list (COL,NUR,EAS,WH).
  • How do I control query options (number of rows, etc.)?
  • Can I build a query based on a spreadsheet?
  • How do I create a query based on another query?
  • How can I create complex conditions (now called 'Query Filters') by nesting or indenting them together, and using AND and OR?
  • I have multiple queries in one report. How can I give them different names?
  • What character do I use for a "wildcard" and how should I use it?
  • Why am I getting a "No data to fetch" message?
  • Can I take an existing query and run it against a different universe without having to build it again from scratch?
  • How do I create a subquery?
  • I just added an object to my query - why doesn't it appear on my report?
  • How can I merge on shared dimensions in a report with multiple queries?
  • How can I "unmerge" a shared dimension?
  • How can I see how many rows of data were returned from my query?
  • My Query Properties display box is missing information at the bottom. What can I do?
  • How can I quickly duplicate a variable?
Miscellaneous & Browser Troubleshooting (check here when it just doesn't seem to be working right!)
  • Why can't I edit?
  • I can't run Java on my computer. Do I have any alternatives for editing my queries or creating new ones?
  • I get an error when trying to create a new document in FireFox

How Tos

Unsure where to start? You can also check these How Tos for step-by-step guidance for particular features.

BI Launch Pad
    • How to Navigate the READING Mode for Simple Exploring and Analyzing of Reports (PDF)
    • How to Navigate the DESIGN Mode for Creating and Modifying Reports (PDF)
    • How to Navigate the Query Panel (PDF)
    • How to Navigate Between Editing a Query and Editing a Report (PDF)
    • How to Work with Multiple Documents / Reports Open (PDF)
    • How to Copy a Repository/Corporate Report (PDF)
    • How to Share a Copy of a Document / Report (PDF)
    • How to Save Documents / Reports as Excel, CSV, or PDF (PDF)
    • How to Create a New Document / Report (PDF)
    • How to Find Basic Report Formatting Tools (PDF)
    • How to Add a Report Filter (PDF)
    • How to Add a Query Filter (PDF)
    • How to Create a Document Using Freehand SQL (PDF)
    • How to Create a “Geo Mapped” Chart  (PDF)
    • How to Create a Reference Cell (PDF)
    • SAP BusinessObjects Web Intellegence 4.1 - documentation from SAP
    Building a Query

    See how to build a query from a simple business question the following PDFs. (The screen shots here will look slightly different than the current version of BI4.x but the concepts are still the same.)

    • General Ledger Questions
      • How can I review our entertainment costs for last year? (PDF)
      • I need to run monthly reports on how we are doing with current expenses. Are we within budget or not? (PDF)
      • What ProCard transactions have been posted this month and the previous 2 months from my ORG and to what accounts have they been posted? (PDF)
      • How many funds in our school are currently frozen and what are the current encumbrances on those funds? (PDF)
      • How do our mail costs this year compare to last year? (PDF)
    • Research (PennERA Proposals)
      • Which proposals submitted over a year ago are still awaiting a final decision from the sponsor? (PDF)
      • To what accounts can costs for my projects be charged? (PDF)
      • Which of my awarded projects involve cost sharing? (PDF)
      • What is the status of the regulatory approvals for my outstanding proposals? (PDF)
      • What is the expected funding from the NIH for Dr. "Marie Curie" this fiscal year? (PDF)

        Didn't find what you're looking for? Try the searching the FAQs for particular keywords (search page will open in a new tab).

         

          Visit ISC on LinkedIn

          Print
          EI&A Home
          Query Tools
          • Introduction
          • BusinessObjects BI Launch Pad
          • BusinessObjects Tips & FAQs
          • QlikView Access Point
          • QlikView Tips & FAQs
          Resources
          • Access Forms
          • Current Load Status
          • Password Changer
          Warehouse Information
          • Guidelines for Writing Queries
          • Security
          • Support Services
          • Training
          Other Information
          • Data Analytics at Penn
          Contact EI&A
          • Computing Policies
          • Tech Jobs @ Penn
          System Status

          © 2023 THE UNIVERSITY OF PENNSYLVANIA — 3401 Walnut Street, Philadelphia, PA 19104 — Report accessibility issues and get help — For ISC Staff