|
|
Browse by Tags
All Tags » Analysis Services
-
A little while back I spent an afternoon prototyping some functionality for Analysis Services. I’ve been working a bit on improving the collaborative development story around SSAS, and I was after Building a SQL Server Analysis Services .ASDatabase file from a Visual Studio SSAS Project. I did come up with some nifty functionality in the ...
-
There are several methods available for deploying Analysis Services databases once you’ve build your solution, including direct connections, generating XMLA to deploy, and using the Deployment Wizard with answer files. Still, building and deploying AS Databases can sometimes be a challenge in enterprise development scenarios. One ...
-
I recently started using SSAS Server Traces a lot with SQL Server Analysis Services. This type of trace is basically the same trace you can create with SQL Server Profiler, but it runs without Profiler, uses less resources, and can be persisted across reboots. They’re a really handy tool.
I started using these when I built some AS ...
-
A topic that often comes up when discussing enterprise level development with SSAS is how to have multiple developers work on the same project at the same time. This issue doesn’t come up for many installations… a lot of teams get away with just having a single person working on their OLAP capabilities. However, for a decent sized ...
-
I was processing a SSAS database to test some aggregations today, and I noticed some errors and came across some unexpected behavior.
When I was processing the User dimension (among others), I got an error similar to the following:
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_DimUser', ...
-
I've spent the past 15 months, off and on, working as the technical lead on a performance management project using PerformancePoint Server. The project was to create a SharePoint Portal where users could view the performance of a school system. The portal was initially internally facing, but the goal was to make it ...
|
|
|