Adding new PivotByDimension DataTable filter that can pivot a report by (almost) any dimension. The filter can pivot reports by their subtable dimension and can also pivot by other dimensions (by using segments).

Notes:

- in the UI, only pivoting by subtable is supported
- change to CSV DataTable renderer so column names w/ commas & quotes can appear in text
- change to XML DataTable renderer so column names w/ invalid XML characters can be rendered (bit of an iffy change, XML format needs an overhaul I think)
- includes new config option 'pivot_by_filter_enable_fetch_by_segment'
- includes additions to component metadata classes (ie, Report/Dimension)

9 files changed, 392 insertions, 0 deletions

diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
new file mode 100644
index 0000000000..a60b9519fb
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<results>
+	<result idSite="1">
+		<result date="2010-01-01" />
+		<result date="2010-01-02" />
+		<result date="2010-01-03">
+			<row>
+				<col name="label">this search term</col>
+				<col name="Melbourne, Victoria, Australia">2</col>
+				<col name="Toronto, Ontario, Canada">0</col>
+				<col name="Yokohama, Kanagawa, Japan">1</col>
+			</row>
+			<row>
+				<col name="label">search term 2</col>
+				<col name="Melbourne, Victoria, Australia">0</col>
+				<col name="Toronto, Ontario, Canada">0</col>
+				<col name="Yokohama, Kanagawa, Japan">2</col>
+			</row>
+			<row>
+				<col name="label">search term 3</col>
+				<col name="Melbourne, Victoria, Australia">0</col>
+				<col name="Toronto, Ontario, Canada">2</col>
+				<col name="Yokohama, Kanagawa, Japan">0</col>
+			</row>
+			<row>
+				<col name="label">search term 4</col>
+				<col name="Melbourne, Victoria, Australia">0</col>
+				<col name="Toronto, Ontario, Canada">2</col>
+				<col name="Yokohama, Kanagawa, Japan">0</col>
+			</row>
+			<row>
+				<col name="label">that search term</col>
+				<col name="Melbourne, Victoria, Australia">2</col>
+				<col name="Toronto, Ontario, Canada">0</col>
+				<col name="Yokohama, Kanagawa, Japan">0</col>
+			</row>
+			<row>
+				<col name="label">search term 1</col>
+				<col name="Melbourne, Victoria, Australia">0</col>
+				<col name="Toronto, Ontario, Canada">0</col>
+				<col name="Yokohama, Kanagawa, Japan">1</col>
+			</row>
+		</result>
+		<result date="2010-01-04" />
+		<result date="2010-01-05" />
+		<result date="2010-01-06" />
+		<result date="2010-01-07" />
+	</result>
+</results>
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..777020b15e
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamPlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<label>this search term</label>
+		<Bing>0</Bing>
+		<Google>1</Google>
+	</row>
+	<row>
+		<label>search term 2</label>
+		<Bing>0</Bing>
+		<Google>0</Google>
+	</row>
+	<row>
+		<label>search term 3</label>
+		<Bing>0</Bing>
+		<Google>1</Google>
+	</row>
+	<row>
+		<label>search term 4</label>
+		<Bing>1</Bing>
+		<Google>0</Google>
+	</row>
+	<row>
+		<label>that search term</label>
+		<Bing>0</Bing>
+		<Google>1</Google>
+	</row>
+	<row>
+		<label>search term 1</label>
+		<Bing>1</Bing>
+		<Google>0</Google>
+	</row>
+</result>
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..70bcfeed7d
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithColumnLimiting__Referrers.getKeywords_week.xml
@@ -0,0 +1,33 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<col name="label">this search term</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">1</col>
+	</row>
+	<row>
+		<col name="label">search term 2</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">2</col>
+	</row>
+	<row>
+		<col name="label">search term 3</col>
+		<col name="Toronto, Ontario, Canada">2</col>
+		<col name="Yokohama, Kanagawa, Japan">0</col>
+	</row>
+	<row>
+		<col name="label">search term 4</col>
+		<col name="Toronto, Ontario, Canada">2</col>
+		<col name="Yokohama, Kanagawa, Japan">0</col>
+	</row>
+	<row>
+		<col name="label">that search term</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">0</col>
+	</row>
+	<row>
+		<col name="label">search term 1</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">1</col>
+	</row>
+</result>
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv
new file mode 100644
index 0000000000..9b91feb5ee
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithCsvOutput__Referrers.getKeywords_week.csv
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json
new file mode 100644
index 0000000000..3ffebb1d65
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithJsonOutput__Referrers.getKeywords_week.json
@@ -0,0 +1 @@
+[{"label":"this search term","Melbourne, Victoria, Australia":2,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":1},{"label":"search term 2","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":2},{"label":"search term 3","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":2,"Yokohama, Kanagawa, Japan":false},{"label":"search term 4","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":2,"Yokohama, Kanagawa, Japan":false},{"label":"that search term","Melbourne, Victoria, Australia":2,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":false},{"label":"search term 1","Melbourne, Victoria, Australia":false,"Toronto, Ontario, Canada":false,"Yokohama, Kanagawa, Japan":1}]
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
new file mode 100644
index 0000000000..45bd7630ea
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotByParamWorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml
@@ -0,0 +1,123 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<col name="label">0</col>
+		<col name="/0">1</col>
+		<col name="/1">1</col>
+		<col name="/10">0</col>
+		<col name="/11">0</col>
+		<col name="/12">0</col>
+		<col name="/13">0</col>
+		<col name="/14">0</col>
+		<col name="/15">0</col>
+		<col name="/16">0</col>
+		<col name="/17">0</col>
+		<col name="/18">0</col>
+		<col name="/19">0</col>
+		<col name="/2">1</col>
+		<col name="/3">1</col>
+		<col name="/4">0</col>
+		<col name="/5">0</col>
+		<col name="/6">0</col>
+		<col name="/7">0</col>
+		<col name="/8">0</col>
+		<col name="/9">0</col>
+		<col name="/index">1</col>
+	</row>
+	<row>
+		<col name="label">1</col>
+		<col name="/0">0</col>
+		<col name="/1">0</col>
+		<col name="/10">0</col>
+		<col name="/11">0</col>
+		<col name="/12">0</col>
+		<col name="/13">0</col>
+		<col name="/14">0</col>
+		<col name="/15">0</col>
+		<col name="/16">0</col>
+		<col name="/17">0</col>
+		<col name="/18">0</col>
+		<col name="/19">0</col>
+		<col name="/2">0</col>
+		<col name="/3">0</col>
+		<col name="/4">1</col>
+		<col name="/5">1</col>
+		<col name="/6">1</col>
+		<col name="/7">1</col>
+		<col name="/8">0</col>
+		<col name="/9">0</col>
+		<col name="/index">1</col>
+	</row>
+	<row>
+		<col name="label">2</col>
+		<col name="/0">0</col>
+		<col name="/1">0</col>
+		<col name="/10">1</col>
+		<col name="/11">1</col>
+		<col name="/12">0</col>
+		<col name="/13">0</col>
+		<col name="/14">0</col>
+		<col name="/15">0</col>
+		<col name="/16">0</col>
+		<col name="/17">0</col>
+		<col name="/18">0</col>
+		<col name="/19">0</col>
+		<col name="/2">0</col>
+		<col name="/3">0</col>
+		<col name="/4">0</col>
+		<col name="/5">0</col>
+		<col name="/6">0</col>
+		<col name="/7">0</col>
+		<col name="/8">1</col>
+		<col name="/9">1</col>
+		<col name="/index">1</col>
+	</row>
+	<row>
+		<col name="label">3</col>
+		<col name="/0">0</col>
+		<col name="/1">0</col>
+		<col name="/10">0</col>
+		<col name="/11">0</col>
+		<col name="/12">1</col>
+		<col name="/13">1</col>
+		<col name="/14">1</col>
+		<col name="/15">1</col>
+		<col name="/16">0</col>
+		<col name="/17">0</col>
+		<col name="/18">0</col>
+		<col name="/19">0</col>
+		<col name="/2">0</col>
+		<col name="/3">0</col>
+		<col name="/4">0</col>
+		<col name="/5">0</col>
+		<col name="/6">0</col>
+		<col name="/7">0</col>
+		<col name="/8">0</col>
+		<col name="/9">0</col>
+		<col name="/index">1</col>
+	</row>
+	<row>
+		<col name="label">4</col>
+		<col name="/0">0</col>
+		<col name="/1">0</col>
+		<col name="/10">0</col>
+		<col name="/11">0</col>
+		<col name="/12">0</col>
+		<col name="/13">0</col>
+		<col name="/14">0</col>
+		<col name="/15">0</col>
+		<col name="/16">1</col>
+		<col name="/17">1</col>
+		<col name="/18">1</col>
+		<col name="/19">1</col>
+		<col name="/2">0</col>
+		<col name="/3">0</col>
+		<col name="/4">0</col>
+		<col name="/5">0</col>
+		<col name="/6">0</col>
+		<col name="/7">0</col>
+		<col name="/8">0</col>
+		<col name="/9">0</col>
+		<col name="/index">1</col>
+	</row>
+</result>
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..99086f82e8
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySegmentCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<col name="label">this search term</col>
+		<col name="Melbourne, Victoria, Australia">2</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">1</col>
+	</row>
+	<row>
+		<col name="label">search term 2</col>
+		<col name="Melbourne, Victoria, Australia">0</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">2</col>
+	</row>
+	<row>
+		<col name="label">search term 3</col>
+		<col name="Melbourne, Victoria, Australia">0</col>
+		<col name="Toronto, Ontario, Canada">2</col>
+		<col name="Yokohama, Kanagawa, Japan">0</col>
+	</row>
+	<row>
+		<col name="label">search term 4</col>
+		<col name="Melbourne, Victoria, Australia">0</col>
+		<col name="Toronto, Ontario, Canada">2</col>
+		<col name="Yokohama, Kanagawa, Japan">0</col>
+	</row>
+	<row>
+		<col name="label">that search term</col>
+		<col name="Melbourne, Victoria, Australia">2</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">0</col>
+	</row>
+	<row>
+		<col name="label">search term 1</col>
+		<col name="Melbourne, Victoria, Australia">0</col>
+		<col name="Toronto, Ontario, Canada">0</col>
+		<col name="Yokohama, Kanagawa, Japan">1</col>
+	</row>
+</result>
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..4c9fe03b6f
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTableWhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<col name="label">this search term</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">1</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">0</col>
+		<col name="Google">1</col>
+		<col name="Yahoo!">1</col>
+	</row>
+	<row>
+		<col name="label">search term 2</col>
+		<col name="Alexa">1</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">1</col>
+		<col name="Bing">0</col>
+		<col name="Google">0</col>
+		<col name="Yahoo!">0</col>
+	</row>
+	<row>
+		<col name="label">search term 3</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">1</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">0</col>
+		<col name="Google">1</col>
+		<col name="Yahoo!">0</col>
+	</row>
+	<row>
+		<col name="label">search term 4</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">1</col>
+		<col name="Google">0</col>
+		<col name="Yahoo!">1</col>
+	</row>
+	<row>
+		<col name="label">that search term</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">0</col>
+		<col name="Google">1</col>
+		<col name="Yahoo!">1</col>
+	</row>
+	<row>
+		<col name="label">search term 1</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">1</col>
+		<col name="Google">0</col>
+		<col name="Yahoo!">0</col>
+	</row>
+</result>
\ No newline at end of file
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
new file mode 100644
index 0000000000..4c9fe03b6f
--- /dev/null
+++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_testPivotBySubtableDimensionCreatesCorrectPivotTable__Referrers.getKeywords_week.xml
@@ -0,0 +1,57 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<result>
+	<row>
+		<col name="label">this search term</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">1</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">0</col>
+		<col name="Google">1</col>
+		<col name="Yahoo!">1</col>
+	</row>
+	<row>
+		<col name="label">search term 2</col>
+		<col name="Alexa">1</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">1</col>
+		<col name="Bing">0</col>
+		<col name="Google">0</col>
+		<col name="Yahoo!">0</col>
+	</row>
+	<row>
+		<col name="label">search term 3</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">1</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">0</col>
+		<col name="Google">1</col>
+		<col name="Yahoo!">0</col>
+	</row>
+	<row>
+		<col name="label">search term 4</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">1</col>
+		<col name="Google">0</col>
+		<col name="Yahoo!">1</col>
+	</row>
+	<row>
+		<col name="label">that search term</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">0</col>
+		<col name="Google">1</col>
+		<col name="Yahoo!">1</col>
+	</row>
+	<row>
+		<col name="label">search term 1</col>
+		<col name="Alexa">0</col>
+		<col name="Ask">0</col>
+		<col name="Babylon">0</col>
+		<col name="Bing">1</col>
+		<col name="Google">0</col>
+		<col name="Yahoo!">0</col>
+	</row>
+</result>
\ No newline at end of file