Component Solution Services REC02F Manual de usuario descargar pdf (Pagina 75)

Tips Recipes Brio 2002

Section Type: Report section (with an embedded pivot)

Tip Name: Calendar-style Reports

Purpose / Use: To build a report that displays daily information in a calendar-style

format.

Sample File: Calendar.bqy

Steps to Produce: This tip requires some imaginative formatting of a pivot, which will then

get embedded in the report. The key is to have a week number column

that you use as a side label and put the days of the week in a top label.

The day number is the fact for the pivot. The resulting pivot won’t make

sense until you drop it into a report section grouped by Year and Month.

1) You start with two tables. The first (Periods2000.xls in this example) has date, year

number, month number, day number, ordinal day of the week (Sunday = 1 through

Saturday = 7), and week number. The week number starts with a value of 1 for the first

day of the year and then increments by 1 every Sunday. The second table (SALES.XLS in

this example) has date, units, and dollar amount.

2) If a column for the name of the day doesn’t already exist in the Periods2000 results, create

a Grouping Column named “Day” to convert the ordinal day of the week into a day

name.

1 2 ... 70 71 72 73 74 75 76 77 78

Sin comentarios

Component Solution Services REC02F Manual de usuario Pagina 75