8/14/2019 Que at Ions

1/2

Some Queations------------------------------------- Given a report to look and asked to identify why it was not pulling in the correct data, in this

Case it was the joins they had to implement security.- Ask you describe a fan and chasm trap how would you resolve it.- Explain calculation contexts when to use them.- Explain about contexts generally and when to use them.- Common problems to look out for.

1. How can you suppress the 'No data to fetch' messages in Reports?There are a number of ways. VBA can be used to set Application.Interactive to Off. But

this will also prevent the user from responding to any prompts. You can also adjust yourquery so that every data provider is a union to a table that returns at least one row,thereby eliminating the possibility of returning no rows. That "special row" should bedesigned so that it doesn't change (impact) the actual results should they be returned.

Cannot be done in BO. (vba will suppress all msgs)

2. How can you create a graph with horisontal bars?

BO doesn't support this future.

3. When getting 'No data to fetch' msg, how can you make the report to display at leastone record?

Again, a union can be used to combine an extra row to a data provider, therebyeliminating the "no data to fetch" message. Or you can have two blocks, one hiddenbehind the other, where one block is displayed when there is data, and the other block(with a hard-coded text message) displayed only when there is no data in the "real" dataprovider.

4. How can you import a single-tab report into another multi-table report so the single-tabreport will keep its formatting?

Without VBA, use a template. You'll have to recreate the data provider from scratch.With VBA, you can move (copy) the data provider to the multi-tabbed document, theneither via VBA or manually use a template to move the formatting. Bottom line is that youuse a template to move the formatting, but have to use VBA or manually move the dataprovider as there is no feature within the product to do this.

Cannot be done.

5. Can you link the 'universe based' query to one based on RDBMS stored procedure?We had a dataprovider based on the universe and one that used VBA to retrieve data

from a stored procedure.

6. How can you display 5 top records only?Do you want the top 5 records based on some other value? Or the "pure" top 5 based onthe query? You have a number of choices... use the "rank" feature in BusinessObjects, use"partial results" and limit the rows returned to 5 (using a descending sort to get the rightorder), or use a Rank() feature of your RDBMS, assuming one is available. But since we'retalking about report solutions, that last one probably should not be considered.

Issues with the reporter rank function include the fact that all data is returned, resulting ina (potentially) large cube. But it will handle tied results. And by including a break on someother dimension object, you can determine the top 5 per X, or some other value.

8/14/2019 Que at Ions

2/2

Issues with the partial results include the fact that ties are not handled properly, and youcan only get the "overall" top 5, not the top 5 per some item.

7. What's the Detail object used for?any non-defining attribute should be a detail object. So while customer ID would be adimension, customer name, address, phone, and so on should be details. They are usedprimarily in an environment where lots of report linking is done. If you don't use thelinking technique, then details are less of an issue. Since details are associated with adimension, once their associated dimension is linked to some other dimension, then thedetail object is available (and valid) in a block with combined data.

Some objects (date objects come to mine) could be defined in a universe as bothdimensions and details. For example, Order Date could be a detail for Order Number. TheOrder Number only has one Order Date. By setting Order Date to be a detail, you can linkon Order Number to some other data provider and continue to use Order Date in the blockwithout the famous "Variables are not compatible" message. Yet you may want to drill ona hierarchy of Order Year, Order Quarter, Order Month, Order Date. In that case, it wouldhave to be a dimension.