advertisement

Mod 11 advanced_report_building[1]

50 %
50 %
advertisement
Information about Mod 11 advanced_report_building[1]
Technology

Published on March 10, 2014

Author: wsmiller

Source: slideshare.net

Description

Advanced report building
advertisement

Advanced Report Building Module 11 Modified, with permission, from Business Objects S.A. copyrighted materials 1

Charts of charts: BOA has the following types •Area •Column •Line •Pie •XY (Scatter) •3-D Area •3-D Column •3-D Line •3-D Pie Modified, with permission, from Business Objects S.A. copyrighted materials 2

2-D Column Chart • Column Chart illustrates the number of positions compared to the number of Social Security numbers between Pacific CPACs. Modified, with permission, from Business Objects S.A. copyrighted materials 3

3-D Column Chart • Allows you to display data along three axes. Modified, with permission, from Business Objects S.A. copyrighted materials 4

2-D and 3-D Column Charts • The 2-D and 3-D column charts displaying the same data. Modified, with permission, from Business Objects S.A. copyrighted materials 5

2-D and 3-D Line Charts • Line charts show trends in data at equal intervals. Modified, with permission, from Business Objects S.A. copyrighted materials 6

2-D and 3-D Area Charts • The stacked area chart below displays the sum of the SSNs and Positions. • The 3-D area chart is similar to the previous line chart example. Modified, with permission, from Business Objects S.A. copyrighted materials 7

2-D and 3-D Pie Charts • A pie chart shows the proportional size of values that make up a data series for a dimension. • It always shows only one dimension and is useful when you want to emphasize a significant element. Modified, with permission, from Business Objects S.A. copyrighted materials 8

Creating Charts • Two ways to create a chart: –Turn an existing table or cross-tab into a chart –From scratch, using the Chart Wizard Modified, with permission, from Business Objects S.A. copyrighted materials 9

Creating a Chart from a Cross-tab Select the cross-tab. Click the right mouse button. Select the Chart Type and hit OK. Modified, with permission, from Business Objects S.A. copyrighted materials 10

Creating a Chart using the Chart Wizard Click the Insert Chart button in the Report Toolbar. Drag out an rectangle representing the size of your chart in the report area. Select variables Select the chart type Modified, with permission, from Business Objects S.A. copyrighted materials 11

Adding Breaks You can add breaks to improve the layout of data in cross-tabs Select the Table and Click Format, Breaks. Click the Object you Edit your want to break on. selection. Click Add > Modified, with permission, from Business Objects S.A. copyrighted materials 12

Adding Breaks (cont.) The break formats the headers across the table columns. Modified, with permission, from Business Objects S.A. copyrighted materials 13

Managing Page Breaks • You can break up large reports that spread over several pages by setting page breaks • You can continue headers and footers from page to page Modified, with permission, from Business Objects S.A. copyrighted materials 14

Managing Page Breaks (cont.) A long table that runs over more than one page. Modified, with permission, from Business Objects S.A. copyrighted materials 15

Managing Page Breaks (cont.) Select the table then Format Then Table. Modified, with permission, from Business Objects S.A. copyrighted materials 16

Managing Page Breaks (cont.) Modified, with permission, from Business Objects S.A. copyrighted materials 17

Managing Page Breaks (cont.) Modified, with permission, from Business Objects S.A. copyrighted materials 18

Managing Page Breaks (cont.) You can add variables and formulas: Modified, with permission, from Business Objects S.A. copyrighted materials 19

Managing Page Breaks (cont.) You can carry over subtotals in the page break header: Double click here and Type “Carriedformula here and type this over” Double click =RunningSum(<Count of SSNs>) - Sum(<Count of SSNs>) Modified, with permission, from Business Objects S.A. copyrighted materials 20

Managing Page Breaks (cont.) You can add a grand totals in the table footer: Double click here and type this formula Double=Sum(<Count of SSNs>) click here and type “Total:” Modified, with permission, from Business Objects S.A. copyrighted materials 21

Additional Row Formatting You can insert additional rows in reports to stack data. Tip! It helps to keep columns the same width until after affected cells have been moved. Modified, with permission, from Business Objects S.A. copyrighted materials 22

Row Formatting Select a cell Modified, with permission, from Business Objects S.A. copyrighted materials 23

Row Formatting (cont.) Insert a Row Modified, with permission, from Business Objects S.A. copyrighted materials 24

Row Formatting (cont.) REPEAT THE INSERT FOR ADITIONAL ROWS Modified, with permission, from Business Objects S.A. copyrighted materials 25

Row Formatting (cont.) To add rows in the Header, Select the Header and Insert rows the same way Modified, with permission, from Business Objects S.A. copyrighted materials 26

Row Formatting (cont.) • Delete the unused Just like moving columns and Select a columns. cells cell and move it to • Then resize the the new needed columns as location Modified, with permission, from Business Objects S.A. copyrighted materials 27

Conditional Reporting You can insert conditional statements to hide blocks and other report components: Modified, with permission, from Business Objects S.A. copyrighted materials 28

Conditional Reporting (cont.) Select the table then click Format. Modified, with permission, from Business Objects S.A. copyrighted materials 29

Conditional Reporting (cont.) =Sum(<Count of SSNs>) < 4000 Modified, with permission, from Business Objects S.A. copyrighted materials 30

Conditional Reporting (cont.) The table disappears! As the condition is TRUE, (the sum of SSNs is less WHY? than 4000), the table is hidden. Modified, with permission, from Business Objects S.A. copyrighted materials 31

Report Printing • Display reports in Print Preview to see how they look prior to printing • Use Page Setup to Check or Adjust: – Page size and orientation (portrait/landscape) – Fit to print – Margins – Page numbering – Order of printing Modified, with permission, from Business Objects S.A. copyrighted materials 32

Report Printing - Page Setup Specify Landscape or Portrait. Specify the paper size. Specify a percentage of normal size. Specify the number of pages. Modified, with permission, from Business Objects S.A. copyrighted materials 33

Report Printing - Margins Specify the margins… … and see the effects. Modified, with permission, from Business Objects S.A. copyrighted materials 34

Report Printing - Page Number and Specify the Order of the number first page… …useful if you are printing part of a report. Specify the order the pages are printed. Modified, with permission, from Business Objects S.A. copyrighted materials 35

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

building - Tags - Forums - The Nexus Forums - Page 3

Nexus Mods; Forums; Chat; Bug Reports; Buy Premium; More ; Sign In; Create Account; ... There were 83 results tagged with building. By content type. Forums ...
Read more

Mode, Kleidung und Accessoires im s.Oliver Online Shop kaufen

Mode und Accessories für Damen, Herren und Kinder im s.Oliver Online Shop versandkostenfrei und auf Rechnung bestellen. Täglich neue Styles!
Read more

FakeFactory Cinematic Mod - Home

Cinematic Mod adds an emotional cinematic music soundtrack, ... Cinematic Mod 11; Cinematic Mod 10; Cinematic Mod 9; Cinematic Mod 8; Cinematic Mod 7;
Read more

MOD-11- WealthBuilding-Part1 - Download, Play - 4shared

MOD-11- WealthBuilding-Part1download from 4shared ... We notice you have AdBlock installed. This prevents you from using all features on 4shared.
Read more

Worms 4 Building Mod #11 Survivor Match and Cluster ...

TheReturn Production: http://www.modsofthereturnproduction.... Playlist Mod: https://www.youtube.com/playlist?list... ProjectXom Production ...
Read more

GTA Mods, Addons, Fahrzeuge, Maps, Skins und mehr. - GTAinside

GTAinside ist die ultimative GTA Mod Datenbank und umfasst mehr als 45.000 Mods für Grand Theft ... (11) Helikopter (13) Maps (127) Mods (633) Savegames ...
Read more

GDN {GIANTS Developer Network}

Subscribe to the GIANTS Developer Network newsletter. ... Farming Simulator 15 Sample Mod Farming Simulator 15 Mod Map SDK Blender Exporter Plugins v6.0.2
Read more

Files - Garrys Mod for Half-Life 2 - Mod DB

Files - Garrys Mod for Half-Life 2. ... Garry's Mod 11 FGD Feb 5 2013 Mapping Tool 31 comments. FGD for Garry's mod 11 use in valve hammer editor (Source SDK)
Read more