Is there a API property to the QueryAxis or related objects to trigger the display of the individual members of a dimension when added to the DataSelector. Currently when the dimension is added, it returns the .All member which represents a grand total when we are really looking for the individual members to display. To provide for this we are triggering the DrillDown of the member after its is added to the DataSelector which triggers a subsequent query. However, this is not desireable as it creates 2 queries for every DataSelector change of the user dropping a dimension into view.
Guidance on this welcomed and thanks in advance.
Hi
You can change your dimension definition to dismis All member and to start from first level, then you will be able to see the members in first level
Todor
We are looking for a solution from the Visualization side. We would not want to remove the aggregation level of [All] for our dimensions. Any other recommendations with the DataSource API?
At this vesrion we dont support executing of MDX query. I hope in next version 12.1 to expose such functionality.