Unexpected Rollup Behavior in OWC10 when ALL Member Formula Used

[Alexander P. Brown]

BI Gurus,

We built a cube that uses a custom All Member Formula for two of it's
dimensions. When a few items are selected/filtered on the pivot table on
rows or columns for one of these dimensions and the setting Calculate Totals
based on Visible Items Only is set, the Grand Totals always include hidden
rows/columns in their totals. We were expecting the Grand Totals to only
include visible items, as occurs for our other dimensions that do not use a
custom All Member Formula.

Here is an example of an All Member Formula that we use:
SUM({[Product.Kits].[Product Sales Type].[Components].Children,
[Product.Kits].[Product Sales Type].[Finished Goods].Children})
This custom rollup prevents products from being counted twice in totals,
once as components, and once as Kits.

Please let me know if you have any explanations or ideas for workarounds,
thanks in advance.

Alexander P. Brown
The P. stands for Perplexed

 

[Bluetooth]

Hi Alexander,

OWC does it completely wrong with custom rollup. Weird numbers is all you
will get. I have this bug logged for a long time, so far having no luck
escalating it high enough. Current answer is "will be fixed in Office 12".

If you have any way to push this case stronger, please do it. May be when
more upset customers rise their heads, the fix will come sooner.

Best
Szymon Slupik, CTO
CDN S.A
Krakow, Poland

 

[Alvin Bruney [MVP]]

keep this post handy, i intend to submit another round of bugs soon. The
submission goes directly to the product group.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alexander,

OWC does it completely wrong with custom rollup. Weird numbers is all you
will get. I have this bug logged for a long time, so far having no luck
escalating it high enough. Current answer is "will be fixed in Office 12".

If you have any way to push this case stronger, please do it. May be when
more upset customers rise their heads, the fix will come sooner.

Best
Szymon Slupik, CTO
CDN S.A
Krakow, Poland

BI Gurus,

We built a cube that uses a custom All Member Formula for two of it's
dimensions. When a few items are selected/filtered on the pivot table on
rows or columns for one of these dimensions and the setting Calculate Totals
based on Visible Items Only is set, the Grand Totals always include
hidden
rows/columns in their totals. We were expecting the Grand Totals to only
include visible items, as occurs for our other dimensions that do not use a
custom All Member Formula.

Here is an example of an All Member Formula that we use:
SUM({[Product.Kits].[Product Sales Type].[Components].Children,
[Product.Kits].[Product Sales Type].[Finished Goods].Children})
This custom rollup prevents products from being counted twice in totals,
once as components, and once as Kits.

Please let me know if you have any explanations or ideas for workarounds,
thanks in advance.

Alexander P. Brown
The P. stands for Perplexed

 

[Bluetooth]

Alvin
FYI - this is registered as 11514 in OffBug
Best,
Szymon

keep this post handy, i intend to submit another round of bugs soon. The
submission goes directly to the product group.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alexander,

OWC does it completely wrong with custom rollup. Weird numbers is all you
will get. I have this bug logged for a long time, so far having no luck
escalating it high enough. Current answer is "will be fixed in Office 12".

If you have any way to push this case stronger, please do it. May be when
more upset customers rise their heads, the fix will come sooner.

Best
Szymon Slupik, CTO
CDN S.A
Krakow, Poland

BI Gurus,

We built a cube that uses a custom All Member Formula for two of it's
dimensions. When a few items are selected/filtered on the pivot table on
rows or columns for one of these dimensions and the setting Calculate Totals
based on Visible Items Only is set, the Grand Totals always include
hidden
rows/columns in their totals. We were expecting the Grand Totals to only
include visible items, as occurs for our other dimensions that do not

use
a

custom All Member Formula.

Here is an example of an All Member Formula that we use:
SUM({[Product.Kits].[Product Sales Type].[Components].Children,
[Product.Kits].[Product Sales Type].[Finished Goods].Children})
This custom rollup prevents products from being counted twice in totals ,
once as components, and once as Kits.

Please let me know if you have any explanations or ideas for workarounds,
thanks in advance.

Alexander P. Brown
The P. stands for Perplexed

 

[Alvin Bruney [MVP]]

ok

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Alvin
FYI - this is registered as 11514 in OffBug
Best,
Szymon

keep this post handy, i intend to submit another round of bugs soon. The
submission goes directly to the product group.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Alexander,

OWC does it completely wrong with custom rollup. Weird numbers is all you
will get. I have this bug logged for a long time, so far having no luck
escalating it high enough. Current answer is "will be fixed in Office 12".

If you have any way to push this case stronger, please do it. May be when
more upset customers rise their heads, the fix will come sooner.

Best
Szymon Slupik, CTO
CDN S.A
Krakow, Poland

BI Gurus,

We built a cube that uses a custom All Member Formula for two of it's
dimensions. When a few items are selected/filtered on the pivot table on
rows or columns for one of these dimensions and the setting Calculate
Totals
based on Visible Items Only is set, the Grand Totals always include
hidden
rows/columns in their totals. We were expecting the Grand Totals to only
include visible items, as occurs for our other dimensions that do not use
a
custom All Member Formula.

Here is an example of an All Member Formula that we use:
SUM({[Product.Kits].[Product Sales Type].[Components].Children,
[Product.Kits].[Product Sales Type].[Finished Goods].Children})
This custom rollup prevents products from being counted twice in
totals ,
once as components, and once as Kits.

Please let me know if you have any explanations or ideas for workarounds,
thanks in advance.

Alexander P. Brown
The P. stands for Perplexed