AFAIK, Integration Services is the Microsoft's ETL product, but can other tools integrate to Analysis Services for using it as the data warehouse (I mean, for storing cubes, dimensions and measures).
View Complete Post
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.
MSDN Magazine September 2004
We have SQL Server succesfully set up for FIPS Compliance, But require to setup the same Compliance for the Encryption of Data in Analysis services 2008 enterprise on the same Win 2008 server.
If we browse to the SAS Data Folder for our Project on the Fips Compliant Instance We can view the Data Files and the Data is Visible in Plain Text. Depite the security setting being set to DataProtectMode 1 (Encryption).
So my Questions:
1. Is Analysis Services 2008 enterprise Fips Compliant ?
2. if it is How do we set it up
3. how do we prove to security Auditors that it is Set up and Working in Compliant Mode.
We have done Exaustive Searches of msdn Google blogs, sql-cat etc and found no relevent articles to Answer these specific Questions and are reluctant to Go to Chargeable support until we have exausted other available avenues.
When I tried to see this service
I got this error What should I do?
Does any one has an idea why it fails while writing data in to partition.
I have only one partition which is default. I am using Molap.
The data is unable to cache from relational db to the cube partition.
The rrror from the profiler:
Started building processing schedule.Finished building processing schedule.Processing of the 'XYZ_20081102' cube has started..Starting to write data of the 'XYZ_INCR_UPDATE_TEMP_2d232_' partition.The job completed with failure.
Internal error: The operation terminated unsuccessfully. Internal error: The operation terminated unsuccessfully. Internal error: An unexpected exception occurred. Errors in the OLAP storage engine: An error occurred while processing the 'XYZ_INCR_UPDATE_TEMP_2d232_' partition of the 'XYZ' measure group for the 'XYZ' cube from the XYZ database. Server: The operation has been cancelled.
The analysis service terminates after 4-5 retries caching the data.
I could also observer Proactive caching is not properly working in sql serer 2008 when using polling.
Any thoughs or advice is appreciated
I have used the above method to configure my crystal report ...
Its working fine , But i have huge number of data in database ....
So , it take long time to load the report ...
So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.
Plz help me with this issue ...
Also , Plz explain me abt index legend in crystal report.
Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.
MSDN Magazine August 2010
LINQ's ability to project randomly shaped data into anonymous types can be a blessing and a source of frustration, says Julie Lerman. It's great when you just need to grab a special view of your data, but it can be problematic in certain circumstances. She explains what the limitations are and how to get around them.
MSDN Magazine May 2010
Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.
MSDN Magazine April 2010
MSDN Magazine March 2010
Many early adopters cloud platforms have questions about security. We review some of the cryptography services and providers in Windows Azure along with some security implications for applications in the cloud.
MSDN Magazine January 2010
This article shows you the new face of SQL Data Services, explores its architecture, and shows how it is truly an extension of SQL Server in the cloud.
MSDN Magazine August 2009
If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.
MSDN Magazine July 2009
.NET RIA Services provides a set of server components and ASP.NET extensions such as authentication, roles, and profile management. We'll show you how they work.
MSDN Magazine May 2009
In this article the author looks at two versions of the same application--one consuming an on-premise Data Service, and one consuming an Azure Table Data Service to illustrate data access in the cloud.
ADO.NET Data Services and Silverlight make a powerful combination, but to make them work well together, there are a few things you need to understand. Here, John Papa explains.
MSDN Magazine April 2009
This month we take a look at FxCop and other tools that enforce your design rules, along with jQuery.
MSDN Magazine December 2008