Why not implement MDX-query?

Posted by: superbluesman on 3 August 2017, 3:55 pm EST

  • Posted 3 August 2017, 3:55 pm EST

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

    Hello, <br><br>Thank you for your suggestions. I have added your request in Case 147701. I have also added your email address to list of customers requesting this feature. You will be notified if this feature is implemented.<br><br>Regards,<br>Aashish
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels