Posted 3 August 2017, 3:55 pm ESTIs it possible to add a flag or some other approach that would allow me to offer an incremental data extraction from a relational query?
To my knowledge, when the Analysis control is connected to a relational database, it loads the full query results into memory and then manages the data internally. This is fine for small data sets, but when connected to a large query, the control comes to a stand still on the first drag operation.
This is what I would like to see. Mind you that this is a very simply scenario:
Assume that I have 3 attributes and 2 measures:
If I drag ClassCode to the Column shelf, I would like for the data source to issue the following SQL:
<blockquote><font face="Courier New">'select ClassCode from Table groupby ClassCode'</font>
Then I drag Family to Column it would issue another query:
<blockquote><font face="Courier New">'select
ClassCode, Family from Table groupby ClassCode, Family'</font>
Then I drag Cost to the Row shelf:
<blockquote><font face="Courier New">'select ClassCode, Family, sum(Cost)
from Table groupby ClassCode, Family'
</font></blockquote>I know that when connected to an MDX data source, this happens, but I'm not sure why it doesn't (or couldn't) do this for an OleDb data source.
Has there been any talk of doing this?
Thank you in advance!