Replied 3 August 2017, 3:52 pm EST
Regarding your question I would like to highlight some points related to the issue:
(1) Please note that DDA has limitation of display points. This limit can be changed using PivotView.WarningTreschold property. For this you can go through the following online help document:
Number of data poins is number of possible positions in multidimensional cube with 5 dimensions: Rows, Colums, Pages, Data and Encodings. If only one dimension is used, the number of points are equal to number of positions in this axis. For example, if there is only one attribute in Rows shelf, then number of points will be equal to number of result values of the attribute expression.
(2) You can define Hierarchies and attributes using query fields and VB expressions for example string concatenation and other.
For this you can go through the following forum post which demonstrate the above points for measures
A query string to DB represents list of the query fields. You can define additional query fields using VB and existing Query fields.
(3) It is necessary to define the attributes and hierarchies in a way to keep the number of their result values minimal. DDA try’s to process all values of the result attribute or hierarchy expression. If you have obtained many values (for example all days in the century), may be it is necessary to define this schema item as measure or aggregate requested data (returns only months).
If you would like to have a limitation on the processed data then I can go ahead and enter a feature request to implement this.
Let me know if you need further assistance/clarification.