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? ...
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 ...
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 ...
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...
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 ...
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...
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...
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 ...
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 ...
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 ...