TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Get this Tag RSS feed
Translate this page
Powered by
Microsoft® Translator
Popular Tags
Active Directory
AD
AD DS
adfs
ASP.NET
azure
BizTalk
BizTalk Server
BizTalk Server 2010
C#
Candidate for deletion
certification
cloud
core docs
de-DE
EAA
Ed Price
Ed's Stub Pages
en-US
ESA
es-ES
Excel
Exchange
Exchange 2010
fa-IR
Fernando Lugao Veltem
FIM
FIM 2010
FIM Resources
FIM-HELP
forefront
forums
fr-FR
Gokan Ozcifci
has code
has comment
has comments
has image
has Images
has Other Languages
has See Also
Has Table
Has TOC
Horizon_Net
How To
Hyper-V
id-ID
IIS
Italian Wiki Articles
it-IT
ja-JP
Jordano Mazzoni
Link Collection
Luciano Lima
Luigi Bruno
Lync Server 2010
MIISILMFIM MACAULAY
Multi Language Wiki Articles
needs work
operations manager
Pirated Content
Portal
Português Brasil
PowerShell
pt-BR
security
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint Pirate
Small Basic
solucionando problemas
SQL Server
SQL Server 2012
stub
System Center
System Center 2012
TechNet Guru
TechNet Wiki
TechNet Wiki Featured Article
tonyso
Translated into Japanese
troubleshooting
tr-TR
vídeo
Video
Virtualization
VMM
Wiki
Windows
Windows 7
Windows 8
Windows Azure
Windows Server
Windows Server 2003
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
yottun8
اکتیو دایرکتوری
Browse by Tags
>
TechNet Articles
>
All Tags
>
SQL Server Analysis Services
Tagged Content List
Wiki Page:
SSAS Error: Error loading Metadata: No cubes were found
Ed Price - MSFT
Applies to: SQL Server Analysis Services (all supported versions) This error can occur if you deliberately or accidentally set a cube's Visible property to False . When developing a cube, you might have occasion to hide a dimension. If the dimension is not selected, you can inadvertently hide...
on
16 Sep 2013
Wiki Page:
The Nine DataMining Algorithms in SSAS
Maheshkumar S Tiwari
SQL Server Analysis services includes nine algorithms. In addition, SSIS includes two text mining transformations. the list below summarize the nine SSAS algorithms and their commun usage. Decision Trees: is the most popular DM algorithm, it is used to predict discrete and continuous variables...
on
3 Sep 2013
Wiki Page:
Event ID 0: SQL Server Analysis Services: "The service cannot be started: <servicename>"
Balaji M Kundalam
Table of Contents Event Details M Maximum entries in the event log prevent service startup Installation error prevents service from starting Other reasons why the service fails to start Resources The service cannot be started: 'MSSQLOlapService'. Event Details Applies...
on
31 Aug 2013
Wiki Page:
Connecting to SSAS Cube using Silverlight
Naomi N
Some time back when I was watching a presentation of a third party reporting product, I saw some nice animated charts. I wanted to create something similar to those charts and when I checked on SSRS, unfortunately what I wanted isn't possible with SSRS. So I moved into Silverlight Charts and I...
on
30 Aug 2013
Wiki Page:
Data Source View
Richard Mueller
Overview In SQL Server Analysis Services (SSAS), a data source view is a diagram of one or more relational data sources for the SSAS database. Developers use components from the data source view to construct the SSAS database's objects (e.g. dimensions and measure groups ). SSAS uses the data...
on
30 Jul 2013
Wiki Page:
Unified Dimensional Model
Richard Mueller
Table of Contents Definition Components Community Resources See Also Other Languages Brazilian Portuguese (pt-BR) German (de-DE) Definition The Unified Dimensional Model (UDM) is the model for data in a SQL Server Analysis Services (SSAS) database. The UDM is unified because it combines data...
on
30 Jul 2013
Wiki Page:
SQL Server Analysis Services (SSAS) Troubleshooting Articles
Ed Price - MSFT
The following links go to key troubleshooting articles in the MSDN Library, support articles, and to videos. All these links are for SQL Server Analysis Services (SSAS). Analysis Services Stops Accepting New Connections –Processing commit locks hurt Error from AS client tools - "Property...
on
2 Jul 2013
Wiki Page:
How to Solve the SSAS Cube Browser Error by Using Drag and Drop
Ed Price - MSFT
How to solve SSAS cube browser error and doing some drag and drop. Summary: This is in an example of correcting the error in a Cube in SSAS. Problem: In our situation there was a problem when we browser a cube and drag any field it show some error. The query could not be processed: 0 XML for...
on
2 Jul 2013
Wiki Page:
Role (OLAP)
Ed Price - MSFT
SQL Server Analysis Services enforces OLAP security through roles. A user can access OLAP data if the user's name has been added to a role with access to OLAP data. If the user's name has not been added to a role, the user will not have access to OLAP data, regardless of any configurations...
on
29 May 2013
Wiki Page:
How to Process and Deploy an SSAS Cube
Peter Geelen - MSFT
Summary This is in an example of deploying and processing a Cube in SSAS. Problem In our situation there was a problem when we deploying and processing a cube it show some error. Errors and Warnings from Response Internal error: The operation terminated unsuccessfully. OLE DB...
on
14 May 2013
Wiki Page:
SSAS Design Patterns
Aalam Rangi
Table of Contents Books Articles / Blog Posts Cube Build/Design Patterns Other Articles Case Studies This is a stub page for SQL Server Analysis Services (SSAS) design patterns. Having a collection of design patterns in one wiki will cut down on estimation, development and maintenance of SSAS projects...
on
14 Apr 2013
Wiki Page:
KPI
Richard Mueller
Overview In SQL Server Analysis Services (SSAS) , a key performance indicator (KPI) is a metric that a business uses to measure its success and progress. The metric is compared against a goal to determine its position relative to that goal and its velocity (trend). For example, a business might...
on
7 Feb 2013
Wiki Page:
SSAS: Explaining the State Transitions Viewer for Sequence Clustering
Ed Price - MSFT
Original article (before edits) by Allan Mitchell , SQL Server MVP and principal consultant at Konesans Limited in the UK. You can find Allan’s website at www.SQLIS.com . NOTE : Alternatively, you can download a Word file of this whitepaper at TechNet Gallery . This is for several potential...
on
25 Nov 2012
Wiki Page:
SSAS: Explaining the GetClusterCharacteristics Stored Procedure for Sequence Clustering Models
Ed Price - MSFT
Original content by Allan Mitchell , SQL Server MVP and principal consultant at Konesans Limited in the UK. You can find Allan’s website at www.SQLIS.com . NOTE : Alternatively, you can download a Word file of this whitepaper at TechNet Gallery . This is for several potential reasons: (1...
on
25 Nov 2012
Wiki Page:
Unified Dimensional Model (de-DE)
Horizon_Net
Table of Contents Definition Komponenten Quellen Siehe auch Andere Sprachen English Português Definition Das Unified Dimensional Model (UDM) ist ein Datenmodell in SQL Server Analysis Services (SSAS) Datenbanken. UDM vereint dabei Daten von verschiedenen relationalen Datenbanken in einen...
on
30 Mar 2012
Wiki Page:
Data Source View (de-DE)
Horizon_Net
Überblick In SQL Server Analysis Services (SSAS) ein Data Source View ist eine Sammlung von einer oder mehren relationalen Datenbanken für die SSAS Datenbank. Entwickler nutzen Komponenten vom Data Source View um SSAS Datenbank-Objekte (z.B. Dimensionen und Measure Groups) zu erstellen...
on
30 Mar 2012
Wiki Page:
Role (OLAP) (pt-BR)
Fernando Lugão Veltem
Esse artigo foi originalmente escrito em: http://social.technet.microsoft.com/wiki/contents/articles/8790.role-olap.aspx SQL Server Analysis Services impõe segurança OLAP através de funções ou roles. Um usuário pode acessar dados OLAP, se o nome do usuário...
on
29 Mar 2012
Wiki Page:
SSAS
Ed Price - MSFT
SSAS is an acronym for SQL Server Analysis Services .
on
24 Jan 2012
Wiki Page:
PowerPivot and Azure on Cloud
MCSD_MVP
NOTE : This article needs more work. Please add information as you can. In today's world every one needs business intelligence to analyze data - sometime you do not now know -where your data is, it may be residing somewhere in legacy system or in ERP or in any management system, so if you want...
on
29 Nov 2011
Page 1 of 1 (19 items)
Can't find it? Write it!
Post an Article