adomd.net

ADOMD.NET 9.0 Redistributable?

Got a problem with ADOMD.NET 8.0, SQL2008 and our app. It isn't giving us the right metadata. I can't find anywhere to download the ADOMD.NET 9.0 redistributable. Only way I can get it is by installing 2008 and grabbing the DLL. Any clues? ...

Has anyone used ADOMD.NET with WPF DataGrid?

I am trying to find a good way of accessing a Business Intelligence OLAP Cube from C#. I don't really care much as to how this is done, but since currently I am trying to implement this with the codeplex WPF Toolkit, I would be happy if it was something directly related to the tool, but any suggestions are very welcomed. My WPF skills ...

Writing updates to OLAP cube

Hi, What is the easiest way to write user entered measure values (sales forcast) to the SQL Server Analysis Services OLAP cube from a .Net client application? I'm aware that underlying fact table can be updated with DML statements and that cube can be reprocessed but I'm looking for alternatives. Regards, Aleksandar ...

Connecting to SQL Server Analysis with a windows user

How can you impersonate a windows user in a connection to an analysis server - using ADOMD.NET? Webserver is next to Analysis server, but they are not in a domain. The webservice running on the webserver needs to access the analysis server as a specific windows account. Is there something I can put in the connection string, or do I ne...

How to access KPI Value hidden measures via ADOMD.NET?

I'm trying to access the KPI metadata via ADOMD.NET (using MDSCHEMA rowsets) with SQL Server/SSAS 2008. When I get a given KPI VALUE field, for example in Adventure Works, it returns what I believe is the hidden measure associated with the KPI (e.g., [Measures].[Net Income Value]). But the Value has areal MDX expression associated with ...

Create ADOMD objects without a datasource

In ADO I can create a DataSet without actually querying a database : I can instantiate a DataSet and fillit with my own data. I would like to be able to do the same with a multidimensional object, so that anything that can query an OLAP cube (eg Excel) can consume the data my application produces, without having to populate a database. H...

MDX query containing 2 dimensions from the same Hierarchy

The relevant structures from my cube are that I have a Hierarchy with "Class" and "SubClass". I also have a Measure called "Value" which is what im trying to obtain. A simple query may look like: SELECT NON EMPTY ([Measures].[Value]) ON COLUMNS, NON EMPTY ([Some Dimension].[Class Hierarchy].[Class]) ON ROWS FROM [MyCube] And I can...

How to create a custom ADO Multi Dimensional Catalog with no database

Does anyone know of an example of how to dynamically define and build ADO MD (ActiveX Data Objects Multidimensional) catalogs and cube definitions with a set of data other than a database? Background: we have a huge amount of data in our application that we export to a database and then query using the usual SQL joins, groups, sums etc ...

ADOMD & Excel Integration

All, We have an Excel spreadsheet that uses ADOMD to query OLAP cubes and present the data in Excel. We are using version 2.8 at the moment of the ADOMD API. As far as I know there is an ADOMD.NET API for querying OLAP cubes. Can this new .NET version used from inside Excel ? Many Thanks, MK ...

How to use ADOMD.Net types with WCF RIA Services

Is there any solution to pass the different ADMOMD.Net types (Cubes, Dimensions , KPIs ...) over a RIA Service or even over a WCF Data Services? Thanks ...