Posted 3 August 2017, 3:55 pm ESTHi !
Excuse me for my insistence.
I have some advanced users (risk managers) in our Bank.
They used ProClarity for writing MDX-query.
Then they copy-paste these queries to MS Excel2007 and build charts. Overhead !
My users say:
"DDA have excellent presentation, object model but we want custom MDX supply"
Dim _MdxDataSource As New MdxDataSource
_MdxDataSource.ConnectionString = "Provider=MSOLAP.3;...."
_MdxDataSource.Cube = "TestCube"
'---- Why not implement this for ADVANCED USERS ?
_MdxDataSource.query = "Select ... FROM TestCube"
'---- and flatten result of this query use as source for DDA
_pivotView.DataSource = _MdxDataSource