Fast track to MDX: [CD included]
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
London ; Berlin ; Heidelberg ; New York ; Hong Kong ; Milan ; Pa
Springer
2002
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XXI, 266 S. Ill., graph. Darst. : 24 cm 1 CD-ROM |
| ISBN: | 1852336811 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV014811384 | ||
| 003 | DE-604 | ||
| 005 | 20030218 | ||
| 007 | t | ||
| 008 | 021008s2002 gw ad|| |||| 00||| eng d | ||
| 016 | 7 | |a 965288927 |2 DE-101 | |
| 020 | |a 1852336811 |c kart. : EUR 58.80 |9 1-85233-681-1 | ||
| 035 | |a (OCoLC)633566377 | ||
| 035 | |a (DE-599)BVBBV014811384 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a gw |c DE | ||
| 049 | |a DE-706 | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Whitehorn, Mark |d 1953- |e Verfasser |0 (DE-588)115568719 |4 aut | |
| 245 | 1 | 0 | |a Fast track to MDX |b [CD included] |c Mark Whitehorn, Robert Zare and Mosha Pasumansky |
| 264 | 1 | |a London ; Berlin ; Heidelberg ; New York ; Hong Kong ; Milan ; Pa |b Springer |c 2002 | |
| 300 | |a XXI, 266 S. |b Ill., graph. Darst. : 24 cm |e 1 CD-ROM | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a MDX |0 (DE-588)4704599-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL Server |0 (DE-588)4343204-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a OLAP |0 (DE-588)4481345-4 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a MDX |0 (DE-588)4704599-1 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a OLAP |0 (DE-588)4481345-4 |D s |
| 689 | 1 | |5 DE-604 | |
| 689 | 2 | 0 | |a SQL Server |0 (DE-588)4343204-9 |D s |
| 689 | 2 | |5 DE-604 | |
| 689 | 3 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 3 | |5 DE-604 | |
| 700 | 1 | |a Zare, Robert |e Verfasser |4 aut | |
| 700 | 1 | |a Pasumansky, Mosha |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010022068&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-010022068 | |
Datensatz im Suchindex
| _version_ | 1808226506763141120 |
|---|---|
| adam_text |
CONTENTS
FOREWORD
LX
INTRODUCTION
XILL
CHAPTER
1
YY
README.DOC
-
DEFINITIONS
YOU
NEED
TO
KNOW
1
SAMPLE
DATA
1
ITALICS
1
INTRODUCTION
1
DIMENSIONS,
MEASURES,
MEMBERS
AND
CELLS
2
CRANKING
UP
THE
COMPLEXITY
6
HIERARCHIES
AND
AGGREGATIONS
8
LEVELS
10
NAMING
CONVENTIONS
11
TUPLES
AND
SETS
13
TUPLES
AND
HIERARCHIES
24
SOMETIMES
MEASURES
BEHAVE
LIKE
DIMENSIONS
24
TUPLES
REVISITED
25
SETS
REVISITED
25
MEASURES
REVISITED
25
MEMBER
PROPERTIES
26
SUMMARY
27
CHAPTER
2
YY
HOW
MDX
IS
USED
29
CHAPTER
3
YY
MDX
QUERIES
35
USING
MDX
FOR
QUERIES
36
SELECT,
FROM,
ON
COLUMNS,
ON
ROWS
39
WHERE
50
SUMMARY
52
CHAPTER
4
YY
MDX
SYNTAX
53
BRACKETS,
BRACES
AND
THE
ODD
DOT
AND
COMMA
53
CHAPTER
5
YY
MDX
EXPRESSIONS
58
RECAP
OF
CELL
NAMING
59
THE
CONCEPT
OF
THE CURRENT
CELL
61
RELATIVE
CELL
REFERENCING
62
THE
PRACTICALITIES
-
HOW
TO
LOOK
AT
THE
DATA
IN
A
CUBE
65
1
COMPARING
VALUES
69
THE
PRACTICALITIES
-
HOW
TO
CREATE
A
CALCULATED
MEMBER
72
2
COMPARING
VALUES
BETWEEN
YEARS
74
3
CALCULATING
VALUES
TO
DATE
77
SUMMARY
78
CHAPTER
6
YY
NAVIGATING
THE
HIERARCHY
80
CHILDREN
82
PARENT
83
NESTING
FUNCTIONS
84
OUTSIDE
THE
LIMITS
85
REALITY
CHECK
85
DESCENDANTS
90
REALITY
CHECK
93
ANCESTOR
94
SIBLINGS
95
COUSIN
96
SUMMARY
96
CHAPTER
7
YY
SNAPSHOT
DATA
ANALYSIS
99
THE
GENERAL
PROBLEM
100
THE
GENERAL
SOLUTION
101
THE
SPECIFIC
REQUIREMENTS
101
WHY
USE
DESCENDANTS?
108
SUMMARY
109
CHAPTER
8
YY
MOVING
AVERAGES
110
A
SIMPLE
MOVING
AVERAGE
111
A
MORE
COMPLEX
MOVING
AVERAGE
115
SUMMARY
118
CHAPTER
9
YY
FILTERS
119
SUMMARY
126
CHAPTER
10
YY
SETTING
THE
DEFAULT
MEMBER
128
DEFINING
A
CUSTOM
DEFAULT
MEMBER
1
29
DEFINING
A
DIFFERENT
CUSTOM
DEFAULT
MEMBER
133
DEFINING
A
FULLY
DYNAMIC
CUSTOM
DEFAULT
MEMBER
134
DEFAULT
MEASURES
1
36
SUMMARY
137
CHAPTER
11
YY
MEMBER
PROPERTIES
AND
DIMENSION
SECURITY
138
MEMBER
PROPERTIES
138
DIMENSION
SECURITY
140
USING
MEMBER
PROPERTIES
AND
DIMENSION
SECURITY
141
SUMMARY
150
CHAPTER
12
YY
DISTINCT
COUNT
151
CHAPTER
13
YY
PARENT-CHILD
DIMENSIONS
156
CHAPTER
14
YY
ADVANCED
DATA
MODELING
-
CUSTOM
ORDER,
CUSTOM
ROLLUP,
CUSTOM
MEMBERS
162
PROBLEM
1:
CUSTOM
ORDER
-
ORDERING
OF
MEMBERS
IN
A
HIERARCHY
164
CREATING
A
CUSTOM
ORDER
168
PRACTICAL
SUMMARY
172
PROBLEM
2:
CUSTOM
ROLLUP
-
WHEN
THE
CUBE'S
DEFAULT
BEHAVIOR
DOESN'T
DO
THE
RIGHT
JOB
173
PRACTICAL
SUMMARY
178
PROBLEM
3:
CUSTOM
MEMBERS
-
FILLING
IN
MISSING
INFORMATION
178
PRACTICAL
SUMMARY
182
MORE
ABOUT
&
182
SUMMARY
185
CHAPTER
15
YY
FURTHER
ADVANCED
DATA
MODELING TECHNIQUES
1
86
WRITE-ENABLED
DIMENSIONS
AND
WORKING
WITH
DATA
IN
OTHER
CUBES
186
PROBLEM
4:
WRITE-ENABLED
DIMENSIONS
-
ALLOWING
USERS
TO
ADD
A
MEMBER
TO
A
DIMENSION
1
87
PRACTICAL
SUMMARY
192
PROBLEM
5:
WRITE-ENABLED
DIMENSIONS
-
DERIVING
VALUES
FOR
A
MEMBER
USING
FORMULAE
193
PRACTICAL
SUMMARY
196
PROBLEM
6:
MISSING
DATA
-
BRINGING
IT
IN
FROM
OTHER
CUBES
196
PRACTICAL
SUMMARY
199
SUMMARY
200
CHAPTER
16
YY
ACTIONS
201
CHAPTER
17
YY
SERVER
SIDE
COLOR
CODING
212
SUMMARY
219
CHAPTER
18
YY
MORE
ABOUT
QUERYING
220
NAMED
SETS
220
CROSSJOIN
221
NON
EMPTY
226
FROM
TOP
TO
BOTTOM
230
MORE
THAN
TWO
DIMENSIONS
-
PAGES,
SECTIONS,
CHAPTERS
239
WHEN
LOGIC
AND
PEOPLE
COLLIDE.
241
SUMMARY
250
SUMMARY
OF
THE
BOOK
250
APPENDIX
1
YY
SAMPLE
FILES
251
WHERE
AND
WHAT
ARE
THE
SAMPLE
FILES?
251
WHEN
TO
USE
WHICH
FILES
252
HOW
TO
MANAGE
THE
FILES
253
STEP-BY-STEP
GUIDE
TO
RESTORING
AN
ANALYSIS
SERVICES
DATABASE
FROM
A
.
CAB
FILE
253
DATA
SOURCES
256
APPENDIX
2
YY
PROCLARITY
258
INSTALLING
PROCLARITY
AND
CONNECTING
IT
TO
A
CUBE
258
USING
PROCLARITY'S
MDX
EDITOR
261
INDEX
262 |
| any_adam_object | 1 |
| author | Whitehorn, Mark 1953- Zare, Robert Pasumansky, Mosha |
| author_GND | (DE-588)115568719 |
| author_facet | Whitehorn, Mark 1953- Zare, Robert Pasumansky, Mosha |
| author_role | aut aut aut |
| author_sort | Whitehorn, Mark 1953- |
| author_variant | m w mw r z rz m p mp |
| building | Verbundindex |
| bvnumber | BV014811384 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)633566377 (DE-599)BVBBV014811384 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV014811384</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20030218</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">021008s2002 gw ad|| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">965288927</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1852336811</subfield><subfield code="c">kart. : EUR 58.80</subfield><subfield code="9">1-85233-681-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)633566377</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014811384</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">gw</subfield><subfield code="c">DE</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-706</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Whitehorn, Mark</subfield><subfield code="d">1953-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)115568719</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Fast track to MDX</subfield><subfield code="b">[CD included]</subfield><subfield code="c">Mark Whitehorn, Robert Zare and Mosha Pasumansky</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">London ; Berlin ; Heidelberg ; New York ; Hong Kong ; Milan ; Pa</subfield><subfield code="b">Springer</subfield><subfield code="c">2002</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXI, 266 S.</subfield><subfield code="b">Ill., graph. Darst. : 24 cm</subfield><subfield code="e">1 CD-ROM</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MDX</subfield><subfield code="0">(DE-588)4704599-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">OLAP</subfield><subfield code="0">(DE-588)4481345-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">MDX</subfield><subfield code="0">(DE-588)4704599-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">OLAP</subfield><subfield code="0">(DE-588)4481345-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="3" ind2="0"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="3" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Zare, Robert</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Pasumansky, Mosha</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010022068&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-010022068</subfield></datafield></record></collection> |
| id | DE-604.BV014811384 |
| illustrated | Illustrated |
| indexdate | 2024-08-24T00:26:17Z |
| institution | BVB |
| isbn | 1852336811 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-010022068 |
| oclc_num | 633566377 |
| open_access_boolean | |
| owner | DE-706 |
| owner_facet | DE-706 |
| physical | XXI, 266 S. Ill., graph. Darst. : 24 cm 1 CD-ROM |
| publishDate | 2002 |
| publishDateSearch | 2002 |
| publishDateSort | 2002 |
| publisher | Springer |
| record_format | marc |
| spelling | Whitehorn, Mark 1953- Verfasser (DE-588)115568719 aut Fast track to MDX [CD included] Mark Whitehorn, Robert Zare and Mosha Pasumansky London ; Berlin ; Heidelberg ; New York ; Hong Kong ; Milan ; Pa Springer 2002 XXI, 266 S. Ill., graph. Darst. : 24 cm 1 CD-ROM txt rdacontent n rdamedia nc rdacarrier MDX (DE-588)4704599-1 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf SQL Server (DE-588)4343204-9 gnd rswk-swf OLAP (DE-588)4481345-4 gnd rswk-swf MDX (DE-588)4704599-1 s DE-604 OLAP (DE-588)4481345-4 s SQL Server (DE-588)4343204-9 s Data-Warehouse-Konzept (DE-588)4406462-7 s Zare, Robert Verfasser aut Pasumansky, Mosha Verfasser aut DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010022068&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Whitehorn, Mark 1953- Zare, Robert Pasumansky, Mosha Fast track to MDX [CD included] MDX (DE-588)4704599-1 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd SQL Server (DE-588)4343204-9 gnd OLAP (DE-588)4481345-4 gnd |
| subject_GND | (DE-588)4704599-1 (DE-588)4406462-7 (DE-588)4343204-9 (DE-588)4481345-4 |
| title | Fast track to MDX [CD included] |
| title_auth | Fast track to MDX [CD included] |
| title_exact_search | Fast track to MDX [CD included] |
| title_full | Fast track to MDX [CD included] Mark Whitehorn, Robert Zare and Mosha Pasumansky |
| title_fullStr | Fast track to MDX [CD included] Mark Whitehorn, Robert Zare and Mosha Pasumansky |
| title_full_unstemmed | Fast track to MDX [CD included] Mark Whitehorn, Robert Zare and Mosha Pasumansky |
| title_short | Fast track to MDX |
| title_sort | fast track to mdx cd included |
| title_sub | [CD included] |
| topic | MDX (DE-588)4704599-1 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd SQL Server (DE-588)4343204-9 gnd OLAP (DE-588)4481345-4 gnd |
| topic_facet | MDX Data-Warehouse-Konzept SQL Server OLAP |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010022068&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT whitehornmark fasttracktomdxcdincluded AT zarerobert fasttracktomdxcdincluded AT pasumanskymosha fasttracktomdxcdincluded |