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 !



    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



    _MdxDataSource.Connect()

    _pivotView.DataSource = _MdxDataSource



  • Replied 3 August 2017, 3:55 pm EST

    Hello,

    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.

    Regards,
    Aashish
Need extra support?

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

Learn More

Forum Channels