access grant definitions
- About Access Grant Definitions
- Reference Material
access roles
Ad Hoc views
- Jaspersoft OLAP and the Repository
- Creating a Sales Numbers Ad Hoc View
- Applying the Model
administering Jaspersoft OLAP
- bottleneck analysis
- data security
- integrating data flow
- knowledge required
- maintenance tasks
- profiling
  - Profiling Performance
  - Profiling Performance
- system maintenance
- testing data access
- troubleshooting system performance
- tuning database performance
  - Jaspersoft OLAP Tuning Process and Options
  - Jaspersoft OLAP Tuning Process and Options
- tuning system performance
AGXML
- About Access Grant Definitions
- Reference Material
Amdahl’s law
analysis views. See OLAP views.
analyzing data, tools for
attributes
- About Access Grant Definitions
- Assigning Attributes
- Assigning Attributes
bottleneck analysis
cache
- clearing the cache
- integrating data flow
columns
- configuring measures
- hiding
- See also dimension columns.
commercial editions
- added features
  - Profiling Performance
  - Introduction to Jaspersoft OLAP
- administering
- data security
Community Project
configuring
- data cubes
- data security
  - Securing Data in Jaspersoft OLAP
  - Reference Material
- dimensions
  - Cube Configuration
  - Cube Configuration
- filters
  - Cube Configuration
  - Cube Configuration
- measures
- navigation tables
connections
- in OLAP views
- Mondrian
- Mondrian connections vs. XML/A
- OLAP client
constructs
- FROM
- SELECT
- WHERE
creating
- data sources
- MySQL database
- OLAP views
cubes
- and access to data
- configuring
- cube content
- database structure
- design concepts
- dimensions
- facts
- in dimensional modeling
- measures
- overview
- sorting
data security
data sources
- and OLAP views
- data preparation
- data warehouse
- MySQL database
- preparing data for analysis
data warehouse
database administrator
- data security
- guide to using Ultimate Guide
- integrating data flow
- knowledge required
- tuning database performance
database, cubes built from
design concepts
dimension columns
dimensional modeling
- creating processes
- example
- overview
dimensions
- as filters
  - Cube Configuration
  - Cube Configuration
- configuring
- defined
- example
- in columns
- in dimensional modeling
- swapping with measures
drill-through table functions
- Edit Properties pane
- navigation controls
  - Navigation Table Controls
  - Navigation Table Controls
editions of Jaspersoft OLAP
- Introduction to Jaspersoft OLAP
- Introduction to Jaspersoft OLAP
Enterprise edition. See commercial editions.
examples
- access grant definition
- adding dimensions
- AGXML
- changing layouts
- data security
- dimensional modeling
- dimensions
- displaying charts
- displaying OLAP views
  - Displaying Product Sales by Quarter
  - Displaying Product Sales by Time Across Store Locations
- drill-through table functions
  - Applying the Model
  - Applying the Model
- implementation
- MDX statements
  - Creating a Sales Numbers Ad Hoc View
  - Applying the Model
  - Applying the Model
- measure
- OLAP schemas
  - Creating an OLAP Schema
  - Reference Material
- OLAP views
  - Creating a Sales Numbers Ad Hoc View
  - Applying the Model
- pivoting
- profiling
- schemas
  - Creating an OLAP Schema
  - Reference Material
- slice and dice
- zoom functions
facts
- Measures and Facts
- OLAP Schema
filters
- Cube Configuration
- Cube Configuration
Foodmart
- database
- OLAP view
  - Analysis Tool Bar and Navigation Table
  - Applying the Model
FROM construct
JasperReports
JasperReports Server
- and Jaspersoft OLAP
- repository
Jaspersoft OLAP
- and JasperReports Server
- creating OLAP views
- data preparation
- design concepts
- differences between editions
- editions
  - Introduction to Jaspersoft OLAP
  - Introduction to Jaspersoft OLAP
- measures
- overview
- profiling
- technical support
- tools
  - Using the OLAP View Tools
  - Navigation Table Controls
- troubleshooting
- user interface
- versions
Jaspersoft OLAP prerequisites
Jaspersoft OLAP Workbench
- Creating an OLAP Schema
- OLAP Schema
JPivot
load balancing
MDX queries. See queries.
measures
- configuring
  - Dimension Column Layout
  - Cube Configuration
- example
- in cubes
- in dimensional modeling
- in schemas
- swapping with dimensions
member grants
modeling
- access to data
- overview
Mondrian
- about
- and data security
- and OLAP views
- Mondrian connection
- schemas. See OLAP schemas.
Mondrian connections and OLAP views
- Creating a Mondrian Connection
- Creating a Mondrian Connection
MySQL and data security example
navigation controls
- drill-through table functions
- Edit Properties pane
- Expand Member
- Expand Position
- zoom on drill
navigation tables
- configuring
- controls
OLAP
- adding a client connection
- adding a schema
- connections
  - Creating a Mondrian Connection
  - Creating a Mondrian Connection
- cubes
- integrating data flow
- Mondrian schemas
- OLAP engine
- operations
- overview
- schemas
OLAP views
- connections
- creating
  - OLAP Views
  - OLAP Views
- cube content
- data sources
- databases
- defined
- displaying examples
- example
  - Displaying Product Sales by Quarter
  - Creating a Sales Numbers Ad Hoc View
- MDX queries
- Mondrian connections
- OLAP connections
- OLAP schemas
- queries
- resources
- sample
- schemas
- testing data access
- XML/A
overviews
- cubes
- data security
- dimensional modeling
- Jaspersoft OLAP
- Jaspersoft OLAP design concepts
- modeling
- OLAP
- XML/A
pivoting
prerequisites for Jaspersoft OLAP
Professional edition. See commercial editions.
queries
- configuring data cubes
  - Cube Configuration
  - Cube Configuration
- contents of MDX query
- editing
- in OLAP views
- MDX
  - Defining an MDX Query
  - Defining an MDX Query
- query editor
- sample MDX query
- scope
query editor
roles
rows
- hiding
- row level security
schemas
- database schemas
- example
  - Creating an OLAP Schema
  - Reference Material
- in OLAP views
- Mondrian. See OLAP schemas.
- OLAP
  - Creating and Uploading an OLAP Schema
  - OLAP Schema
- optimizing the schema design
- tuning the database
securing data
SELECT construct
sorting data cubes
substituting variables in AGXML
system administrator
- bottleneck analysis
  - Tuning Performance
  - Jaspersoft OLAP Tuning Process and Options
- guide to using Ultimate Guide
- integrating data flow
  - Integrating Jaspersoft OLAP in the Enterprise’s Data Flow
  - Integrating Jaspersoft OLAP in the Enterprise’s Data Flow
- knowledge required
- maintenance tasks
  - Maintaining Tables
  - XML/A Definitions
- monitoring system performance
- profiling Jaspersoft OLAP
  - Profiling Performance
  - Profiling Performance
- securing data
- troubleshooting system performance
  - Troubleshooting Information for Technical Support
  - Monitoring the System
- tuning database performance
- tuning system performance
system developer
- guide to using Ultimate Guide
- integrating data flow
- securing data
technical business analyst
- creating views
- guide to using Ultimate Guide
- integrating data flow
- securing data
technical support
tool bars
tools
- data cubes
- dimension columns
- navigation table controls
- tool bar
trickle and flip
troubleshooting, system performance
- Troubleshooting Information for Technical Support
- Monitoring the System
user guides. See documentation.
user interface
- columns
- dimension columns
- dimensions
  - Cube Configuration
  - Cube Configuration
- filters
- measures
- navigation tables
- tool bars
user types
- database administrator
- system administrator
- system developer
- technical business analyst
users
variable substitution
- About Access Grant Definitions
- Assigning Attributes
versions of Jaspersoft OLAP
WHERE construct
Workbench. See Jaspersoft OLAP Workbench.
XML
XML/A
- and load balancing
- overview
- vs. Mondrian connections

Defining a Sales Numbers Cube

Version:

v7.2.0

Main menu

You are here

Defining a Sales Numbers Cube