User (Legacy) Posted October 19, 2004 Report Posted October 19, 2004 Background: Using ChartFx Trial 6.2 with Olap Extension. I have an mdx query returning 1 measure and 3 dimensions (Time, Geography, PropertyType). Under the Time dimension are Quarters 1 - 4. Under Geography, I have any number of regions and under each region I have any number of cities. Under property type, I have 3 property types that each can have any number of sub types. With this scenario, capturing the click event and reading the series is just about useless because it is returned out of context. When the user clicks on a series, I want to know which dimension, level, etc. are being used to display the data in the chart. Alternatively, I can try trapping when the user clicks in the analysis bar(expands node, de-selects dimension, selects dimension), and build a collection of items referring to the data displayed. I can't determine how to do this. The real issue is determining at any one time what the series values on the chart are referring to. Any help appreciated.
Software FX Posted October 29, 2004 Report Posted October 29, 2004 We just added a new method called GetDimensionStates, this method receives a series and a point and returns a collection of DimensionStates. The DimensionState class exposes 3 string properties: Dimension, Level and Value that will let you know all the data for a particular bar/marker. Note that if the current level of a dimension is the top level summarization, you will receive a value of (All). This is the string returned by the OLAP engine. If you need more information about a dimension or a level you can use olap.Dimensions[dimState.Dimension] olap.Dimensions[dimState.Dimension].Levels[dimState.Level] Also note that this method will return as many DimensionStates as Dimensions in your MDX statement. For tree dimensions you must ignore the Level property as a tree-like dimension can show multiple levels simultaneously. -- Regards, JC Software FX Support "Chris Exley" <cexley@comcast.net> wrote in message news:pA$JFVktEHA.3240@webserver3.softwarefx.com... > Background: > > Using ChartFx Trial 6.2 with Olap Extension. > > I have an mdx query returning 1 measure and 3 dimensions (Time, > Geography, PropertyType). Under the Time dimension are Quarters 1 - 4. > Under Geography, I have any number of regions and under each region I have > any number of cities. Under property type, I have 3 property types that > each can have any number of sub types. > > With this scenario, capturing the click event and reading the series is > just about useless because it is returned out of context. > > When the user clicks on a series, I want to know which dimension, level, > etc. are being used to display the data in the chart. > > Alternatively, I can try trapping when the user clicks in the analysis > bar(expands node, de-selects dimension, selects dimension), and build a > collection of items referring to the data displayed. I can't determine > how to do this. > > The real issue is determining at any one time what the series values on > the chart are referring to. > > Any help appreciated. > >
Recommended Posts
Archived
This topic is now archived and is closed to further replies.