ADOMD Empty Grid

[Dan]

I'm testing out the pivot grid control and adapted the sample to use adomd.

The problem is when I run it, I get no fields in the picker. Everything is empty. No errors, no extended errors in VS when debugging.

I can verify my connection string is working because I can create an AdomdConnection using Microsoft's API and successfully connect to the SSAS server and see the connection metadata/properties while it's open when debugging with VS.

SASS is 10.50.1600.1,
Microsoft.AnalysisServices.AdomdClinet is v 10.0
WPF 4.0

Not sure why I'm not getting anything using the telerik control.

[Rosen Vladimirov]

Hi Dan,

I assume you have followed our example here. Can you confirm that the issue exist with our latest internal build? Also you can check if there are any errors by using this code:
- In code behind:

var adomdDataProvider = this.Resources["ADOMDDataProvider"] as AdomdDataProvider;
adomdDataProvider.StatusChanged += adomdDataProvider_StatusChanged;
adomdDataProvider.FieldDescriptionsProvider.GetDescriptionsDataAsyncCompleted += FieldDescriptionsProvider_GetDescriptionsDataAsyncCompleted;

....
void FieldDescriptionsProvider_GetDescriptionsDataAsyncCompleted(object sender, Telerik.Pivot.Core.Fields.GetDescriptionsDataCompletedEventArgs e)
{
    if (e.Error != null)
    {
        MessageBox.Show("State = " + e.State + "\n\nError = " + e.Error.Message + "\n\nInner Error:" + e.Error.InnerException + "\n\nStackTrace = "+ e.Error.StackTrace + "\n\nSOURCE=" + e.Error.Source + "\n\nInnerInner=" + e.Error.InnerException.InnerException);
    }
}

void adomdDataProvider_StatusChanged(object sender, Telerik.Pivot.Core.DataProviderStatusChangedEventArgs e)
{
    if (e.Error != null)
    {
        MessageBox.Show("Status = " + e.NewStatus + "\n\nError = " + e.Error.Message + "\n\nInner Error:" + e.Error.InnerException + "\n\nStackTrace = "+ e.Error.StackTrace + "\n\nSOURCE=" + e.Error.Source + "\n\nInnerInner=" + e.Error.InnerException.InnerException);
    }
}

Please note that the resource "ADOMDDataProvider" is your actual DataProvider defined in XAML. If you find any errors with this code, please send them to us. Also can you send us a short snippet how are you defining your AdomdDataProvider, just to ensure that everything is correct from our side.

Looking forward to hearing from you.

All the best,
Rosen Vladimirov
the Telerik team

[Dan]

Same thing, no errors when adding these checks..

Is it because I have no row, column or aggregate descriptors specified in xaml or code? I was under the assumption that the fields available in a cube would be automatically discovered, similarly to how properties on items in a collection are on a LocalDataSourceProvider.

[Rosen Vladimirov]

Hi Dan,

If you do not specify any Group Descriptions, RadPivotGrid will not be populated with data. That's why you need RadPivotFieldList as well - this is the only way to modify RadPivotGrid at runtime. More information about RadPivotFieldList is available in our online help.
I'm also attaching a simple project to illustrate the use of AdomdDataProvider with RadPivotGrid and RadPivotFieldList. Please check it and inform me if you have any problems or concerns. You can set your own connection string and try if it works.

Thanks for evaluating RadPivotGrid. Feel free to contact us if you have any suggestions or concerns.

Regards,
Rosen Vladimirov
the Telerik team

[Dan]

Sorry, I referred to it as the picker, but yes, from the initial example, I had RadFieldList bound to the grid's data provider when I got the empty field list.

I went back and removed database from AdomdConnectionSettings and accessed a cube on the default DB and that worked. Tried specifying Database again and got empty.. tried via the ADOMD.NET libraries directly as well as another vendor control and was able to successfully connect to a cube on another database / catalog.

It looks like there might be a bug in either the RadFieldList control or the AdomdConnectionSettings class.

[Rosen Vladimirov]

Hello Dan,

Are you sure you have set your connection string correct? You have to set Database parameter of your AdomdConnectionSettings and also assign value to the Catalog property inside the ConnectionString property:

<pivot:AdomdDataProvider x:Key="ADOMDDataProvider">
    <pivot:AdomdDataProvider.ConnectionSettings>
        <pivot:AdomdConnectionSettings
                    Cube="Adventure Works"
                    Database="Adventure Works DW 2008R2"
                    ConnectionString = "Data Source=http://demos.telerik.com/olap/msmdpump.dll;Catalog=Adventure Works DW 2008R2" >
        </pivot:AdomdConnectionSettings>
    </pivot:AdomdDataProvider.ConnectionSettings>
</pivot:AdomdDataProvider>

Could you verify that you have changed both properties? If this doesn't work, could you send us your AdomdConnectionSettings so we could check them from our side (only as a structure - we will not try to connect to your DB).

Looking forward to hearing from you.

Regards,
Rosen Vladimirov
the Telerik team

[Dan]

I thought the web notation was used specifically in conjunction with XMLA, not ADOMD.. anyway, to avoid the overhead of an IIS server, I'm using native connectivity with ADOMD and as such, an OLEDB style connection string like so: Provider=MSOLAP.4;Data Source=<HOST>;Integrated Security=SSPI;Persist Security Info=False;Timeout=300;

I assumed neither Catalog=; nor Cube=; were required since you have separate properties for those and you inject them into the string.

I finally got it to work by specifying the catalog and cube in the connection string AND properties (catalog as database), it doesn't work with just properties or just connection string...

In my opinion this is a bug. A full connection string should work without those properties. Ideally, setting database and cube in the properties should have them injected into the string if it is detected that the string does not have them specified (for easy runtime swapping of data sources).

[Rosen Vladimirov]

Hi Dan,

Please accept our apology for this issue. We are aware of it and we'll provide easier way to setup AdomdConnectionSettings in the future. Thanks for sharing your opinion with us, we are really happy when our customers share how we can improve our products.

Do not hesitate to contact us if you have any other suggestions or concerns.

Greetings,
Rosen Vladimirov
the Telerik team