Applying date ranges in Pivot table

B

brigitta

Hi all ,
I am facing a problem with applying date ranges on the
Pivot table data (OWC10 or OWC11) .I have to give the user
option to filter the data by a specified date range.I am
not able to specify named sets for creating date ranges as
part of the MDX query since the Pivottable does not
support named sets in MDX queries. Can I achieve the same
by any other means ?


can someone help please?

thanks
brigitta
 
C

Chris Magoun

I ran into a similar problem. Unfortunately, the solution I ended up
implementing did away with MDX queries altogether. Instead, the user-defined
parameters are captured, and passed to the client via a simple XML document.
Then, a client-side javascript formats the PivotTable via the object model.

If this solution seems potentially useful to you, and you need more details
on how to implement it, I will post more.

Chris Magoun
 
J

judy123

Hi, Christ

Could you post me more? I am facing the same problem. I tried to use
calculated member or name set, but owc does not support them.

Thanks in advance.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
OWC11 pivot table export to excel fail: missing tag row (seems to 0
Pivot Table 1
How to get OWC PivotTable data into an Excel Application 1
SUM & OFFSET & PIVOT TABLE?? 0
Dsum and Dmax with structured references 1
DATE Calculations in pivot table 0
Pivot Table Drillthrough capability lost 0

Top