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:
'select ClassCode from Table groupby ClassCode'
Then I drag Family to Column it would issue another query:
ClassCode, Family from Table groupby ClassCode, Family'
Then I drag Cost to the Row shelf:
'select ClassCode, Family, sum(Cost)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.
from Table groupby ClassCode, Family'
Has there been any talk of doing this?
Thank you in advance!