Clever Geek Handbook

DMX example in VB.NET

I have an MDX snippet that I would like to add to an ASP.NET form. Hopefully, we'll just bind the results to the gridview. Are there any good links or snippets? I am using VB.NET, but I can port from C # if no Visual Basic code is available.

0


source to share


1 answer


There is a way to execute MDX with SQL which I suppose will give you a hidden way to bind the results to the gridview!

select top 100 * from openrowset(
    'MSOLAP',
    'Datasource=MyDBServerName;Initial catalog=MyCubeName',
    'SELECT {dimensions(0).members} on rows, 
    {time.defaultmember} on columns 
    from sales'
)


There is a correct way (usually called ADOMD in classic ASP, which gave you a Cellset object that you could work around).

Many people use a third party .NET component like Dundas to display tables and graphs from cube data.

0


source






More articles:


All Articles