Loading...
Cancel
Ok
Columns
Rows
Slicer
Available
Created objects
( Functions )
Logical
Set
Member
Numeric
Integer
String
Datetime
Misc
Restore
Ok
Abs
Acos
Acosh
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ancestors
AND
Asc
AscB
Ascendants
AscW
Asin
Asinh
Atan
Atanh
Atn
Avg
Axis
BottomCount
BottomPercent
BottomSum
Cache
CalculatedChild
Cast
Caption
CBool
CByte
CDate
CDbl
Children
Chr
ChrB
ChrW
CInt
ClosingPeriod
CoalesceEmpty
Correlation
Cos
Cosh
Count
Cousin
Covariance
CovarianceN
Crossjoin
Current
CurrentDateMember
CurrentDateString
CurrentMember
DataMember
Date
DateDiff
DateDiff
DatePart
DateSerial
DateValue
Day
DDB
DefaultMember
Degrees
Descendants
Dimension
Dimensions
Distinct
DistinctCount
DrilldownLevel
DrilldownLevelBottom
DrilldownLevelTop
DrilldownMember
DrilldownMemberBottom
DrilldownMemberTop
DrillupLevel
DrillupMember
Except
Exp
Extract
Filter
FirstChild
FirstQ
FirstSibling
Fix
Format
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
FV
Generate
Head
Hex
Hierarchize
Hierarchy
Hour
IIf
IN
InStr
InStrRev
Int
Intersect
InverseNormal
IPmt
IRR
IS
IS NULL
IS EMPTY
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item
Lag
LastChild
LastNonEmpty
LastPeriods
LastSibling
LCase
Lead
Left
Len
Level
Levels
LinkMember
LinRegIntercept
LinRegPoint
LinRegR2
LinRegSlope
LinRegVariance
Log
Log10
LookupCube
LTrim
MATCHES
Max
Median
Members
MemberToStr
Mid
Min
Minute
MIRR
Month
MonthName
Mtd
Name
NameToSet
NextMember
NonEmptyCrossjoin
NOT
Now
NPV
NPer
NullValue
Oct
OR
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parameter
ParamRef
Parent
Percentile
PeriodsToDate
Pi
Pmt
Power
PPmt
Predict
PrevMember
Properties
PV
Qtd
Radians
Rank
Rate
Replace
Right
RollupChildren
Round
RTrim
Second
SetToArray
SetToStr
Sgn
Siblings
Sin
Sinh
SLN
Space
Sqr
SqrtPi
Stddev
StddevP
Stdev
StdevP
Str
StrComp
String
StripCalculatedMembers
StrReverse
StrToMember
StrToSet
StrToTuple
StrToValue
Subset
Sum
SYD
Tail
Tan
Tanh
ThirdQ
Time
Timer
TimeSerial
TimeValue
ToggleDrillState
TopCount
TopPercent
TopSum
Trim
TupleToStr
TypeName
UCase
Union
UniqueName
UserName
ValidMeasure
Val
ValidMeasure
Value
Var
Variance
VarianceP
VarP
VisualTotals
Weekday
WeekdayName
Wtd
XOR
Year
Ytd
|| (Concat Operator)
select NON EMPTY {[Measures].[Aeronaves], [Measures].[Passageiros]} ON COLUMNS, NON EMPTY Hierarchize(Union(Union({([Mes].[All Mess], [Regiao].[All Regiaos], [Aeroporto].[All Aeroportos], [Tipo].[All Tipos])}, Crossjoin([Mes].[All Mess].Children, {([Regiao].[All Regiaos], [Aeroporto].[All Aeroportos], [Tipo].[All Tipos])})), Union(Crossjoin({[Mes].[Maio]}, Crossjoin([Regiao].[All Regiaos].Children, {([Aeroporto].[All Aeroportos], [Tipo].[All Tipos])})), Crossjoin({[Mes].[Maio]}, Crossjoin({[Regiao].[Regional de São Paulo]}, Crossjoin({[Aeroporto].[All Aeroportos]}, [Tipo].[All Tipos].Children)))))) ON ROWS from [aerobrasil]
Print options
Title:
Separator:
Orientation:
Portrait
Landscape
Paper type
Auto
Letter (8.5 x 11 in)
Legal (8.5 x 14 in)
Ledger (8.5 x 14 in)
A5 (14.8 x 21 cm)
A4 (21 x 29.7 cm)
A3 (29.7 x 42 cm)
B5 (17.6 x 25 cm)
B4 (25 x 35.3 cm)
Custom
Page width:
cm / h
cm
Table width:
cm
Impr. Filters:
Print Map:
Print Charts:
Charts By Row:
Chart on:
Top
Bottom
Left
Right
Breaks page
Export
Aerobrasil Olap
Send
From:
To:
Subject:
Attach .xls
Attach .pdf
Attach MDX
Send
Configuration
Chart
Table
Map
Chart type
Bars chart
Stacked Bars
Normalized Bars
Waterfal
Dots chart
Lines chart
Stacked lines
Areas chart
Stacked Areas
Heat grid
Pie chart
Boxplot
Multi-Pies
Multi-Bars
Multi-Lines
Sunburst
TreeMap
Icicle
HyperTree
Horizontal
Font
Width
Height
Select all
Select none
Title
Position:
Top
Bottom
Right
Left
Size:
Color:
X Axis
Angle:
Margin:
Show grid
Y Axis
Angle:
Margin:
Show grid
Legend
Position:
Top
Left
Bottom
Right
Align:
Left
Center
Right
Top
Middle
Bottom
Dots
Size:
Circle
Square
Triangle
Cross
Diamond
Values
Size:
Color:
Labels
Size:
Color:
Row Axis
Column Axis
Show Parents
Indent Members:
Hierarchy Header:
nothing
hierarchies
levels
nothing
hierarchies
levels
Row Header:
nothing
hierarchies
levels
all
Member Span:
nothing
hierarchies only
positions only
hierarchies then position
positions then hierarchies
nothing
hierarchies only
positions only
hierarchies then position
positions then hierarchies
Header Span:
nothing
hierarchies only
positions only
hierarchies then position
positions then hierarchies
nothing
hierarchies only
positions only
hierarchies then position
positions then hierarchies
Select a Map file to upload:
Map
Config
Map
Properties
Identifier
Title
Latitude
Longitude
Dimension
Level
Members
Level
Member
About
Version:
Unknown
Build date:
Unknown
Bars chart
Stacked Bars
Normalized Bars
Waterfall
Dots chart
Lines chart
Stacked lines
Areas chart
Stacked areas
Heat grid
Pie chart
Boxplot
Multi-Pies
Multi-Bars
Multi-Lines
Sunburst
TreeMap
Icicle
HyperTree
Horizontal
Legend
Values
Save as
Analysis wizard
Analysis Measures:
Column:
All members
Rows:
Measure:
Order:
TopCount
TopPercent
TopSum
Desc (All)
BottomCount
BottomPercent
BottomSum
Asc (All)
(None)
Head
Tail
Slicer:
Calculator
[Measures].
Formula Editor
( Functions )
Logical
Set
Member
Numeric
Integer
String
Datetime
Misc
Abs
Acos
Acosh
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ancestors
AND
Asc
AscB
Ascendants
AscW
Asin
Asinh
Atan
Atanh
Atn
Avg
Axis
BottomCount
BottomPercent
BottomSum
Cache
CalculatedChild
Cast
Caption
CBool
CByte
CDate
CDbl
Children
Chr
ChrB
ChrW
CInt
ClosingPeriod
CoalesceEmpty
Correlation
Cos
Cosh
Count
Cousin
Covariance
CovarianceN
Crossjoin
Current
CurrentDateMember
CurrentDateString
CurrentMember
DataMember
Date
DateDiff
DateDiff
DatePart
DateSerial
DateValue
Day
DDB
DefaultMember
Degrees
Descendants
Dimension
Dimensions
Distinct
DistinctCount
DrilldownLevel
DrilldownLevelBottom
DrilldownLevelTop
DrilldownMember
DrilldownMemberBottom
DrilldownMemberTop
DrillupLevel
DrillupMember
Except
Exp
Extract
Filter
FirstChild
FirstQ
FirstSibling
Fix
Format
FormatCurrency
FormatDateTime
FormatNumber
FormatPercent
FV
Generate
Head
Hex
Hierarchize
Hierarchy
Hour
IIf
IN
InStr
InStrRev
Int
Intersect
InverseNormal
IPmt
IRR
IS
IS NULL
IS EMPTY
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item
Lag
LastChild
LastNonEmpty
LastPeriods
LastSibling
LCase
Lead
Left
Len
Level
Levels
LinkMember
LinRegIntercept
LinRegPoint
LinRegR2
LinRegSlope
LinRegVariance
Log
Log10
LookupCube
LTrim
MATCHES
Max
Median
Members
MemberToStr
Mid
Min
Minute
MIRR
Month
MonthName
Mtd
Name
NameToSet
NextMember
NonEmptyCrossjoin
NOT
Now
NPV
NPer
NullValue
Oct
OR
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parameter
ParamRef
Parent
Percentile
PeriodsToDate
Pi
Pmt
Power
PPmt
Predict
PrevMember
Properties
PV
Qtd
Radians
Rank
Rate
Replace
Right
RollupChildren
Round
RTrim
Second
SetToArray
SetToStr
Sgn
Siblings
Sin
Sinh
SLN
Space
Sqr
SqrtPi
Stddev
StddevP
Stdev
StdevP
Str
StrComp
String
StripCalculatedMembers
StrReverse
StrToMember
StrToSet
StrToTuple
StrToValue
Subset
Sum
SYD
Tail
Tan
Tanh
ThirdQ
Time
Timer
TimeSerial
TimeValue
ToggleDrillState
TopCount
TopPercent
TopSum
Trim
TupleToStr
TypeName
UCase
Union
UniqueName
UserName
ValidMeasure
Val
ValidMeasure
Value
Var
Variance
VarianceP
VarP
VisualTotals
Weekday
WeekdayName
Wtd
XOR
Year
Ytd
|| (Concat Operator)
''
Ranking Top - Down
Ranking Bottom - Up
Limit ( First / Last )
Filter by measure
Order by measure
No calculated
Visual totals
FORMAT_STRING =
IIf
Format
Color
Indicator
Link
Default:
(None)
Blank
🡭 up red
🡭 up green
🡭 up black
🡮 down red
🡮 down green
🡮 down black
● pin red
● pin green
● pin black
● pin yellow
● pin blue
Properties
What if ...?
Measure
+/-
0
Name
Format
Low
?
?
?
High
-
Caption:
value
Multiple regression
Forecast
[
]
+
Formule
Method
RMSE
MSE
R
2
Constant
Linear
Exponential
Growth
Logarithmic
Power
Polynomial^2
Polynomial^3
Last season average
Moving average
Arbitrary growth
(RMSE)
(MSE)
(R2)
period=
α=
β=
γ=
Growth%=
Size=
Parameters
Parameters
Parameter
Name
Data Type
String
Number
User Interface
Input Box
List
List Source
Default Value
Delete
Add
New Parameter
Measures
Mês
Região
Aeroporto
Tipo
Nº Aeronaves
Nº Passageiros
Meses
Regiões
Aeroportos
Tipos
2,893,323
179,949,252
Janeiro
Regiões
Aeroportos
Tipos
230,281
15,704,708
Fevereiro
Regiões
Aeroportos
Tipos
218,044
12,770,236
Março
Regiões
Aeroportos
Tipos
235,707
14,586,479
Abril
Regiões
Aeroportos
Tipos
233,396
14,889,391
Maio
Regiões
Aeroportos
Tipos
244,598
14,399,313
Regional do Centro-Oeste
Aeroportos
Tipos
31,839
1,881,238
Regional do Nordeste
Aeroportos
Tipos
18,749
1,344,401
Regional do Norte
Aeroportos
Tipos
13,687
520,894
Regional do Noroeste
Aeroportos
Tipos
10,385
374,795
Regional do Rio de Janeiro
Aeroportos
Tipos
34,489
1,907,922
Regional do Sudeste
Aeroportos
Tipos
27,129
1,187,963
Regional de São Paulo
Aeroportos
Tipos
61,893
4,442,262
Domestico
53,752
3,506,347
Internacional
8,141
935,915
Regional do Sul
Aeroportos
Tipos
31,562
1,854,091
Regional do Centro-Leste
Aeroportos
Tipos
14,865
885,747
Junho
Regiões
Aeroportos
Tipos
236,836
13,816,992
Julho
Regiões
Aeroportos
Tipos
250,261
16,780,700
Agosto
Regiões
Aeroportos
Tipos
250,604
15,439,843
Septembro
Regiões
Aeroportos
Tipos
246,070
15,242,770
Outubro
Regiões
Aeroportos
Tipos
246,432
15,263,593
Novembro
Regiões
Aeroportos
Tipos
247,453
14,929,842
Dezembro
Regiões
Aeroportos
Tipos
253,641
16,125,385