With MDX you can specify a range of values for a given query using the colon (:) operator. I'm interested in doing something similar in the 'Filters' property of my AdomdDataSource to filter my results by date.
I have a Year->Month->Day->Hour hierarchy and I'm trying the following filter:
[Time].[Year]{[Time].[Year].[Day].[Hour].&[2014]&[Mar]&[15]&[12]:[Time].[Year].[Day].[Hour].&[2014]&[Mar]&[15]&[16]}
However, this results in only the two members 2014/Mar/15/2 and 2014/Mar/15/16 instead of all the members in between. Is there a different syntax for this operation?
Hello,
I have been looking into your description and it seems that currently this functionality is not supported by the XamPivotGrid control. You can suggest it as new Product Idea for future versions at http://ideas.infragistics.com.
Steps to create your idea:
The benefits of submitting the product idea yourself include:
- Direct communication with our product management team regarding your product idea.
- Notifications whenever new information regarding your idea becomes available.
Additional benefits of the Product Idea system include:
- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
- Allow you to shape the future of our products by requesting new controls and products altogether.
- You and other developers can discuss existing product ideas with members of our Product Management team.
The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.