.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

Analysis Services Plugin using DMPluginWrapper with C#

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
 
I'm developing a desicion tree algorithm (CHAID) to be integrated as a plugin in SQL Server 2008 Analysis Services. It is almost done. The only thing that's missing in my implementation is the capability of testing the algorithm accuracy using any of the Mining Accuracy Chart. When I try to use these features, in my Visual Studio Business Intelligence Project, I get this error message: Query execution Failed Internal error: An unexpected exception occurred. COM error: COM error: DMPluginWrapper; Object reference not set to an instance of an object.. (Microsoft OLE DB Provider for Analysis Services 2008.) I think I'm not properly overriding a method or something like that. Since I have no documentation and no examples available, I'm not being able of detect where is the problem. Maybe some of you have experience developing plugin algorithms for SQL Server and have a clue of what I'm missing.   I know It's hard to help without seeing any piece of the source, but there're a bunch of files in the project. I've been reading and reading my source and I still don't know where the actual problem is.


View Complete Post


More Related Resource Links

SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

  

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004


OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

  

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003


Restore - Cube Analysis Services 2005

  
Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

  
Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

SQL Analysis Services 2008

  
Can any one help me for... How to create a new instance of SQL Analysis Services? I am  using SQL Server 2008. Thanks, Faheem Ahamed

modelling SCD2 hierarchy changes in analysis services 2005

  
its seems to me its really not possible to implement SCD2 changing hierarchy in analysis services such the hierarchy is properly displayed in excel. for instance if scd2 changes happen on leaf level then excel correctly shows the data but if they happen on branch level analysis services picks up one parent eg at time 1 hierarchy looks like this A->B at time 2 hierarchy is A->C when hierarchy is displayed in excel 2007 it shows      time       1       2 C    100   200   A  100    200   but this not a correct display of hierarchy changing over time the correct display is this      time       1       2 B    100   A  100 C            200   A          200      

Today() Function including timezone causing issues in Analysis Services

  
I'm using Reporting Services 2008 R2 connecting to Analysis Services. I've used this same code without issues before (pre R2), just wondering whether it is an RS, AS, Server or some other issue entirely. I have a report with a datetime parameter @vdtmDate (I use this so the user has the date picker instead of a drop down list of dates) with default =DateAdd(DateInterval.Day, -1, Today()) Then in the MDX for the dataset, I use the following to build the filter. SET [Today] as STRTOSET('[Calendar].[Reporting Week].[Day].&[' + VBA.FORMAT(VBA.CDATE(@vdtmDate),'yyyyMMdd') + ']') The issue I'm having is when the report runs with the default parameters, the value passed to Analysis Services includes the timezone which causes the query to process for the previous day to that selected. When the user runs the report manually (ie just pressing the view report button straight after the initial report load) the date passes without the timezone and returns the correct information. Example, running the report today (3rd September), the default parameter passes the value (info from profiler)         <Parameter>           <Name>vdtmDate</Name>           <Value xsi:type="xsd:dateTime">2010-09-02T00:00:00+

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Analysis Services - Query returns a #error result

  
Hi, I have a cube - which i had backed up and just retored it. After the restoration, when i try to reply the cube e.g: select [Time].&[200503] on 0 , {[Process].[All process]} on 1 from [myConsolidations] - i recieve an a result showing #error only. What could be the cause of this?

stuck in "Analysis Services Tutorial" Lession1 "????????" step 3.

  
Hi, I am stucking in the lession1 The error message ??: Microsoft OLE DB Provider for SQL Server ------------------------------ [DBNETLIB][ConnectionOpen (Connect()).]SQL Server ????????? ------------------------------ ??: ??(&R) ?? ------------------------------ Could someone help me to teach me how to solve this problem. Then I can keeping my learnibng. Thank you very much.

SP2010 + Reporting 2008 R2 + Analysis Services 2008 R2

  
I want to create a solution based on sp2010 in which the users can create their own reports with Report Builder and have an Analysis Services cube as the data source I did is the following : i have activated the Site collection features for reporting, i have created a data source which is the cube, i've created the model and also added the reporting document types to a document library and now i am ready to create reports The problems comes when i want to create this from a location outside the server. It doesn't work and gives me the following error : Semantic query execution failed.  (rsSemanticQueryEngineError) ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted) The location from where i want to access is a computer from another domain but i log in with a SP2010 user and also pertaining to the SP2010 domain. This user has Member Site rights for the Report Model, dataset, report. DataSet1 is the default name assigned by the Report Builder. The issues appears if I define the dataset before the report or during the report creation with the Report Builder. The authentication for the data source is windows authentication, the permissions for the model are inherited from the site, and the dataset credentials are set to Use

Analysis Services Using Oracle as a Data Source Data Types mismatch System.Int32 and System.Int64

  
Hi everyone, I searched for this issue but there is only 4 questions about it in this forum from 2007 I hope that someone can help me. Im usign SASS 2008 using a Oracle as a datasource.  I already have my fact tables linked with dimensions, lets say, FACTID System.Int64 with DIMENSIONID System.Int64 (My dimensions are replaced by named querys and work perfectly) I add a new table to my DSV and the NEWDIMENSIONID looks like System.Int64, but at the moment I replace the table with a named query (I have to use Oracle quering) the NEWDIMENSIONID changes to System.Int32 .  After that I cant relate the fact table with the dimension table. Actions: Looked for the columns that relate from Oracle... both are NUMBER(5). Looked for the differences between my other tables that are already related as System.Int64 and there is not a single difference between the ones that works and the one who doesnt. Solutions Ive tried and didnt work: 1. Cast the column as SQL query didnt work it send an error.  Looks kind of obvious because we are quering Oracle... but I had to try.  CAST( X AS BIGINT) 2. Cast the column as Oracle query . TO_NUMBER 3. Do it inside the server using the Analysis Services Enterprise insted of my Analysis Services Developer. Same issue.   Any ideas? suggestions?   Please? Thank you very much ;) Sincerly Adriana L. PS. At the begging of

SQL Server Analysis Services Filter web part.

  
Hi all In a NTLM farm with 1 SharePoint and 1 SQL server, I am using clamis based authentication for Excel Services app in SharePoint Server 2010. While all Excel documents work, I get error on "SQL Server Analysis Services Filter" web part. The filter works when I am logged on the sharepoint server and open the Intranet to use it, but doesn't work if I reach the Intranet by not logging on the SharePoint server. The error I get is on the filter web part: "An error occured while retrieving filter values (The connection either timed out or was lost). Anyone else that have had the same problem? Any ideas to troubleshoot? :) Regards

How do I use Integration Services to achieve Push-mode processing for Analysis Services?

  
 [This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.] Question: I have some data sources which are plain text files and I want to directly load the data from these sources to my SSAS cubes. How can I do that? Answer: Usually when you process a cube, the SSAS service will send SQL queries to the underlying data source so as to load data into the cube. This is a typical pull-mode processing. But in some cases, the data sources are non-regular databases or plain text files, which will cause difficulties to use pull-mode processing since you could not use any type of SQL. In this case, you may want to use a push-mode processing. Microsoft SSIS provides this function. It can fetch data from underlying data sources and pushes the data into SSAS cubes directly. For example, the internet order quantity of the calendar year 2001 is: 1031. But for some reason, you need to add a new record from txt file to the cube: ProductKey    OrderDateKey    DueDateKey    ShipDateKey    CustomerKey    PromotionKey    CurrencyKey    SalesTerritoryKey    SalesOrderNumber    SalesOrderLineNum

Analysis Services 2008 R2 Deployment - very frequent database overwrites

  
When regularly deploying an Analysis Services project from Visual Studio / BIDS to Analysis Services 2008 R2, the database must frequently be overwritten - on almost any change. For example, after a successful deploy and process, a seemingly minor change is made (e.g. changing the FormatString property for an existing Measure, or Arrange Tables in the Data Source View), and the next deploy and process attempt triggers the message: The 'ZZZ' database on 'ZZZ' has changed since the last time the project was deployed. If you proceed with deployment, the database will be overwritten. Would you like to continue? With earlier versions of SQL, this only occurred rarely, e.g. when deploying to a stale server. The impact is that testing almost any change requires a complete re-process of the database. Is anyone else striking this issue?  Thanks Mike

How Do I Set Server Administration Privileges on Analysis Services Instance (Microsoft SQL Server 20

  
Hello. I need to do Association Analysis on a company KPI to determine its key influencers - among other things. This is my first attempt ever and I have installed the Microsoft SQL Server 2005 Add-Ins for Office 2007. I also have SQL Server 2005 installed on my laptop. I chose the "Use an existing instance of Microsoft SQL Server 2005 Analysis Services that I administer" and launched the Server Configuration Utility. I am advised that I will need server administrator provileges on the Analysis Services instance that I am about to configure. The defaulted server name is localhost. Indeed I get an error message when I try to advance: "Unable to discover metadata on the server 'localhost'. User 'Maigida-PC\Maigida' needs to be administrator of the server to run the configuration tool" Help me please: How Do I Set Server Administration Privileges on Analysis Services Instance to myself on a local server on my laptop? I need to master DM in Excel 2007. Deep regards.  
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend