Index
[SYMBOL][A][B][C][D][E][F][G][H][I][J][K][L][M][N][O][P][Q][R][S][T][U][V][W][X][Y]
SYMBOL
' (single quote), 2nd
< > angle brackets
<![CDATA[ ... ]]> section
|| operator
3NF (third normal form)
A
abbreviations in MDX
access control
accuracy, and data structure
action sequences
creating
future of
running
testing
<AggName> element
aggregate functions
aggregate tables, 2nd
creating
deciding which to create
declaring
aggregate values
aggregate vs. total
Aggregate() function
Aggregation Designer
aggregator attribute
Ajax (asynchronous JavaScript and XML)
creating thin client application
displaying results
executing XMLA queries
XMLA discovery
all_dimensions option
Amazon EC2
Analyzer.
See Pentaho Analyzer.
AnalyzerDateFormat annotation
angle brackets
annotations
defined
for geographic locations
for time dimensions
<Annotations> element
approxRowCount attribute
asynchronous JavaScript and XML.
See Ajax.
<Attribute> element
attributes
abstract of
bucketing
defined
disconnected
hierarchies of
mapping onto columns
<Attributes> element
Authenticated role, 2nd
authentication, lack of by Mondrian
<AutoGeneratedDateTable> element
avg aggregator
B
Back, Bill
bar charts
Beanshell
BETWEEN clause
bottomLevel attribute
HierarchyGrant
not overriden by member grants
Bourdreau, Luc
bucketing attributes
business analytics
importance of
modeling
OLAP advantages
C
C-Tools
CacheFlusher class
calculated measures, 2nd
calculated members
adding to cube
calculated measures
converting calculations to
defining in query
defining in schema
hanger dimensions
on other dimensions
overview
section in schema
CallSet class
caption attribute
<Caption> element
captionColumn attribute
Cartesian product
catalogs
defined
XMLA, 2nd
CDA (Community Data Access)
caching for
using in dashboards
CDC (Community Distributed Cache)
CE.
See Pentaho CE.
CellOrdinal value
charting, with Pentaho Analyzer
chord charts, in Pentaho Analyzer
close() method
Cloudant
Cloudera
coarse-grained measure groups
collapsing dimensions
column attribute
<ColumnDef> element
<ColumnDefs> element
<Columns> element
combination dimensions
Community Dashboard Framework.
See CDF.
Community Data Access.
See CDA.
Community Distributed Cache.
See CDC.
comparisons using same terms
complexity, of cubes and schemas
CONCAT() function
concurrent users, 3NF model
configurationFile setting
conformed dimensions
consistency, and data structure
<CopyLink> element
cost, advantages of Mondrian
CouchDB
count aggregator
count measure
CRM (customer relationship management)
cross-domain calls
CTools Installer, 2nd
<Cube> element
overview
position of
CubeGrant
CurrentMember function
custom delegate role
custom hierarchy access
custom option
HierarchyGrant
required to use MemberGrant
custom role mappers
Customer dimension, 2nd
customer relationship management.
See CRM.
CustomHierarchyAccess class
CustomMDXConnection class
CustomRoleDelegate class, 2nd
D
data member
data mining.
See DM.
data warehouse, 2nd, 3rd
Data Warehouse Lifecycle Toolkit, The
data, structuring for analytics
overview
snowflake design
star schema
advantages of
combination dimensions
degenerate dimensions
junk dimensions
overview
SCD overview
SCD Type I
SCD Type II
SCD Type III
time dimensions
vs. 3NF
Data.Role annotation
database administrators
DatasourceInfo setting
datasources.xml file
dates, coded version of
Day attribute
day_of_month column
day_of_week column
day_of_week_in_month column
DBSCHEMA_CATALOGS message, 2nd
debugging calculations
defaultRole attribute
degenerate dimensions, 2nd
denormalization, of dates
describe command
descriptions, changing
dialect attribute
diff tool
dim_ naming convention
dimension attribute
dimension links
dimension tables
defined
in star schema
overview
reducing size of
dimensional filters
dimensional modeling
dimensionality, of measures
DimensionGrant
<DimensionLinks> element
<Dimensions> element, 2nd
disconnected attributes
discover messages
DISCOVER_DATASOURCES message, 2nd
distinct-count aggregator
DM (data mining)
and star schemas
overview
R language
Weka framework
downloading
Mondrian
Pentaho
Saiku
drag and drop analysis
drillThrough() method
dropping dimensions
dynamic schema processor.
See DSP.
dynamic security
action sequences
creating
running
dynamic role modification
custom delegate role
custom hierarchy access
custom MDX connection, 2nd
overview
supporting in schema
vs. dynamic schema processor
dynamic schema processor
configuring
defined
example of
supporting in schema
vs. dynamic role modification
DynamicSchemaProcessor interface
E
Education attribute
EE.
See Pentaho EE.
engine, Mondrian as
envelopes, SOAP
environment, performance testing
ERP (enterprise resource planning)
<error> element
errors
in MDX queries
in XMLA
evolution of schemas
overview
patterns for.
See also schemas.
Excel, difficulty analyzing data in
execute messages
<ExpressionView> element
extended segment cache
Extensible Markup Language.
See XML.
extract, transform, and load.
See ETL.
F
fact tables
defined
in star schema
<FactLink> element, 2nd
facts, in star schema
failOnEmptyRoleList parameter
Fast Track to MDX
filters
defined
in Pentaho Analyzer
fine-grained measure groups
Firefox, opening Pentaho login page
fiscal attributes
fixed targets in MDX
flushAll() method
flushing cache
schema cache
specific cubes
specific regions of cache
<ForeignKeyLink> element, 2nd, 3rd, 4th, 5th
<Formula> element
forums
fraud detection
full option, rollupPolicy attribute
G
Geo Map charts, in Pentaho Analyzer
Geo.RequiredParents annotation
Geo.Role annotation
geographic locations, annotations for
getAccess() method
git
Goodman, Nick
Greenplum, 2nd
grep tool
Groovy
groups
growth, in MDX
H
Hadoop, 2nd, 3rd
hanger dimensions, 2nd
hardware environment
Hazelcast
Head() function
hidden members
defined
vs. invisible and inaccessible
hidden option, rollupPolicy attribute
hideMemberIf attribute
<Hierarchies> element
hierarchy attribute
Hierarchy@table attribute
Hive
Hyde, Julian
I
IfBlankName value
IfParentsName value
Impala
in-memory caching
inaccessible elements
indexes, database performance
InfiniDB
infinispan-config.xml file
Infobright
information hiding
information subjects
inheritance, of member grant rules
interactive analytics, using Mondrian
invisible elements
ispentahorunning command
J
Java applications, using Mondrian from
creating connections with olap4j
executing queries
overview
JavaScript, cross-domain calls
JDBC (Java Database Connectivity), 2nd
JGroups, 2nd
jgroups-ec2.xml file
jgroups-tcp.xml file
jgroups-udp.xml file
JNDI (Java Naming and Directory Interface)
joint roles
JOLAP
JPivot
jQuery, 2nd
JSR-69 (Java Specification Request)
junk dimensions
K
<Key> element, 2nd
keyColumn attribute, 2nd
kill_pentaho command
L
large columns
latency, network
Level@table attribute
levels
levelType attribute
linear regression in MDX
<Link> element
LinRegPoint() function
localization of captions and descriptions
LocalizingDynamicSchemaProcessor class
Log4j, testing performance of queries
logging, slow queries
logical schema, of Mondrian
login page, Pentaho
lookup-map role mapper
LucidDB, 2nd
M
machine learning.
See ML.
mapRoles method
market basket analysis, 2nd
max aggregator
maximizing return on investment
MDSCHEMA_CUBES message, 2nd
MDX Solutions
MDXConnection class
MeasureGrant
<MeasureGroups> element
measuresCaption attribute
member cache
<MemberGrant> element
memberNameToSegmentList() method
members
Memcached
configuring
overview
memcached-config.xml file
memory
metamodelVersion attribute, 2nd, 3rd
Microsoft Analysis Services.
See MSAS.
Microsoft SQL Server
Microsoft, vs. Mondrian MDX
min aggregator
missing join keys
ML (machine learning)
overview
R language
Weka framework
modeling business questions
mondrian.properties file
mondrian.rolap.aggregates.Read property
mondrian.rolap.aggregates.Use property
mondrian.spi.SegmentCache interface
MondrianAbstractPlatformUserRoleMapper class
MonetDB
Moneyball
MongoDB, 2nd
Month attribute
month_of_year column
MSAS (Microsoft Analysis Services)
MTD() function
Multidimensional Expressions.
See MDX.
multiple cubes
overview
vs. single cubes
MySQL, 2nd, 3rd
N
<Name> element
nameColumn attribute, 2nd
named sets
<NamedSet> element
names, changing for elements
Netezza
network latency
<NoLink> element
NoSQL databases, 2nd
overview
processing data into SQL database
using SQL driver
numeric filters, in Pentaho Analyzer
numOwners setting
O
Oakland A's use case
Objects.spring.xml file
Objects.xml file
OLTP (online transaction processing), 2nd
one-to-one role mapper
online analytical processing.
See OLAP.
online resources
online transaction processing.
See OLTP.
operators, for time dimension
Optiq project
Oracle, 2nd
order, of member grant rules
Order() function
<OrderBy> element
orderByColumn attribute
ordinalColumn attribute
P
page files
<Parameter> element
parameters, in Pentaho Report Designer
Parent function
parent-child hierarchies
partial option, rollupPolicy attribute
passes through tables, star schema
password for virtual machine from book
Pasumansky, Mosha
Pentaho Aggregate Designer
Pentaho CE
Pentaho Data Integration.
See PDI.
Pentaho Report Designer
creating OLAP data source
overview
specifying dynamic schema processor
using parameters
Pentaho Reporting
Pentaho User Console.
See PUC.
pentaho-analysis-ee plugin
PentahoAccessControl-Exception
pentahoObjects.spring.xml file
pentahoWebapPath setting
<PhysicalSchema> element
overview
position of
supporting DSP in schema
Pivot4J
populating cache
populating data, with ETL
PostgreSQL, Mondrian support, 2nd
postMessage function
PrevMember function
PUC (Pentaho User Console), 2nd
Q
QTD() function
Quarter attribute
quarter column
queries
defining calculated members in
performance tuning process
creating initial
executing
slow, logging
<Query> element
R
R language
ragged hierarchies
RAM (random-access memory)
Rank() function
ranking in MDX
ratios in MDX
Read property
<ReferenceLink> element
relational OLAP.
See ROLAP.
ResultSet class
return on investment
risk, advantages of Mondrian
ROLAP (relational OLAP)
<Role> element, 2nd
role-based access control.
See RBAC.
role-playing dimensions
rollup policies
rollupPolicy attribute
S
saiku-shareMondrian.sh script
Sales schema
SCDs (Slowly Changing Dimensions)
overview, 2nd
SCD Type I, 2nd
SCD Type II
SCD Type III
scenarios
<Schema> element
overview
position of
Schema Workbench
SchemaGrant
all option
none option
overview
security
advantages of Mondrian
grants
CubeGrant
DimensionGrant
HierarchyGrant
MeasureGrant
MemberGrant
overview
SchemaGrant
roles
custom role mappers
declaring in Mondrian schema
defined
enforcement of
lookup-map role mapper
one-to-one role mapper
user-session role mapper
SEGMENT_CACHE_IMPL setting
SegmentCache interface
servers
SERVERS setting
service provider interface.
See SPI.
sessionStartupActionsList constructor
shadow member
shared dimensions
overview
single vs. multiple cubes
vs. conformed dimensions
shorthands, in schema, 2nd
single cubes, vs. multiple cubes
single quote ( ' ), 2nd
slicing
slow queries, logging
Slowly Changing Dimensions.
See SCDs.
snowflake design
snowflake dimensions
SOAP (Simple Object Access Protocol)
software environment
solutionPath setting
speed
advantages of Mondrian
and data structure
SPI (service provider interface), 2nd
Spofford, George
spreadsheets, Mondrian as
standalone mode
standards, advantages of Mondrian
star dimensions
star schemas
start_pentaho command
starting/running, Mondrian
startup action sequences
stop_pentaho command
stored measures, vs. calculated measures
structure of schemas
Subversion
sum aggregator
surrogate key
T
<Table> element
table generator
TCP (Transmission Control Protocol)
terminal application
the_date column
the_day column
the_month column
the_year column
thin clients, using Mondrian from
and XMLA
calling services with Ajax
creating thin client application
displaying results
executing XMLA queries
XMLA discovery
configuring Mondrian as XMLA web service
xmla4js library
third normal form (3NF)
time dimensions, 2nd, 3rd
annotations for
overview
table generator for
time_id column
time-specific MDX
<TimeDomain> element
Tomcat, 2nd
topLevel attribute
HierarchyGrant
not overriden by member grants
total, vs. aggregate
transactional systems
Transmission Control Protocol.
See TCP.
trends in MDX
troubleshooting performance
type attribute
U
Ubuntu
UDP (User Datagram Protocol)
Union element
Units measure
upgrading schemas
Use property
USE_SEGMENT_CACHE setting
UseContentChecksum property
user experience, improving using hierarchies
%USER_REGION% variable
USER_REGION_CODE attribute
USER_STATE_PROVINCE_NAME attribute
user-session role mapper
<UserDefinedFunction> element
users, letting users drive analysis
users.properties file
V
variety
Vectorwise
velocity
version-control systems
versioning, in schemas
versions, of Pentaho
virtual cubes
virtual machine from book, installing
VirtualBox
defined
downloading
<VirtualCube> element
visible attribute
volume
W
WEB-INF directory
web.xml file
Webb, Chris
Webdetails, 2nd
week_of_year column
weeks, and year boundries
WEIGHTS setting
Weka framework
wget command
what-if analysis
Whitehorn, Mark
WITH MEMBER clause
WTD() function
X
.xcdf files
XmlaOlap4jDriver
XMLAResponse class, 2nd
Y
Year attribute
years, weeks passing boundries of
YTD() function, 2nd
yymmdd column
yyyymmdd column