 Bad MDX produced by OWC? -
10-25-2004
, 09:26 AM
Hi,
I encountered a problem with OWC (10) pivottable / chart. The pivottable
doesn't load the data at once. Instead it produce several statements to load
the data.
If you query the mdx statements with an other tool you can see that the data
set contains ALL data from the last select plus the new columns not just the
single column as i would expect. These behavior results in very bad
performance if you request larger resulsets. I think this is a real bug in
OWC MDX querying.
I tried to produce the behavior with the foodmart sample:
- Sales cube (only [profit]-measure)
- [Product] on column (all levels) filtered to ([Drink] only)
- [Time].[Month] on rows
Thanks Andreas
Here is the log file from OWC:
(Sorry for the long log)
iexplore:1780 25.10.2004 14:19:30 MDX Drop visual totals for [Sales]
iexplore:1780 25.10.2004 14:19:30 MDX CREATE SESSION
SET [Sales].Pivot6Hier4 AS
'
VISUALTOTALS(
HIERARCHIZE(
{
[Product].[All Products],
[Product].[All Products].[Drink]
}
)
)
'
iexplore:1780 25.10.2004 14:19:30 MDX DROP SET [Sales].Pivot6Hier4
iexplore:1780 25.10.2004 14:19:30 MDX CREATE SESSION
SET [Sales].Pivot6Axis0Set0 AS
'
{
{ [Product].[All Products] },
HIERARCHIZE(
{
[Product].[All Products].[Drink]
}
)
}
'
SET [Sales].Pivot6Axis1Set0 AS
'
{
{ [Time].[1997] },
AddCalculatedMembers([Time].[Month].MEMBERS)
}
'
iexplore:1780 25.10.2004 14:19:30 MDX SELECT
NON EMPTY Pivot6Axis0Set0
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot6Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:30 MDX CREATE SESSION
SET [Sales].Pivot6Axis0Set1 AS
'
{
Pivot6Axis0Set0,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Product Department]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:30 MDX SELECT
NON EMPTY Pivot6Axis0Set1
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot6Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:30 MDX DROP SET [Sales].Pivot6Axis0Set0
iexplore:1780 25.10.2004 14:19:30 MDX CREATE SESSION
SET [Sales].Pivot6Axis0Set2 AS
'
{
Pivot6Axis0Set1,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Product Category]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:30 MDX SELECT
NON EMPTY Pivot6Axis0Set2
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot6Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:30 MDX DROP SET [Sales].Pivot6Axis0Set1
iexplore:1780 25.10.2004 14:19:30 MDX CREATE SESSION
SET [Sales].Pivot6Axis0Set3 AS
'
{
Pivot6Axis0Set2,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Product Subcategory]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:30 MDX SELECT
NON EMPTY Pivot6Axis0Set3
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot6Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:30 MDX DROP SET [Sales].Pivot6Axis0Set2
iexplore:1780 25.10.2004 14:19:30 MDX CREATE SESSION
SET [Sales].Pivot6Axis0Set4 AS
'
{
Pivot6Axis0Set3,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Brand Name]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:30 MDX SELECT
NON EMPTY Pivot6Axis0Set4
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot6Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:30 MDX DROP SET [Sales].Pivot6Axis0Set3
iexplore:1780 25.10.2004 14:19:33 MDX Drop visual totals for [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Hier4 AS
'
VISUALTOTALS(
HIERARCHIZE(
{
[Product].[All Products],
[Product].[All Products].[Drink]
}
)
)
'
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Hier4
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set0 AS
'
{
{ [Product].[All Products] },
HIERARCHIZE(
{
[Product].[All Products].[Drink]
}
)
}
'
SET [Sales].Pivot7Axis1Set0 AS
'
{
{ [Time].[1997] },
AddCalculatedMembers([Time].[Month].MEMBERS)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set0
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set1 AS
'
{
Pivot7Axis0Set0,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Product Department]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set1
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set0
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set2 AS
'
{
Pivot7Axis0Set1,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Product Category]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set2
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set1
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set3 AS
'
{
Pivot7Axis0Set2,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Product Subcategory]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set3
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set2
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set4 AS
'
{
Pivot7Axis0Set3,
HIERARCHIZE(
AddCalculatedMembers(
GENERATE(
{
[Product].[All Products].[Drink]
},
DESCENDANTS(
[Product].CURRENTMEMBER,
[Product].[Brand Name]
)
)
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set4
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set3
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set5 AS
'
{
Pivot7Axis0Set4,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Beer].[Good],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set5
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set4
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set6 AS
'
{
Pivot7Axis0Set5,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Beer].[Pearl],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set6
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set5
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set7 AS
'
{
Pivot7Axis0Set6,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Beer].[Portsmouth],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set7
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set6
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set8 AS
'
{
Pivot7Axis0Set7,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Beer].[Top Measure],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set8
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set7
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot6Axis0Set4
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot6Axis1Set0
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set9 AS
'
{
Pivot7Axis0Set8,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Beer].[Walrus],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set9
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set8
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set10 AS
'
{
Pivot7Axis0Set9,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Good],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set10
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set9
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set11 AS
'
{
Pivot7Axis0Set10,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Pearl],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set11
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set10
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set12 AS
'
{
Pivot7Axis0Set11,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Portsmouth],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set12
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set11
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set13 AS
'
{
Pivot7Axis0Set12,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Top Measure],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set13
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set12
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set14 AS
'
{
Pivot7Axis0Set13,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Alcoholic Beverages].[Beer and
Wine].[Wine].[Walrus],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set14
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set13
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set15 AS
'
{
Pivot7Axis0Set14,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Carbonated
Beverages].[Soda].[Excellent],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set15
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set14
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set16 AS
'
{
Pivot7Axis0Set15,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Carbonated
Beverages].[Soda].[Fabulous],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set16
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set15
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set17 AS
'
{
Pivot7Axis0Set16,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Carbonated
Beverages].[Soda].[Skinner],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set17
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set16
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set18 AS
'
{
Pivot7Axis0Set17,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Carbonated
Beverages].[Soda].[Token],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set18
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set17
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set19 AS
'
{
Pivot7Axis0Set18,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Carbonated
Beverages].[Soda].[Washington],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set19
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set18
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set20 AS
'
{
Pivot7Axis0Set19,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored
Drinks].[Excellent],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set20
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:33 MDX DROP SET [Sales].Pivot7Axis0Set19
iexplore:1780 25.10.2004 14:19:33 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set21 AS
'
{
Pivot7Axis0Set20,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored
Drinks].[Fabulous],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:33 MDX SELECT
NON EMPTY Pivot7Axis0Set21
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set20
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set22 AS
'
{
Pivot7Axis0Set21,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored
Drinks].[Skinner],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set22
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set21
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set23 AS
'
{
Pivot7Axis0Set22,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored
Drinks].[Token],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set23
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set22
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set24 AS
'
{
Pivot7Axis0Set23,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Drinks].[Flavored
Drinks].[Washington],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set24
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set23
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set25 AS
'
{
Pivot7Axis0Set24,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Chocolate].[BBB Best],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set25
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set24
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set26 AS
'
{
Pivot7Axis0Set25,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Chocolate].[CDR],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set26
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set25
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set27 AS
'
{
Pivot7Axis0Set26,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Chocolate].[Landslide],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set27
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set26
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set28 AS
'
{
Pivot7Axis0Set27,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Chocolate].[Plato],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set28
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set27
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set29 AS
'
{
Pivot7Axis0Set28,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Chocolate].[Super],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set29
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set28
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set30 AS
'
{
Pivot7Axis0Set29,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Coffee].[BBB Best],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set30
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set29
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set31 AS
'
{
Pivot7Axis0Set30,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Coffee].[CDR],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set31
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set30
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set32 AS
'
{
Pivot7Axis0Set31,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Coffee].[Landslide],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set32
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set31
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set33 AS
'
{
Pivot7Axis0Set32,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Coffee].[Plato],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set33
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set32
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set34 AS
'
{
Pivot7Axis0Set33,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Hot
Beverages].[Coffee].[Super],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set34
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set33
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set35 AS
'
{
Pivot7Axis0Set34,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Pure Juice
Beverages].[Juice].[Excellent],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set35
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set34
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set36 AS
'
{
Pivot7Axis0Set35,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Pure Juice
Beverages].[Juice].[Fabulous],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set36
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set35
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set37 AS
'
{
Pivot7Axis0Set36,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Pure Juice
Beverages].[Juice].[Skinner],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set37
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set36
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set38 AS
'
{
Pivot7Axis0Set37,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Pure Juice
Beverages].[Juice].[Token],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set38
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:34 MDX DROP SET [Sales].Pivot7Axis0Set37
iexplore:1780 25.10.2004 14:19:34 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set39 AS
'
{
Pivot7Axis0Set38,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Beverages].[Pure Juice
Beverages].[Juice].[Washington],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:34 MDX SELECT
NON EMPTY Pivot7Axis0Set39
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:35 MDX DROP SET [Sales].Pivot7Axis0Set38
iexplore:1780 25.10.2004 14:19:35 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set40 AS
'
{
Pivot7Axis0Set39,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Booker],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:35 MDX SELECT
NON EMPTY Pivot7Axis0Set40
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:35 MDX DROP SET [Sales].Pivot7Axis0Set39
iexplore:1780 25.10.2004 14:19:35 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set41 AS
'
{
Pivot7Axis0Set40,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Carlson],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:35 MDX SELECT
NON EMPTY Pivot7Axis0Set41
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:35 MDX DROP SET [Sales].Pivot7Axis0Set40
iexplore:1780 25.10.2004 14:19:35 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set42 AS
'
{
Pivot7Axis0Set41,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Club],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:35 MDX SELECT
NON EMPTY Pivot7Axis0Set42
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:35 MDX DROP SET [Sales].Pivot7Axis0Set41
iexplore:1780 25.10.2004 14:19:35 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set43 AS
'
{
Pivot7Axis0Set42,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Even Better],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:35 MDX SELECT
NON EMPTY Pivot7Axis0Set43
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
iexplore:1780 25.10.2004 14:19:35 MDX DROP SET [Sales].Pivot7Axis0Set42
iexplore:1780 25.10.2004 14:19:35 MDX CREATE SESSION
SET [Sales].Pivot7Axis0Set44 AS
'
{
Pivot7Axis0Set43,
AddCalculatedMembers(
DESCENDANTS(
[Product].[All Products].[Drink].[Dairy].[Dairy].[Milk].[Gorilla],
[Product].[Product Name]
)
)
}
'
iexplore:1780 25.10.2004 14:19:35 MDX SELECT
NON EMPTY Pivot7Axis0Set44
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
NON EMPTY Pivot7Axis1Set0
DIMENSION PROPERTIES MEMBER_NAME ON ROWS,
{
[Measures].[Profit]
}
ON PAGES
FROM [Sales]
 |
Linear Mode
