<a href="//g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="//g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="//g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
Analysis Services (SSAS)
Items 1 to 20 of 227
Older >>
MDX Guide for SQL Folks: Part I - Navigating The Cube
Learn all you need to know about MDX, by drawing only on your current SQL knowledge.
Read more...
By
Frank A. Banin
2014/06/13 (first published: 2012/11/01)
|
Source:
SQLServerCentral.com
|
Category:
mdx
Rating:
|
Discuss
|
Briefcase
|
18,044 reads
Index Breakdown
Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.
Read more...
By
Sean Smith
2014/04/11
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
|
Discuss
|
Briefcase
|
2,550 reads
SaaS and Multi-tenancy Models
If you need to architect a multi-tenant Analysis Services project, what are your options? This piece from Sean Woehrle shows four options and explains why he picked a particular one.
Read more...
By
Sean Woehrle
2014/03/11
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
4,835 reads
Analysis Services Tabular
Read more...
By
Steven Neumersky
2014/02/05
|
Category:
querying
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,254 reads
Analysis Services Multidimensional
Read more...
By
Steven Neumersky
2014/02/04
|
Category:
hierarchies
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,286 reads
Analysis Services Multidimensional
Read more...
By
Steven Neumersky
2014/02/03
|
Category:
analysis services (ssas)
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,389 reads
Index Breakdown
Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.
Read more...
By
Sean Smith
2014/04/11
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
|
Discuss
|
Briefcase
|
2,550 reads
DAX Query Basics
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
Read more...
By
Gary Strange
2013/12/12 (first published: 2012/09/25)
|
Source:
SQLServerCentral.com
|
Category:
dax
Rating:
|
Discuss
|
Briefcase
|
13,678 reads
SQL Server 2012 Analysis Services XMLA
Cube developers often flippantly use the term XMLA in their discussion of maintaining, scripting, backing up, and restoring cubes and other SSAS objects; what exactly is XMLA and how can it be used? Check out this tip to learn more.
Read more...
By
Additional Articles
2013/07/22
|
Source:
MSSQLTips.com
|
Category:
analysis services (ssas)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,181 reads
SSAS Joining Facts at Different Granularities
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example,...
Read more...
By
MikeDavis
2013/07/19
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,065 reads
Analysis Services Webinar Recording and Q&A
I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013. If...
Read more...
By
Devin Knight
2013/04/08
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,008 reads
Data Mining SQLIO Results
Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.
Read more...
By
Paul Brewer
2013/03/26
|
Source:
SQLServerCentral.com
|
Category:
sqlio
Rating:
|
Discuss
|
Briefcase
|
2,899 reads
SQL Server Analysis Services-Lead, Lag, OpeningPeriod, ClosingPeriod Time Related Functions
Working with SSAS time related accounting functions can be tricky. SQL Server 2012 now offers Lag and Lead functions. Are these functions available in SSAS? What other related functions are available?
Read more...
By
Additional Articles
2013/02/20
|
Source:
SQLServerCentral.com
|
Category:
analysis services (ssas)
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,362 reads
MDX Guide for SQL Folks: Part III - Advanced Analysis
Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.
Read more...
By
Frank A. Banin
2013/02/14
|
Source:
SQLServerCentral.com
|
Category:
mdx
Rating:
|
Discuss
|
Briefcase
|
5,257 reads
MDX Guide for SQL Folks: Part II - Hierarchies and Functions
Learn everything about MDX by drawing only on your SQL knowledge.
Read more...
By
Frank A. Banin
2012/12/18
|
Source:
SQLServerCentral.com
|
Category:
mdx
Rating:
|
Discuss
|
Briefcase
|
6,979 reads
Create SQL Server Analysis Services Partitions using AMO
When you have SSAS cubes with millions of rows of data, it is very helpful to create partitions. If you have a few cubes you could probably do this manually, but if there are many or if you want to automate this process you should look for smarter solutions such as programming the creation of partitions dynamically.
Read more...
By
Additional Articles
2012/11/19
|
Source:
MSSQLTips.com
|
Category:
analysis services (ssas)
Rating:
Rate this
|
Briefcase
|
1,960 reads
MDX Guide for SQL Folks: Part I - Navigating The Cube
Learn all you need to know about MDX, by drawing only on your current SQL knowledge.
Read more...
By
Frank A. Banin
2014/06/13 (first published: 2012/11/01)
|
Source:
SQLServerCentral.com
|
Category:
mdx
Rating:
|
Discuss
|
Briefcase
|
18,044 reads
DAX Query Basics
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
Read more...
By
Gary Strange
2013/12/12 (first published: 2012/09/25)
|
Source:
SQLServerCentral.com
|
Category:
dax
Rating:
|
Discuss
|
Briefcase
|
13,678 reads
Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.
Read more...
By
Additional Articles
2012/09/14
|
Source:
Microsoft MSDN
|
Category:
business intelligence
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,555 reads
Summarizing Imported Data
This article shows a few simple techniques to summarize table data using T-SQL.
Read more...
By
paddythegeek
2012/07/27
|
Source:
SQLServerCentral.com
|
Category:
import
Rating:
|
Discuss
|
Briefcase
|
1,978 reads
Items 1 to 20 of 227
Older >>
Tags
data warehousing
(62)
mdx
(20)
blogs
(18)
dimensions
(10)
reporting services (ssrs)
(10)
sql server 2005
(10)
olap server
(9)
integration services (ssis)
(8)
amo
(7)
data mining
(7)
design and theory
(7)
video
(6)
powershell
(5)
security
(5)
sql server 2008
(5)
sql server 7
(5)
backup / restore
(4)
business intelligence
(4)
cube
(4)
news
(4)
olap
(4)
chart
(3)
hierarchies
(3)
hierarchy
(3)
miscellaneous
(3)
performance tuning
(3)
programming
(3)
t-sql
(3)
administration
(2)
attributes
(2)
cubes
(2)
data modeling
(2)
excel
(2)
holap
(2)
lag
(2)
lead
(2)
proclarity
(2)
rolap
(2)
sql server 2008 r2
(2)
sql server 2012
(2)
tabular model
(2)
time dimension
(2)
ado
(1)
advanced querying
(1)
ascmd
(1)
backups
(1)
best and worst practices
(1)
breakdown
(1)
cach
(1)
certifications
(1)
change data capture (cdc)
(1)
closing balances
(1)
closingperiod
(1)
clustering
(1)
consolidation
(1)
custom calendars
(1)
data integrity
(1)
database mail
(1)
date manipulation
(1)
dax
(1)
denormalization
(1)
detach
(1)
details
(1)
dimension
(1)
dimensional modelling
(1)
duplicates
(1)
firewall
(1)
iif
(1)
import
(1)
index
(1)
informatica
(1)
integration
(1)
inventory problem
(1)
level_number()
(1)
linked server
(1)
matrix
(1)
measures
(1)
memory
(1)
microsoft
(1)
migration
(1)
molap
(1)
ms bi project documentation
(1)
ms bi tools and utilities
(1)
neural network
(1)
openingperiod
(1)
operational analytics
(1)
optimization
(1)
optimize
(1)
partition
(1)
partitioning
(1)
partitions
(1)
policy based management (pbm)
(1)
profiler
(1)
qlikview
(1)
querying
(1)
rdbm
(1)
report builder
(1)
reports
(1)
sample chapters
(1)
scans
(1)
seeks
(1)
semi-additive measures
(1)
size
(1)
software development
(1)
sql server
(1)
sql trace
(1)
sqlio
(1)
stats
(1)
strategies
(1)
troubleshoot
(1)
unused
(1)
usage
(1)
user groups
(1)
user-defined hierarchies
(1)
visio
(1)
visual basic 6
(1)
Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
