[Solved] SSAS 2012 and PivotGrid OLAP connection trouble

[Erik]

I am having trouble getting the Q3 2013 PivotGrid (most recent release) to display data from the Pivot Grid control.

My pivot grid definition (I have no code-behind related to it) is below, along with some code I have in the PageLoad function of the page.  The code from the PageLoad function works fine, but I can't seem to get anything to display in the PivotGrid.  According to the SQL 2012 docs, we don't need to use msmdpump.dll anymore for remote access.  Is that part of my problem? 



I have the Microsoft.AnalysisServices.AdomdClient (v11) referenced and in the bin folder of the web site.



Pivot Grid code:

<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server">
        <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox"/>

        <OlapSettings ProviderType="Adomd">
            <AdomdConnectionSettings
                Cube="UtilitySmart"
                Database="UtilitySmart"
                ConnectionString="Data Source=SERVERNAME; Catalog=UtilitySmart;">
            </AdomdConnectionSettings>

        </OlapSettings>

        <Fields>
            <telerik:PivotGridRowField DataField="[Dim Utility Smart Property].[Portfolio]" Caption="Portfolio" UniqueName="Portfolio"/>
            <telerik:PivotGridAggregateField DataField="[Measures].[AmtPaid]" Caption="Amount Paid" UniqueName="AmtPaid"/>
        </Fields>

        <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" LayoutType="OneByFour"/>
    </telerik:RadPivotGrid>

PageLoad code:

var conn = new AdomdConnection("Data Source=SERVERNAME;Catalog=UtilitySmart;");
               conn.Open();

               var cmd = new AdomdCommand("SELECT [Dim Utility Smart Property].[Portfolio].Members ON ROWS, [Measures].[Amt Paid] ON COLUMNS FROM [UtilitySmart] ", conn);

               var resultObj = cmd.Execute();

[Tsvetoslav]

Hello Erik,

RadPivotGrid supports only version10 of the MS Adomd provider. More information on that and the format of the connection string can be found here:
http://www.telerik.com/help/wpf/radpivotgrid-data-adomd.html (the help topic concerns the wpf counterpart of RadPivotGrid but the data-engine is the same as the one used by the ajax one)

Hope it helps.
 
Regards,
Tsvetoslav
Telerik

[Erik]

Thanks Tsvetoslav.  That helps.

Do you have any insight when v11 will be supported?  Also -- how about Tabular structures in SSAS?  Is that something that is also coming?

[Antonio Stoilkov]

Hi Erik,

Unfortunately, currently there are no plans for supporting version 11 of the MS ADOMD provider. Additionally, could you provide more information on what type of Tabular SSAS structure are you using? For example you could take a look at the demo below which shows the TabularMode. Note that the demo is from the Telerik Silverlight controls but we are both using the same pivot engine.

• http://demos.telerik.com/silverlight/#PivotGrid/TabularMode

Regards,
Antonio Stoilkov
Telerik