RE: OWC 11.0 - Subtotals return incorrect values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi there Charles,

Using OWC in an ASP page pointing to the "Adventure Works DW" cube, perform
the following:-

1) Drag "Product Categories" natural hierarchy into the page filter area.
2) Right click, select commands and Options. Click on the "Filter and Group
tab, check "Allow selecting multiple items when in the filter area" check box.
3) Select the following items:-
Under Accessories | Helmets
- Sport - 100 Helmet, Red (all three)
- Sport - 100 Helmet, Blue
Under Accessories | Tires and Tubes
- Road Tire Tube
- LL Mountain Tire
4) Drag in "Internet Sales Ammount" as a value. The total is now 109,049.32
5) Drag Customer into the Row Fields area. The total at the bottom is still
109,049.32 Select the following customers:-
- Aaron B. Adams
- Aaron Bryant
NB: Note the total of AAron B. Adams is 38.98
6) To break out the value into products we drag the Product attribute
dimension next to the Customer Fields on the rows. Suddenly the Internet
Sales Amount for Aaron B. Adams is 117.96 and NOT 38.98.

If we expand the customer Aaron B. Adams to see the break out of Products,
we note the following values:-
- Sport - 100 Helmet, Red 34.99
- Road Tire Tube 3.99
- Total 117.96

We can see the same thing if we drag the Products into the Column list.
Basically the totals don't match. The Totals are not applying the filter from
the "Product Categories" (see step 1-3 above), but instead are showing the
FULL total for ALL Products.

We can easily replicate this with any combination of hierarchies in our
cube, and the Adventure Works sample.



""Charles Wang [MSFT]"" wrote:

Hi JPO,
Welcome to the Microsoft MSDN Managed Newsgroup Services. My name is
Charles. It is my pleasure to work with you on this post.

To help isolate if this is an OWC specific issue, could you verify if this
issue also happens in your Excel 2003 workbook?

I performed a test in my Excel 2003 and 2007, however I could not reproduce
this issue. Dragging a level to the pivot table column does not affect the
existing filters. If this issue also happens in your Excel, I suspect that
the issue is related to the incorrect relationships between your dimensions
and measures in your cube. You can run SQL Profiler to monitor your SSAS
instance and capture what the submitted MDX query is and then copy the MDX
query out and paste it into a query window in your SQL Server Management
Studio to check and test. You can also check the query in your Business
Intelligence Studio (BIDS) under Browse window. Please ensure that the
relationship between your dimension and your measure has been established
in your BIDS.

Please do not hesitate to let me know if you have any other questions or
concerns.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================






.

Relevant Pages

  • Re: Task Usage and Resource Usage Reports
    ... columns filtered by a specific resource? ... In the report, the top line is the task name line and the work ... for explaining the results of the filter in each report. ... The row totals do show the total work hours for the entire project, ...
    (microsoft.public.project)
  • Re: Drag from SP2 window to desktop?
    ... > display the same help text as originally displayed by the javascript ... Embedded within the HTML will be lines like this: ... > The idea is that if the user wants to perform a "filter" operation on one ... they can drag and drop the filter icon (which is surrounded ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: PGP Sigs on the Usenet (was: Re: Formatting Posts With VI)
    ... Is it indeed not possible to do filter them? ... Well, there is popular support for the notion, though without penalty, law ... valid basis for future consideration even if one does fail to win the day. ... of slrnpull capability, but it was my impression it was intended for dial-up ...
    (comp.os.linux.misc)
  • Re: Thinking of installing myself...
    ... You could just filter him..... ... Jim and Frank, Keep kicking his ass till the cows come home- but watch ... have been able to talk to me in Tech Support. ... dealer support, and what needs to be done to resolve issues. ...
    (alt.security.alarms)
  • Re: Is there no Good image viewing and managing software ?
    ... feature and what is functionality.. ... is great because it has universal support. ... you should be able to drag ... while I select files - I want to go into tag mode and then click away ...
    (rec.photo.digital)