Mod 6_slice_and_dice[1]

50 %
50 %
Information about Mod 6_slice_and_dice[1]
Technology

Published on March 10, 2014

Author: wsmiller

Source: slideshare.net

Description

slice and dice data

Slice and Dice Module 6 Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 1

Slice and Dice Button Hitting the Slice and Dice Button brings up the . . . Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 2

Slice and Dice Panel A pop-up window that provides a graphical representation of the structure of the report you are working on. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 3

• Slice and Dice lets you do many of the same things you can do outside of slice and Dice. • Many of the graphic functions are collected here to help you with your report structure. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 4

Slice and Dice Panel a b (cont.) c a Shows or hides the different areas of the Slice and Dice Panel. b Apply breaks, filters, sorts, rankings and calculations. c Lets you Apply (accept), Reset (resets all formatting to the original default style), or Undo (cancel operations you performed). Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 5

Slice and Dice Panel (cont.) d e d Shows the variables that are available in the data provider. e Shows the variables displayed and the structure of the active table, chart, or cross-tab. f f Shows the name and type (table, chart, or cross-tab) of each block in the report. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 6

Slice and Dice Panel (cont.) g Provides information on the tasks you perform. You can rename, transform, reset or delete a block by clicking its tab with the right mouse button, then clicking a command on the pop-up menu that appears. g Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 7

Slice and Dice Panel (cont.) By clicking this button you can show or hide the available variables Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 8

Aggregations • Aggregation is a process that adjusts and displays measurable quantities at various requested levels. • Only objects that measure quantities can be aggregated. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 9

Applying Aggregations This document has 5 objects selected. . . When the query is run you get . . Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 10

Applying Aggregations (cont.) Drag an object from the Block Structure area over to the Available Variables area. Drag and drop Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 11

Viewing Data In Different Presentation Styles • With slice and dice you can change the block style in which you view the data. • By dragging and dropping icons in the Block Structure box of the Slice and Dice Panel, you can convert between the block types: Tables; Charts; Cross-tabs; & Financial blocks. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 12

Cross-tab Where you have at least two dimensions and a single measure object in a block, it is often easier to analyze the data in a cross-tab. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 13

Converting to a Cross-tab (cont.) Note: To convert back to a table, drag the object back down to where it was and click Apply. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 14

Converting to a Chart Note: Need at least 1 dimension and 1 measure object in a block. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 15

Charts • Pie charts show a few dimensions well. • Bar charts show more dimensions better. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 16

Converting to a Chart (cont.) Right click the tab. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 17

Converting to a Chart (cont.) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 18

Converting to a Chart (cont.) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 19

Applying Functions The Slice and Dice Panel Toolbar makes some of the core features of BOA easy to access. Apply Break Apply Filter Apply Sort Apply Ranking Insert Calculation Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 20

Sorting Data • With slice and dice you can re-sort the rows of your data block. • The sort function can order rows alphabetically or numerically and can be ascending or descending. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 21

Sorting Data (cont) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 22

Sorting Data (cont) To sort in descending order, double click the icon. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 23

Filtering Data Sometimes you may want to view only the data you need and hide the data you do not want to view. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 24

Filtering Data (cont) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 25

Applying Calculations to Data You can insert calculated values into your report block. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 26

Applying Calculations to Data (cont) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 27

Applying Calculations to Data (cont) Sum Count Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 28

Applying Calculations (cont) Co unt All Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 29

Applying Calculations (cont) To insert a calculation on a cross-tab: Double click the button. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 30

Applying Calculations (cont) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 31

Applying Breaks to Data • With slice and dice you can break your report block into logical parts; or according to selected data and values. • This function displays subtotals. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 32

Applying Breaks to Data (cont) Hi tS l ic e& Di ce Hit Ru n Select Japan Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 33

Applying Breaks to Data (cont) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 34

Ranking Data • You may only want to show the extreme ranges of the data (the largest numbers and the smallest numbers in a report). Like filtering, it hides the data you do not want to display. • You can rank data contained in tables, cross-tabs or master cells in master/detail reports. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 35

Ranking Data (cont) Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 36

Ranking Data (cont) To total positions for the top 3 UICs of each CPAC. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 37

Sectioning a Report Is a way of breaking a table affecting the entire report rather than only a data block. Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 38

Creating a Sectioned Report Modified, with permission, from Business Objects S.A. copyrighted materials - Introduction to Reporting 39

Add a comment

Related presentations

Related pages

Minecraft | HungerGames | Episode 6 Slice And Dice!

... HungerGames | Episode 6 Slice And Dice! SiGnificaNCe. Subscribe Subscribed Unsubscribe 102 102. ... Restricted Mode: Off History Help ...
Read more

WILLHau Sports Mod - Mobile

Half deafened Sports WILLHau Mod by the two reports, I nevertheless heard the panicked hunter shouting outside. Abruptly, as he faced east, ...
Read more

Slice and Dice - WoWInterface

Is there anyway that you could add 'Slice and Dice' & 'Hunger for Blood' to the tick down timers in the HUD similar ... Linear Mode. Switch to Hybrid Mode.
Read more

GalaxyPic - Galaxy Effect Mod - Recruiting & HR

GalaxyPic - Galaxy Effect Mod. by ayakybu. on Jun 20, 2016. Report Category: Recruiting & HR. Download: 0 Comment: 0. 1. views. Comments. Description ...
Read more

Dice of the Dead (Part 6 of 12) - YouTube

Dice of the Dead (Part 2 of 12) - Duration: ... Mighty No. 9 Part 6: Slice and Dice Road Rage - Duration: 9:17 ... Restricted Mode: Off ...
Read more

Free Download Page for Altamira Control Button ...

Download links for Altamira Control Button ... Archiving files not only reduces disk space taken, but also keeps them safe from malicious software....
Read more

Neural Gameshake | Don't Chase The Rabbit!

Neural Gameshake Don't ... I just got a press release saying the game got a big update today which includes an arena mode and plenty of other fixes, ...
Read more

NMC College For Kids Catalog - Summer 2016 - issuu

... NMC College For Kids Catalog - Summer 2016, ... Learn scripting and logic statements as you create your first mod! ... (Grades 4-6) Slice and dice; ...
Read more