Relational Reporting | Dimensional Reporting | |
Report type | Lists Crosstabs Charts Maps | Crosstabs Charts Maps |
Models | Relational models | Dimensionally-modeled relational models Online Analytical Processing (OLAP) models |
Data tree | package folder namespace query subject query item measure level | A customizable source tree package folder namespace fact measure dimension hierarchy level level attribute member |
Data items | Data items using relational and common constructs | Data items using dimensional and common
constructs Extended
data items |
Inserting data | Report Studio groups data automatically by query item. For example, when you add the Product type query item to a list, all product types appear when you run the report. | Report Studio groups data automatically by level. For example, when you add the Product type level to a crosstab, all product types appear when you run the report. You
can also create sets of members from different levels within the
same hierarchy You can also choose to insert
just the member, just the children of the member, or the member
and its children |
Summarizing data | Headers and footers in lists Summary functions Member summaries Aggregate
within detail | Member summaries Aggregate within set |
Focusing data | Add a query item and then add a detail or
summary filter to view only the data you want to see For example, add the Quarter query item to a list and filter by Q3. | Add only the relevant members to an edge
of the crosstab For example, only add the Q3 member to your report. |
Drilling | Drilling through by value | Drilling through by member Drilling
up and down |
Page and section breaks | Simple page breaks Page sets Sections Master detail relationships using parameterized
filters | Simple page breaks Page sets Page layers Master detail relationships using parameterized
edge or slicer expressions |
Report Studio authoring mode | Professional authoring mode | Professional authoring mode Express
authoring mode |
Alternative Studios | Query Studio | Analysis Studio |
