Skip to content

Instantly share code, notes, and snippets.

@MBehtemam
Created December 28, 2013 04:36
Show Gist options
  • Save MBehtemam/8156164 to your computer and use it in GitHub Desktop.
Save MBehtemam/8156164 to your computer and use it in GitHub Desktop.
channel sales json
{
"cubeName": "Channel Sales",
"axes": [
{
"positions": [
{
"[Date].[Calendar]": {
"index": 0,
"hierarchy": "[Date].[Calendar]",
"UName": "[Date].[Calendar].[Calendar Year].&[2005]",
"Caption": "CY 2005",
"LName": "[Date].[Calendar].[Calendar Year]",
"LNum": 1,
"DisplayInfo": 2
}
},
{
"[Date].[Calendar]": {
"index": 0,
"hierarchy": "[Date].[Calendar]",
"UName": "[Date].[Calendar].[Calendar Year].&[2006]",
"Caption": "CY 2006",
"LName": "[Date].[Calendar].[Calendar Year]",
"LNum": 1,
"DisplayInfo": 131074
}
},
{
"[Date].[Calendar]": {
"index": 0,
"hierarchy": "[Date].[Calendar]",
"UName": "[Date].[Calendar].[Calendar Year].&[2007]",
"Caption": "CY 2007",
"LName": "[Date].[Calendar].[Calendar Year]",
"LNum": 1,
"DisplayInfo": 131074
}
},
{
"[Date].[Calendar]": {
"index": 0,
"hierarchy": "[Date].[Calendar]",
"UName": "[Date].[Calendar].[Calendar Year].&[2008]",
"Caption": "CY 2008",
"LName": "[Date].[Calendar].[Calendar Year]",
"LNum": 1,
"DisplayInfo": 131074
}
}
],
"hierarchies": [
{
"index": 0,
"name": "[Date].[Calendar]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
}
]
},
{
"positions": [
{
"[Geography].[Geography]": {
"index": 0,
"hierarchy": "[Geography].[Geography]",
"UName": "[Geography].[Geography].[Country].&[Australia]",
"Caption": "Australia",
"LName": "[Geography].[Geography].[Country]",
"LNum": 1,
"DisplayInfo": 1000
}
},
{
"[Geography].[Geography]": {
"index": 0,
"hierarchy": "[Geography].[Geography]",
"UName": "[Geography].[Geography].[Country].&[Canada]",
"Caption": "Canada",
"LName": "[Geography].[Geography].[Country]",
"LNum": 1,
"DisplayInfo": 132072
}
},
{
"[Geography].[Geography]": {
"index": 0,
"hierarchy": "[Geography].[Geography]",
"UName": "[Geography].[Geography].[Country].&[France]",
"Caption": "France",
"LName": "[Geography].[Geography].[Country]",
"LNum": 1,
"DisplayInfo": 132072
}
},
{
"[Geography].[Geography]": {
"index": 0,
"hierarchy": "[Geography].[Geography]",
"UName": "[Geography].[Geography].[Country].&[Germany]",
"Caption": "Germany",
"LName": "[Geography].[Geography].[Country]",
"LNum": 1,
"DisplayInfo": 132072
}
},
{
"[Geography].[Geography]": {
"index": 0,
"hierarchy": "[Geography].[Geography]",
"UName": "[Geography].[Geography].[Country].&[United Kingdom]",
"Caption": "United Kingdom",
"LName": "[Geography].[Geography].[Country]",
"LNum": 1,
"DisplayInfo": 132072
}
},
{
"[Geography].[Geography]": {
"index": 0,
"hierarchy": "[Geography].[Geography]",
"UName": "[Geography].[Geography].[Country].&[United States]",
"Caption": "United States",
"LName": "[Geography].[Geography].[Country]",
"LNum": 1,
"DisplayInfo": 132072
}
}
],
"hierarchies": [
{
"index": 0,
"name": "[Geography].[Geography]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
}
]
}
],
"filterAxis": {
"positions": [
{
"[Measures]": {
"index": 0,
"hierarchy": "[Measures]",
"UName": "[Measures].[Reseller Sales Amount]",
"Caption": "Reseller Sales Amount",
"LName": "[Measures].[MeasuresLevel]",
"LNum": 0,
"DisplayInfo": 0
},
"[Date].[Fiscal]": {
"index": 1,
"hierarchy": "[Date].[Fiscal]",
"UName": "[Date].[Fiscal].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Fiscal].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Date].[Calendar Weeks]": {
"index": 2,
"hierarchy": "[Date].[Calendar Weeks]",
"UName": "[Date].[Calendar Weeks].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Calendar Weeks].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Date].[Fiscal Weeks]": {
"index": 3,
"hierarchy": "[Date].[Fiscal Weeks]",
"UName": "[Date].[Fiscal Weeks].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Fiscal Weeks].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Date].[Fiscal Year]": {
"index": 4,
"hierarchy": "[Date].[Fiscal Year]",
"UName": "[Date].[Fiscal Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Fiscal Year].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Date].[Date]": {
"index": 5,
"hierarchy": "[Date].[Date]",
"UName": "[Date].[Date].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Date].[(All)]",
"LNum": 0,
"DisplayInfo": 2191
},
"[Date].[Day of Week]": {
"index": 6,
"hierarchy": "[Date].[Day of Week]",
"UName": "[Date].[Day of Week].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Day of Week].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Date].[Day Name]": {
"index": 7,
"hierarchy": "[Date].[Day Name]",
"UName": "[Date].[Day Name].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Day Name].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Date].[Day of Month]": {
"index": 8,
"hierarchy": "[Date].[Day of Month]",
"UName": "[Date].[Day of Month].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Day of Month].[(All)]",
"LNum": 0,
"DisplayInfo": 31
},
"[Date].[Day of Year]": {
"index": 9,
"hierarchy": "[Date].[Day of Year]",
"UName": "[Date].[Day of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Day of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 366
},
"[Date].[Calendar Year]": {
"index": 10,
"hierarchy": "[Date].[Calendar Year]",
"UName": "[Date].[Calendar Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Calendar Year].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Date].[Fiscal Semester of Year]": {
"index": 11,
"hierarchy": "[Date].[Fiscal Semester of Year]",
"UName": "[Date].[Fiscal Semester of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Fiscal Semester of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Date].[Calendar Semester of Year]": {
"index": 12,
"hierarchy": "[Date].[Calendar Semester of Year]",
"UName": "[Date].[Calendar Semester of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Calendar Semester of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Date].[Fiscal Quarter of Year]": {
"index": 13,
"hierarchy": "[Date].[Fiscal Quarter of Year]",
"UName": "[Date].[Fiscal Quarter of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Fiscal Quarter of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Date].[Calendar Quarter of Year]": {
"index": 14,
"hierarchy": "[Date].[Calendar Quarter of Year]",
"UName": "[Date].[Calendar Quarter of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Calendar Quarter of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Date].[Month of Year]": {
"index": 15,
"hierarchy": "[Date].[Month of Year]",
"UName": "[Date].[Month of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Month of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 12
},
"[Date].[Calendar Week of Year]": {
"index": 16,
"hierarchy": "[Date].[Calendar Week of Year]",
"UName": "[Date].[Calendar Week of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Calendar Week of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 53
},
"[Date].[Fiscal Week of Year]": {
"index": 17,
"hierarchy": "[Date].[Fiscal Week of Year]",
"UName": "[Date].[Fiscal Week of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Date].[Fiscal Week of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 53
},
"[Ship Date].[Fiscal]": {
"index": 18,
"hierarchy": "[Ship Date].[Fiscal]",
"UName": "[Ship Date].[Fiscal].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Fiscal].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Ship Date].[Calendar]": {
"index": 19,
"hierarchy": "[Ship Date].[Calendar]",
"UName": "[Ship Date].[Calendar].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Calendar].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Ship Date].[Calendar Weeks]": {
"index": 20,
"hierarchy": "[Ship Date].[Calendar Weeks]",
"UName": "[Ship Date].[Calendar Weeks].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Calendar Weeks].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Ship Date].[Fiscal Weeks]": {
"index": 21,
"hierarchy": "[Ship Date].[Fiscal Weeks]",
"UName": "[Ship Date].[Fiscal Weeks].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Fiscal Weeks].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Ship Date].[Fiscal Year]": {
"index": 22,
"hierarchy": "[Ship Date].[Fiscal Year]",
"UName": "[Ship Date].[Fiscal Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Fiscal Year].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Ship Date].[Date]": {
"index": 23,
"hierarchy": "[Ship Date].[Date]",
"UName": "[Ship Date].[Date].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Date].[(All)]",
"LNum": 0,
"DisplayInfo": 2191
},
"[Ship Date].[Day of Week]": {
"index": 24,
"hierarchy": "[Ship Date].[Day of Week]",
"UName": "[Ship Date].[Day of Week].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Day of Week].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Ship Date].[Day Name]": {
"index": 25,
"hierarchy": "[Ship Date].[Day Name]",
"UName": "[Ship Date].[Day Name].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Day Name].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Ship Date].[Day of Month]": {
"index": 26,
"hierarchy": "[Ship Date].[Day of Month]",
"UName": "[Ship Date].[Day of Month].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Day of Month].[(All)]",
"LNum": 0,
"DisplayInfo": 31
},
"[Ship Date].[Day of Year]": {
"index": 27,
"hierarchy": "[Ship Date].[Day of Year]",
"UName": "[Ship Date].[Day of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Day of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 366
},
"[Ship Date].[Calendar Year]": {
"index": 28,
"hierarchy": "[Ship Date].[Calendar Year]",
"UName": "[Ship Date].[Calendar Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Calendar Year].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Ship Date].[Fiscal Semester of Year]": {
"index": 29,
"hierarchy": "[Ship Date].[Fiscal Semester of Year]",
"UName": "[Ship Date].[Fiscal Semester of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Fiscal Semester of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Ship Date].[Calendar Semester of Year]": {
"index": 30,
"hierarchy": "[Ship Date].[Calendar Semester of Year]",
"UName": "[Ship Date].[Calendar Semester of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Calendar Semester of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Ship Date].[Fiscal Quarter of Year]": {
"index": 31,
"hierarchy": "[Ship Date].[Fiscal Quarter of Year]",
"UName": "[Ship Date].[Fiscal Quarter of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Fiscal Quarter of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Ship Date].[Calendar Quarter of Year]": {
"index": 32,
"hierarchy": "[Ship Date].[Calendar Quarter of Year]",
"UName": "[Ship Date].[Calendar Quarter of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Calendar Quarter of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Ship Date].[Month of Year]": {
"index": 33,
"hierarchy": "[Ship Date].[Month of Year]",
"UName": "[Ship Date].[Month of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Month of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 12
},
"[Ship Date].[Calendar Week of Year]": {
"index": 34,
"hierarchy": "[Ship Date].[Calendar Week of Year]",
"UName": "[Ship Date].[Calendar Week of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Calendar Week of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 53
},
"[Ship Date].[Fiscal Week of Year]": {
"index": 35,
"hierarchy": "[Ship Date].[Fiscal Week of Year]",
"UName": "[Ship Date].[Fiscal Week of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Ship Date].[Fiscal Week of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 53
},
"[Delivery Date].[Fiscal]": {
"index": 36,
"hierarchy": "[Delivery Date].[Fiscal]",
"UName": "[Delivery Date].[Fiscal].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Fiscal].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Delivery Date].[Calendar]": {
"index": 37,
"hierarchy": "[Delivery Date].[Calendar]",
"UName": "[Delivery Date].[Calendar].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Calendar].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Delivery Date].[Calendar Weeks]": {
"index": 38,
"hierarchy": "[Delivery Date].[Calendar Weeks]",
"UName": "[Delivery Date].[Calendar Weeks].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Calendar Weeks].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Delivery Date].[Fiscal Weeks]": {
"index": 39,
"hierarchy": "[Delivery Date].[Fiscal Weeks]",
"UName": "[Delivery Date].[Fiscal Weeks].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Fiscal Weeks].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Delivery Date].[Fiscal Year]": {
"index": 40,
"hierarchy": "[Delivery Date].[Fiscal Year]",
"UName": "[Delivery Date].[Fiscal Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Fiscal Year].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Delivery Date].[Date]": {
"index": 41,
"hierarchy": "[Delivery Date].[Date]",
"UName": "[Delivery Date].[Date].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Date].[(All)]",
"LNum": 0,
"DisplayInfo": 2191
},
"[Delivery Date].[Day of Week]": {
"index": 42,
"hierarchy": "[Delivery Date].[Day of Week]",
"UName": "[Delivery Date].[Day of Week].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Day of Week].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Delivery Date].[Day Name]": {
"index": 43,
"hierarchy": "[Delivery Date].[Day Name]",
"UName": "[Delivery Date].[Day Name].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Day Name].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Delivery Date].[Day of Month]": {
"index": 44,
"hierarchy": "[Delivery Date].[Day of Month]",
"UName": "[Delivery Date].[Day of Month].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Day of Month].[(All)]",
"LNum": 0,
"DisplayInfo": 31
},
"[Delivery Date].[Day of Year]": {
"index": 45,
"hierarchy": "[Delivery Date].[Day of Year]",
"UName": "[Delivery Date].[Day of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Day of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 366
},
"[Delivery Date].[Calendar Year]": {
"index": 46,
"hierarchy": "[Delivery Date].[Calendar Year]",
"UName": "[Delivery Date].[Calendar Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Calendar Year].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Delivery Date].[Fiscal Semester of Year]": {
"index": 47,
"hierarchy": "[Delivery Date].[Fiscal Semester of Year]",
"UName": "[Delivery Date].[Fiscal Semester of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Fiscal Semester of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Delivery Date].[Calendar Semester of Year]": {
"index": 48,
"hierarchy": "[Delivery Date].[Calendar Semester of Year]",
"UName": "[Delivery Date].[Calendar Semester of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Calendar Semester of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Delivery Date].[Fiscal Quarter of Year]": {
"index": 49,
"hierarchy": "[Delivery Date].[Fiscal Quarter of Year]",
"UName": "[Delivery Date].[Fiscal Quarter of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Fiscal Quarter of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Delivery Date].[Calendar Quarter of Year]": {
"index": 50,
"hierarchy": "[Delivery Date].[Calendar Quarter of Year]",
"UName": "[Delivery Date].[Calendar Quarter of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Calendar Quarter of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Delivery Date].[Month of Year]": {
"index": 51,
"hierarchy": "[Delivery Date].[Month of Year]",
"UName": "[Delivery Date].[Month of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Month of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 12
},
"[Delivery Date].[Calendar Week of Year]": {
"index": 52,
"hierarchy": "[Delivery Date].[Calendar Week of Year]",
"UName": "[Delivery Date].[Calendar Week of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Calendar Week of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 53
},
"[Delivery Date].[Fiscal Week of Year]": {
"index": 53,
"hierarchy": "[Delivery Date].[Fiscal Week of Year]",
"UName": "[Delivery Date].[Fiscal Week of Year].[All Periods]",
"Caption": "All Periods",
"LName": "[Delivery Date].[Fiscal Week of Year].[(All)]",
"LNum": 0,
"DisplayInfo": 53
},
"[Reseller].[Reseller Type]": {
"index": 54,
"hierarchy": "[Reseller].[Reseller Type]",
"UName": "[Reseller].[Reseller Type].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Reseller Type].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Reseller].[Reseller Bank]": {
"index": 55,
"hierarchy": "[Reseller].[Reseller Bank]",
"UName": "[Reseller].[Reseller Bank].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Reseller Bank].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Reseller].[Reseller Order Frequency]": {
"index": 56,
"hierarchy": "[Reseller].[Reseller Order Frequency]",
"UName": "[Reseller].[Reseller Order Frequency].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Reseller Order Frequency].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Reseller].[Reseller Order Month]": {
"index": 57,
"hierarchy": "[Reseller].[Reseller Order Month]",
"UName": "[Reseller].[Reseller Order Month].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Reseller Order Month].[(All)]",
"LNum": 0,
"DisplayInfo": 13
},
"[Reseller].[Reseller]": {
"index": 58,
"hierarchy": "[Reseller].[Reseller]",
"UName": "[Reseller].[Reseller].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Reseller].[(All)]",
"LNum": 0,
"DisplayInfo": 701
},
"[Reseller].[Product Line]": {
"index": 59,
"hierarchy": "[Reseller].[Product Line]",
"UName": "[Reseller].[Product Line].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Product Line].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Reseller].[Business Type]": {
"index": 60,
"hierarchy": "[Reseller].[Business Type]",
"UName": "[Reseller].[Business Type].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Business Type].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Reseller].[Number of Employees]": {
"index": 61,
"hierarchy": "[Reseller].[Number of Employees]",
"UName": "[Reseller].[Number of Employees].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Number of Employees].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Reseller].[Annual Sales]": {
"index": 62,
"hierarchy": "[Reseller].[Annual Sales]",
"UName": "[Reseller].[Annual Sales].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Annual Sales].[(All)]",
"LNum": 0,
"DisplayInfo": 5
},
"[Reseller].[Annual Revenue]": {
"index": 63,
"hierarchy": "[Reseller].[Annual Revenue]",
"UName": "[Reseller].[Annual Revenue].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Annual Revenue].[(All)]",
"LNum": 0,
"DisplayInfo": 5
},
"[Reseller].[Bank Name]": {
"index": 64,
"hierarchy": "[Reseller].[Bank Name]",
"UName": "[Reseller].[Bank Name].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Bank Name].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Reseller].[Order Frequency]": {
"index": 65,
"hierarchy": "[Reseller].[Order Frequency]",
"UName": "[Reseller].[Order Frequency].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Order Frequency].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Reseller].[Order Month]": {
"index": 66,
"hierarchy": "[Reseller].[Order Month]",
"UName": "[Reseller].[Order Month].[All Resellers]",
"Caption": "All Resellers",
"LName": "[Reseller].[Order Month].[(All)]",
"LNum": 0,
"DisplayInfo": 13
},
"[Geography].[City]": {
"index": 67,
"hierarchy": "[Geography].[City]",
"UName": "[Geography].[City].[All Geographies]",
"Caption": "All Geographies",
"LName": "[Geography].[City].[(All)]",
"LNum": 0,
"DisplayInfo": 587
},
"[Geography].[State-Province]": {
"index": 68,
"hierarchy": "[Geography].[State-Province]",
"UName": "[Geography].[State-Province].[All Geographies]",
"Caption": "All Geographies",
"LName": "[Geography].[State-Province].[(All)]",
"LNum": 0,
"DisplayInfo": 71
},
"[Geography].[Country]": {
"index": 69,
"hierarchy": "[Geography].[Country]",
"UName": "[Geography].[Country].[All Geographies]",
"Caption": "All Geographies",
"LName": "[Geography].[Country].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Geography].[Postal Code]": {
"index": 70,
"hierarchy": "[Geography].[Postal Code]",
"UName": "[Geography].[Postal Code].[All Geographies]",
"Caption": "All Geographies",
"LName": "[Geography].[Postal Code].[(All)]",
"LNum": 0,
"DisplayInfo": 655
},
"[Employee].[Employee Department]": {
"index": 71,
"hierarchy": "[Employee].[Employee Department]",
"UName": "[Employee].[Employee Department].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Employee Department].[(All)]",
"LNum": 0,
"DisplayInfo": 16
},
"[Employee].[Department Name]": {
"index": 72,
"hierarchy": "[Employee].[Department Name]",
"UName": "[Employee].[Department Name].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Department Name].[(All)]",
"LNum": 0,
"DisplayInfo": 16
},
"[Employee].[Sales Person Flag]": {
"index": 73,
"hierarchy": "[Employee].[Sales Person Flag]",
"UName": "[Employee].[Sales Person Flag].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Sales Person Flag].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Employee].[Title]": {
"index": 74,
"hierarchy": "[Employee].[Title]",
"UName": "[Employee].[Title].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Title].[(All)]",
"LNum": 0,
"DisplayInfo": 67
},
"[Employee].[Hire Date]": {
"index": 75,
"hierarchy": "[Employee].[Hire Date]",
"UName": "[Employee].[Hire Date].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Hire Date].[(All)]",
"LNum": 0,
"DisplayInfo": 164
},
"[Employee].[Sick Leave Hours]": {
"index": 76,
"hierarchy": "[Employee].[Sick Leave Hours]",
"UName": "[Employee].[Sick Leave Hours].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Sick Leave Hours].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Employee].[Vacation Hours]": {
"index": 77,
"hierarchy": "[Employee].[Vacation Hours]",
"UName": "[Employee].[Vacation Hours].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Vacation Hours].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Employee].[Base Rate]": {
"index": 78,
"hierarchy": "[Employee].[Base Rate]",
"UName": "[Employee].[Base Rate].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Base Rate].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Employee].[Pay Frequency]": {
"index": 79,
"hierarchy": "[Employee].[Pay Frequency]",
"UName": "[Employee].[Pay Frequency].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Pay Frequency].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Employee].[Phone]": {
"index": 80,
"hierarchy": "[Employee].[Phone]",
"UName": "[Employee].[Phone].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Phone].[(All)]",
"LNum": 0,
"DisplayInfo": 288
},
"[Employee].[Salaried Flag]": {
"index": 81,
"hierarchy": "[Employee].[Salaried Flag]",
"UName": "[Employee].[Salaried Flag].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Salaried Flag].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Employee].[Gender]": {
"index": 82,
"hierarchy": "[Employee].[Gender]",
"UName": "[Employee].[Gender].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Gender].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Employee].[Marital Status]": {
"index": 83,
"hierarchy": "[Employee].[Marital Status]",
"UName": "[Employee].[Marital Status].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Marital Status].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Employee].[Employees]": {
"index": 84,
"hierarchy": "[Employee].[Employees]",
"UName": "[Employee].[Employees].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Employees].[(All)]",
"LNum": 0,
"DisplayInfo": 1
},
"[Employee].[Status]": {
"index": 85,
"hierarchy": "[Employee].[Status]",
"UName": "[Employee].[Status].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Status].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Employee].[Start Date]": {
"index": 86,
"hierarchy": "[Employee].[Start Date]",
"UName": "[Employee].[Start Date].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Start Date].[(All)]",
"LNum": 0,
"DisplayInfo": 170
},
"[Employee].[End Date]": {
"index": 87,
"hierarchy": "[Employee].[End Date]",
"UName": "[Employee].[End Date].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[End Date].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Employee].[Hire Year]": {
"index": 88,
"hierarchy": "[Employee].[Hire Year]",
"UName": "[Employee].[Hire Year].[All Employees]",
"Caption": "All Employees",
"LName": "[Employee].[Hire Year].[(All)]",
"LNum": 0,
"DisplayInfo": 8
},
"[Promotion].[Promotions]": {
"index": 89,
"hierarchy": "[Promotion].[Promotions]",
"UName": "[Promotion].[Promotions].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Promotions].[(All)]",
"LNum": 0,
"DisplayInfo": 1000
},
"[Promotion].[Promotion]": {
"index": 90,
"hierarchy": "[Promotion].[Promotion]",
"UName": "[Promotion].[Promotion].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Promotion].[(All)]",
"LNum": 0,
"DisplayInfo": 16
},
"[Promotion].[Discount Percent]": {
"index": 91,
"hierarchy": "[Promotion].[Discount Percent]",
"UName": "[Promotion].[Discount Percent].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Discount Percent].[(All)]",
"LNum": 0,
"DisplayInfo": 10
},
"[Promotion].[Max Quantity]": {
"index": 92,
"hierarchy": "[Promotion].[Max Quantity]",
"UName": "[Promotion].[Max Quantity].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Max Quantity].[(All)]",
"LNum": 0,
"DisplayInfo": 5
},
"[Promotion].[Promotion Type]": {
"index": 93,
"hierarchy": "[Promotion].[Promotion Type]",
"UName": "[Promotion].[Promotion Type].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Promotion Type].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Promotion].[Min Quantity]": {
"index": 94,
"hierarchy": "[Promotion].[Min Quantity]",
"UName": "[Promotion].[Min Quantity].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Min Quantity].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Promotion].[Promotion Category]": {
"index": 95,
"hierarchy": "[Promotion].[Promotion Category]",
"UName": "[Promotion].[Promotion Category].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Promotion Category].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Promotion].[End Date]": {
"index": 96,
"hierarchy": "[Promotion].[End Date]",
"UName": "[Promotion].[End Date].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[End Date].[(All)]",
"LNum": 0,
"DisplayInfo": 10
},
"[Promotion].[Start Date]": {
"index": 97,
"hierarchy": "[Promotion].[Start Date]",
"UName": "[Promotion].[Start Date].[All Promotions]",
"Caption": "All Promotions",
"LName": "[Promotion].[Start Date].[(All)]",
"LNum": 0,
"DisplayInfo": 8
},
"[Product].[Product Categories]": {
"index": 98,
"hierarchy": "[Product].[Product Categories]",
"UName": "[Product].[Product Categories].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Product Categories].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Product].[Product Model Lines]": {
"index": 99,
"hierarchy": "[Product].[Product Model Lines]",
"UName": "[Product].[Product Model Lines].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Product Model Lines].[(All)]",
"LNum": 0,
"DisplayInfo": 5
},
"[Product].[Stock Level]": {
"index": 100,
"hierarchy": "[Product].[Stock Level]",
"UName": "[Product].[Stock Level].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Stock Level].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Product].[Product]": {
"index": 101,
"hierarchy": "[Product].[Product]",
"UName": "[Product].[Product].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Product].[(All)]",
"LNum": 0,
"DisplayInfo": 397
},
"[Product].[Standard Cost]": {
"index": 102,
"hierarchy": "[Product].[Standard Cost]",
"UName": "[Product].[Standard Cost].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Standard Cost].[(All)]",
"LNum": 0,
"DisplayInfo": 135
},
"[Product].[Category]": {
"index": 103,
"hierarchy": "[Product].[Category]",
"UName": "[Product].[Category].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Category].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Product].[Color]": {
"index": 104,
"hierarchy": "[Product].[Color]",
"UName": "[Product].[Color].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Color].[(All)]",
"LNum": 0,
"DisplayInfo": 10
},
"[Product].[Safety Stock Level]": {
"index": 105,
"hierarchy": "[Product].[Safety Stock Level]",
"UName": "[Product].[Safety Stock Level].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Safety Stock Level].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Product].[Reorder Point]": {
"index": 106,
"hierarchy": "[Product].[Reorder Point]",
"UName": "[Product].[Reorder Point].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Reorder Point].[(All)]",
"LNum": 0,
"DisplayInfo": 6
},
"[Product].[List Price]": {
"index": 107,
"hierarchy": "[Product].[List Price]",
"UName": "[Product].[List Price].[All Products]",
"Caption": "All Products",
"LName": "[Product].[List Price].[(All)]",
"LNum": 0,
"DisplayInfo": 121
},
"[Product].[Size]": {
"index": 108,
"hierarchy": "[Product].[Size]",
"UName": "[Product].[Size].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Size].[(All)]",
"LNum": 0,
"DisplayInfo": 19
},
"[Product].[Size Range]": {
"index": 109,
"hierarchy": "[Product].[Size Range]",
"UName": "[Product].[Size Range].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Size Range].[(All)]",
"LNum": 0,
"DisplayInfo": 11
},
"[Product].[Weight]": {
"index": 110,
"hierarchy": "[Product].[Weight]",
"UName": "[Product].[Weight].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Weight].[(All)]",
"LNum": 0,
"DisplayInfo": 128
},
"[Product].[Days to Manufacture]": {
"index": 111,
"hierarchy": "[Product].[Days to Manufacture]",
"UName": "[Product].[Days to Manufacture].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Days to Manufacture].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Product].[Dealer Price]": {
"index": 112,
"hierarchy": "[Product].[Dealer Price]",
"UName": "[Product].[Dealer Price].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Dealer Price].[(All)]",
"LNum": 0,
"DisplayInfo": 121
},
"[Product].[Class]": {
"index": 113,
"hierarchy": "[Product].[Class]",
"UName": "[Product].[Class].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Class].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Product].[Style]": {
"index": 114,
"hierarchy": "[Product].[Style]",
"UName": "[Product].[Style].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Style].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Product].[Model Name]": {
"index": 115,
"hierarchy": "[Product].[Model Name]",
"UName": "[Product].[Model Name].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Model Name].[(All)]",
"LNum": 0,
"DisplayInfo": 120
},
"[Product].[Product Line]": {
"index": 116,
"hierarchy": "[Product].[Product Line]",
"UName": "[Product].[Product Line].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Product Line].[(All)]",
"LNum": 0,
"DisplayInfo": 5
},
"[Product].[Subcategory]": {
"index": 117,
"hierarchy": "[Product].[Subcategory]",
"UName": "[Product].[Subcategory].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Subcategory].[(All)]",
"LNum": 0,
"DisplayInfo": 37
},
"[Product].[Status]": {
"index": 118,
"hierarchy": "[Product].[Status]",
"UName": "[Product].[Status].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Status].[(All)]",
"LNum": 0,
"DisplayInfo": 2
},
"[Product].[Start Date]": {
"index": 119,
"hierarchy": "[Product].[Start Date]",
"UName": "[Product].[Start Date].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Start Date].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Product].[End Date]": {
"index": 120,
"hierarchy": "[Product].[End Date]",
"UName": "[Product].[End Date].[All Products]",
"Caption": "All Products",
"LName": "[Product].[End Date].[(All)]",
"LNum": 0,
"DisplayInfo": 3
},
"[Product].[Large Photo]": {
"index": 121,
"hierarchy": "[Product].[Large Photo]",
"UName": "[Product].[Large Photo].[All Products]",
"Caption": "All Products",
"LName": "[Product].[Large Photo].[(All)]",
"LNum": 0,
"DisplayInfo": 606
},
"[Sales Territory].[Sales Territory]": {
"index": 122,
"hierarchy": "[Sales Territory].[Sales Territory]",
"UName": "[Sales Territory].[Sales Territory].[All Sales Territories]",
"Caption": "All Sales Territories",
"LName": "[Sales Territory].[Sales Territory].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Sales Territory].[Sales Territory Region]": {
"index": 123,
"hierarchy": "[Sales Territory].[Sales Territory Region]",
"UName": "[Sales Territory].[Sales Territory Region].[All Sales Territories]",
"Caption": "All Sales Territories",
"LName": "[Sales Territory].[Sales Territory Region].[(All)]",
"LNum": 0,
"DisplayInfo": 11
},
"[Sales Territory].[Sales Territory Country]": {
"index": 124,
"hierarchy": "[Sales Territory].[Sales Territory Country]",
"UName": "[Sales Territory].[Sales Territory Country].[All Sales Territories]",
"Caption": "All Sales Territories",
"LName": "[Sales Territory].[Sales Territory Country].[(All)]",
"LNum": 0,
"DisplayInfo": 7
},
"[Sales Territory].[Sales Territory Group]": {
"index": 125,
"hierarchy": "[Sales Territory].[Sales Territory Group]",
"UName": "[Sales Territory].[Sales Territory Group].[All Sales Territories]",
"Caption": "All Sales Territories",
"LName": "[Sales Territory].[Sales Territory Group].[(All)]",
"LNum": 0,
"DisplayInfo": 4
},
"[Reseller Sales Order Details].[Reseller Sales Orders]": {
"index": 126,
"hierarchy": "[Reseller Sales Order Details].[Reseller Sales Orders]",
"UName": "[Reseller Sales Order Details].[Reseller Sales Orders].[All]",
"Caption": "All",
"LName": "[Reseller Sales Order Details].[Reseller Sales Orders].[(All)]",
"LNum": 0,
"DisplayInfo": 1000
},
"[Reseller Sales Order Details].[Carrier Tracking Number]": {
"index": 127,
"hierarchy": "[Reseller Sales Order Details].[Carrier Tracking Number]",
"UName": "[Reseller Sales Order Details].[Carrier Tracking Number].[All Reseller Sales Orders]",
"Caption": "All Reseller Sales Orders",
"LName": "[Reseller Sales Order Details].[Carrier Tracking Number].[(All)]",
"LNum": 0,
"DisplayInfo": 1000
},
"[Reseller Sales Order Details].[Customer PO Number]": {
"index": 128,
"hierarchy": "[Reseller Sales Order Details].[Customer PO Number]",
"UName": "[Reseller Sales Order Details].[Customer PO Number].[All Reseller Sales Orders]",
"Caption": "All Reseller Sales Orders",
"LName": "[Reseller Sales Order Details].[Customer PO Number].[(All)]",
"LNum": 0,
"DisplayInfo": 1000
},
"[Reseller Sales Order Details].[Sales Order Number]": {
"index": 129,
"hierarchy": "[Reseller Sales Order Details].[Sales Order Number]",
"UName": "[Reseller Sales Order Details].[Sales Order Number].[All Reseller Sales Orders]",
"Caption": "All Reseller Sales Orders",
"LName": "[Reseller Sales Order Details].[Sales Order Number].[(All)]",
"LNum": 0,
"DisplayInfo": 1000
},
"[Reseller Sales Order Details].[Sales Order Line]": {
"index": 130,
"hierarchy": "[Reseller Sales Order Details].[Sales Order Line]",
"UName": "[Reseller Sales Order Details].[Sales Order Line].[All Reseller Sales Orders]",
"Caption": "All Reseller Sales Orders",
"LName": "[Reseller Sales Order Details].[Sales Order Line].[(All)]",
"LNum": 0,
"DisplayInfo": 1000
},
"[Source Currency].[Source Currency Code]": {
"index": 131,
"hierarchy": "[Source Currency].[Source Currency Code]",
"UName": "[Source Currency].[Source Currency Code].[All Source Currencies]",
"Caption": "All Source Currencies",
"LName": "[Source Currency].[Source Currency Code].[(All)]",
"LNum": 0,
"DisplayInfo": 105
},
"[Source Currency].[Source Currency]": {
"index": 132,
"hierarchy": "[Source Currency].[Source Currency]",
"UName": "[Source Currency].[Source Currency].[All Source Currencies]",
"Caption": "All Source Currencies",
"LName": "[Source Currency].[Source Currency].[(All)]",
"LNum": 0,
"DisplayInfo": 105
},
"[Destination Currency].[Destination Currency]": {
"index": 133,
"hierarchy": "[Destination Currency].[Destination Currency]",
"UName": "[Destination Currency].[Destination Currency].&[US Dollar]",
"Caption": "US Dollar",
"LName": "[Destination Currency].[Destination Currency].[Destination Currency]",
"LNum": 0,
"DisplayInfo": 0
},
"[Destination Currency].[Destination Currency Code]": {
"index": 134,
"hierarchy": "[Destination Currency].[Destination Currency Code]",
"UName": "[Destination Currency].[Destination Currency Code].[All Destination Currencies]",
"Caption": "All Destination Currencies",
"LName": "[Destination Currency].[Destination Currency Code].[(All)]",
"LNum": 0,
"DisplayInfo": 14
}
}
],
"hierarchies": [
{
"index": 0,
"name": "[Measures]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 1,
"name": "[Date].[Fiscal]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 2,
"name": "[Date].[Calendar Weeks]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 3,
"name": "[Date].[Fiscal Weeks]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 4,
"name": "[Date].[Fiscal Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 5,
"name": "[Date].[Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 6,
"name": "[Date].[Day of Week]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 7,
"name": "[Date].[Day Name]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 8,
"name": "[Date].[Day of Month]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 9,
"name": "[Date].[Day of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 10,
"name": "[Date].[Calendar Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 11,
"name": "[Date].[Fiscal Semester of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 12,
"name": "[Date].[Calendar Semester of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 13,
"name": "[Date].[Fiscal Quarter of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 14,
"name": "[Date].[Calendar Quarter of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 15,
"name": "[Date].[Month of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 16,
"name": "[Date].[Calendar Week of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 17,
"name": "[Date].[Fiscal Week of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 18,
"name": "[Ship Date].[Fiscal]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 19,
"name": "[Ship Date].[Calendar]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 20,
"name": "[Ship Date].[Calendar Weeks]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 21,
"name": "[Ship Date].[Fiscal Weeks]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 22,
"name": "[Ship Date].[Fiscal Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 23,
"name": "[Ship Date].[Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 24,
"name": "[Ship Date].[Day of Week]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 25,
"name": "[Ship Date].[Day Name]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 26,
"name": "[Ship Date].[Day of Month]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 27,
"name": "[Ship Date].[Day of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 28,
"name": "[Ship Date].[Calendar Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 29,
"name": "[Ship Date].[Fiscal Semester of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 30,
"name": "[Ship Date].[Calendar Semester of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 31,
"name": "[Ship Date].[Fiscal Quarter of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 32,
"name": "[Ship Date].[Calendar Quarter of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 33,
"name": "[Ship Date].[Month of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 34,
"name": "[Ship Date].[Calendar Week of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 35,
"name": "[Ship Date].[Fiscal Week of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 36,
"name": "[Delivery Date].[Fiscal]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 37,
"name": "[Delivery Date].[Calendar]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 38,
"name": "[Delivery Date].[Calendar Weeks]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 39,
"name": "[Delivery Date].[Fiscal Weeks]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 40,
"name": "[Delivery Date].[Fiscal Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 41,
"name": "[Delivery Date].[Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 42,
"name": "[Delivery Date].[Day of Week]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 43,
"name": "[Delivery Date].[Day Name]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 44,
"name": "[Delivery Date].[Day of Month]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 45,
"name": "[Delivery Date].[Day of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 46,
"name": "[Delivery Date].[Calendar Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 47,
"name": "[Delivery Date].[Fiscal Semester of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 48,
"name": "[Delivery Date].[Calendar Semester of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 49,
"name": "[Delivery Date].[Fiscal Quarter of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 50,
"name": "[Delivery Date].[Calendar Quarter of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 51,
"name": "[Delivery Date].[Month of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 52,
"name": "[Delivery Date].[Calendar Week of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 53,
"name": "[Delivery Date].[Fiscal Week of Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 54,
"name": "[Reseller].[Reseller Type]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 55,
"name": "[Reseller].[Reseller Bank]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 56,
"name": "[Reseller].[Reseller Order Frequency]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 57,
"name": "[Reseller].[Reseller Order Month]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 58,
"name": "[Reseller].[Reseller]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 59,
"name": "[Reseller].[Product Line]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 60,
"name": "[Reseller].[Business Type]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 61,
"name": "[Reseller].[Number of Employees]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 62,
"name": "[Reseller].[Annual Sales]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 63,
"name": "[Reseller].[Annual Revenue]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 64,
"name": "[Reseller].[Bank Name]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 65,
"name": "[Reseller].[Order Frequency]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 66,
"name": "[Reseller].[Order Month]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 67,
"name": "[Geography].[City]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 68,
"name": "[Geography].[State-Province]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 69,
"name": "[Geography].[Country]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 70,
"name": "[Geography].[Postal Code]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 71,
"name": "[Employee].[Employee Department]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 72,
"name": "[Employee].[Department Name]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 73,
"name": "[Employee].[Sales Person Flag]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 74,
"name": "[Employee].[Title]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 75,
"name": "[Employee].[Hire Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 76,
"name": "[Employee].[Sick Leave Hours]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 77,
"name": "[Employee].[Vacation Hours]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 78,
"name": "[Employee].[Base Rate]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 79,
"name": "[Employee].[Pay Frequency]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 80,
"name": "[Employee].[Phone]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 81,
"name": "[Employee].[Salaried Flag]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 82,
"name": "[Employee].[Gender]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 83,
"name": "[Employee].[Marital Status]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 84,
"name": "[Employee].[Employees]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 85,
"name": "[Employee].[Status]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 86,
"name": "[Employee].[Start Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 87,
"name": "[Employee].[End Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 88,
"name": "[Employee].[Hire Year]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 89,
"name": "[Promotion].[Promotions]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 90,
"name": "[Promotion].[Promotion]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 91,
"name": "[Promotion].[Discount Percent]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 92,
"name": "[Promotion].[Max Quantity]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 93,
"name": "[Promotion].[Promotion Type]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 94,
"name": "[Promotion].[Min Quantity]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 95,
"name": "[Promotion].[Promotion Category]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 96,
"name": "[Promotion].[End Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 97,
"name": "[Promotion].[Start Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 98,
"name": "[Product].[Product Categories]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 99,
"name": "[Product].[Product Model Lines]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 100,
"name": "[Product].[Stock Level]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 101,
"name": "[Product].[Product]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 102,
"name": "[Product].[Standard Cost]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 103,
"name": "[Product].[Category]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 104,
"name": "[Product].[Color]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 105,
"name": "[Product].[Safety Stock Level]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 106,
"name": "[Product].[Reorder Point]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 107,
"name": "[Product].[List Price]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 108,
"name": "[Product].[Size]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 109,
"name": "[Product].[Size Range]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 110,
"name": "[Product].[Weight]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 111,
"name": "[Product].[Days to Manufacture]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 112,
"name": "[Product].[Dealer Price]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 113,
"name": "[Product].[Class]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 114,
"name": "[Product].[Style]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 115,
"name": "[Product].[Model Name]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 116,
"name": "[Product].[Product Line]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 117,
"name": "[Product].[Subcategory]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 118,
"name": "[Product].[Status]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 119,
"name": "[Product].[Start Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 120,
"name": "[Product].[End Date]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 121,
"name": "[Product].[Large Photo]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 122,
"name": "[Sales Territory].[Sales Territory]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 123,
"name": "[Sales Territory].[Sales Territory Region]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 124,
"name": "[Sales Territory].[Sales Territory Country]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 125,
"name": "[Sales Territory].[Sales Territory Group]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 126,
"name": "[Reseller Sales Order Details].[Reseller Sales Orders]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 127,
"name": "[Reseller Sales Order Details].[Carrier Tracking Number]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 128,
"name": "[Reseller Sales Order Details].[Customer PO Number]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 129,
"name": "[Reseller Sales Order Details].[Sales Order Number]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 130,
"name": "[Reseller Sales Order Details].[Sales Order Line]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 131,
"name": "[Source Currency].[Source Currency Code]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 132,
"name": "[Source Currency].[Source Currency]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 133,
"name": "[Destination Currency].[Destination Currency]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
},
{
"index": 134,
"name": "[Destination Currency].[Destination Currency Code]",
"UName": null,
"Caption": null,
"LName": null,
"LNum": null,
"DisplayInfo": null
}
]
},
"cells": [
{
"Value": null,
"FmtValue": null,
"FormatString": null,
"ordinal": 0
},
{
"Value": null,
"FmtValue": null,
"FormatString": null,
"ordinal": 1
},
{
"ordinal": 2
},
{
"ordinal": 3
},
{
"ordinal": 4
},
{
"ordinal": 5
},
{
"ordinal": 6
},
{
"ordinal": 7
},
{
"Value": null,
"FmtValue": null,
"FormatString": null,
"ordinal": 8
},
{
"ordinal": 9
},
{
"ordinal": 10
},
{
"ordinal": 11
},
{
"Value": null,
"FmtValue": null,
"FormatString": null,
"ordinal": 12
},
{
"Value": null,
"FmtValue": null,
"FormatString": null,
"ordinal": 13
},
{
"ordinal": 14
},
{
"ordinal": 15
},
{
"Value": null,
"FmtValue": null,
"FormatString": null,
"ordinal": 16
},
{
"ordinal": 17
},
{
"ordinal": 18
},
{
"ordinal": 19
},
{
"ordinal": 20
},
{
"ordinal": 21
},
{
"ordinal": 22
},
{
"ordinal": 23
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment