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


Post New Web Links

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

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
 
 [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


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


COM+ Integration: How .NET Enterprise Services Can Help You Build Distributed Applications

  

The .NET Common Language Runtime (CLR) is Microsoft's next-generation component technology. The CLR is a replacement for COM, but not for COM+. COM+, now called .NET Enterprise Services, is the Microsoft object runtime environment for scalable system development. This article explains how to implement and deploy COM+ configured classes using the CLR, how to access object context and call context, and the rules for managing context-relative object references. Also discussed are ways to manage precious resources such as data connections and pooled objects, and the relationship between COM+ and the new .NET remoting architecture.

Tim Ewald

MSDN Magazine October 2001


Reporting Services in SharePoint integration - configurtion errors in 64bit version

  

Hi,

We have build an MOSS 2007 environment on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. Initially configuration looks fine with reporting services integration with green indicators.

 

After creating a web application and accessing the web site from the report servor, i have found the following errors:

 

Server Error in '/' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi

HTTP 401: Unauthorized when trying to specify reporting services for integration, cannot connect to

  

Greetings.

 

I am trying to install reporting services and join it into existing service farm.

Main  MOSS 2007 is on one pc, with config bases etc, while reporting services, reporting services db will be on other pc. 

We are using same domain account to run sharepoint services and reporting services. 

I've installed web part of MOSS on that other computer, also reporting services and sql server, set reporting services in integration mode.

Either way, it wont work for me:

1)

If i am running the service of reporting services as Network Service account, then the /reportserver page will complain about some generic error "probably you dont have access to the farm if you are in integrated mode" etc.... 

I've read that i should include networkservice into a group WSS_WPG which i did, no luck anyway, same error

If i try to type the adress into the integration with reporting services in moss admin page, i will get error like "expected xml received html" and alot of red text.

2) 

If i switch service to run from domain account (the one that is used for running sharepoint on the domain) (we did the spn thing, didnt work either), the /reportserver page will open

(moss2k7/ReportServer - /

Issues with SSIS and SQL 2008 - Integration services not running

  
Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

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.

Reporting Services and Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

  
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone: System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. Is this a limitation of the SQLRS-WSS3 integration or is there a workaround? Many thanks to anyone who can help!

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!

Analysis Services Plugin using DMPluginWrapper with C#

  
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.

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      

Sql server Report services integration with moss 2007 giving hard time.

  
Hey guys, I have 2 servers  in seperate domain one for database and other for moss 2007. SERVER 1 :     AD,DNS,SMTP,SQL SERVER 2005 sp3 .... SERVER 2:    MOSS 2007 APPLICATION SERVER with sp2 and october cumilative updates applied. i have even installed NDP20-KB913384-X86.exe hot fix for .net framework 2.0 access voilation error. In CA my server 2 version is 12.0.0.6520 When i installed sql server 2005 on server 1 during installtion for report server i choosed install but do not configure. Now I decided to integrate the sql server report services into sharepoint and did some research and found some articles on msdn which says in order to integrate the report services into sharepoint i need to have a minimal install of moss 2007 on server hosting report services (correct me if i am wrong). since i have only 2 servers i decided to install the minimal installation of moss 2007 on my server 1 ( Web front end only ). Here are the steps i followed for it Installed .NET framework 3.0 Installed moss 2007 sp2 Installed october cumuilative update for wss then same for moss 2007. Installed .net framework 2.0 NDP20-KB913384-X86.exe hot fix. and then ran the psconfig from command line as psconfig -cmd configdb -connect -server <SQLServerName> -database SharePoint_Config_ <dbname> -user <domainusername> -password <passw

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

Integration Services Will Not Run

  
Win 2008 Enterprise sp2 64 bit. SQL 2008 Std 64 bit. I cannot get a BI project to load or build new. First I had Visual Studio 2008 Team System Database. Would not load. Then I installed SQL 2008 sp1. (currently 10.0.2531.0 SP1) No change. Uninstalled VS, rebooted & installed VS 2008 Profesional. No change. Error is: Could not load file or assembly 'Microsoft.DataTransformationServices.Wizard' or one of its dependencies. The system cannot find the file specified. Just to make the day extra-special, I find out my new box with VS2010 does not even support SSIS/BI anymore. Looks like back to Windows XP again!!@#$!

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