Totals don't reflect filtering in Pivot Component when linked to OLAP

J

JamesK

Dear All

I am using OWC10 to link to OLAP cubes and the grand totals are not reflecting the filter selections I make on the pivot (Row header / column header). This only appears to be a problem when I use the OpeningPeriod and ClosingPeriod MDX functions in OLAP

Can someone point me in the right direction on how to best control totals from OLAP into the Pivot Table component. My data source is essentially a time dimension (with default levels) and my measure is using the OpeningPeriod function

Thanks

Kind regards
Jame
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visual Totals functionality when not using the MSOLAP provider 0
Visual Totals functionality when not using the MSOLAP provider 6
AS2000-OLAP Cube (Distinct Count) & OWC11 - Pivot Tables 2
Big question, PivotTable creation in code. !!! 0
Get list of field members OWC PivotList 10.0 1
Customised Totals in Pivot Tables 0
Actions using OWC Pivot Table and OLAP 2
Repost: Simple Pivot Table Totals Question 0

Top