Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

Current Load Status
Regular Availability
FAQs & Tips
Password Changer
Support services
About the Data Warehouse
Data Administration
Express Mail
General Ledger
Learning Management
Position Inventory
Research-PennERA Proposals
Salary Management
Travel Expense Management
Tuition Distribution
World Travel

BusinessObjects at Penn > Tips and 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 print-able, re-sizeable pop-up window.

You can also check the How To's for your topic.




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?

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?

Formatting / 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.



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 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!)

If you don't see your question and the tips don't seem to help, try using the FAQ search function (to the right on this page) to find the information you are looking for. If after searching you are still unable to find what you need, please contact Data Administration. Help keep the Tips & FAQs up-to-date by suggesting new questions or reporting corrections to Data Administration.

Data Warehouse Search Results


Information Systems and Computing
University of Pennsylvania
Comments & Questions

Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania