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].[VENTAS LIBRE], [Measures].[VENTAS PROTEGIDA], [Measures].[TASACIONES]} ON COLUMNS, NON EMPTY Hierarchize(Union({[TIEMPO].[TODO]}, [TIEMPO].[TODO].Children)) ON ROWS from [Venta de Viviendas]
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
evolucion_temporal_viviendas.analysisview.xaction
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
PERIODO
Nº VENTAS LIBRE
Nº VENTAS PROTEGIDA
TASACIONES
TODO
3,113,201
306,331
3,312,219
2008
509,880
59,319
2009
414,133
52,619
639,404
2010
444,388
50,763
558,849
2011
307,931
41,975
415,369
2012
324,155
38,717
357,490
2013
284,872
16,475
363,640
2014
346,888
20,130
408,665
2015
382,727
20,587
446,166
2016
98,227
5,746
122,636