I’m interested in hearing how people are using Business Query. Do you set up spreadsheets and reference cells returned by the query? How do you deal with the fact that the data moves based on additions and deletions? Do you create pivot tables off your data? I’m struggling with when Business Query is a better way to go and would be interested in hearing success stories!
Cindy Clayton
Ask WHY until you understand!
Overlooked blessings…
Laughing so hard your sides hurt and you can’t catch your breath… Daydreams…
The feel of a child in your arms…
I’m interested in hearing how people are using Business Query. Do you set up
spreadsheets and reference cells returned by the query? How do you deal with
the fact that the data moves based on additions and deletions? Do you create
pivot tables off your data? I’m struggling with when Business Query is a better
way to go and would be interested in hearing success stories!
From me: We use BQ extensively and even with its quirks, we are fairly
successful. I would be willing to discuss this offline, next week (I’m actually out of the office this week but like a fool I am checking e-mail from home). I will get in contact with you when I get back.
Cindy, my department uses BQ for publishing tables along with text commenting on the table data in MS word. The queries in Excel are used in pivot tables which are linked to word documents. Once all the links have been established the queries are refreshed which in turn updates all of the tables in the word doc. Of course if the data changes (i.e. no rows returned) the formulas etc. in the excel sheet may need to be adjusted. BQ is also used by other users to retrieve data and incorporate their own data to produce various data models for manipulation.
What are pivot tables and where can be achieved with them??
Do I need Business QUery to use them or can I achieve someting similar with Bo report and VBA ??
Pivot tables come from Excel. Business Objects calls them by the old Excel name which was crosstabs.
You can do this with standard Business Objects!
I love pivot tables!!! It allows you to summarize data into a more readable table and gives you a good way to visually compare numbers. You could have a line down the left side of products. Across the top you would have the months of the year. At the intersection of each cell you would have the total for that product in that month. It makes it easy to see trends in numbers.
There are a million other things you can use them for as well!
(BOB member since 2002-07-10)