<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://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="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://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 224
Older >>
Analysis Services Tabular
Read more...
By
Steven Neumersky
2014/02/05
|
Category:
querying
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,159 reads
Analysis Services Multidimensional
Read more...
By
Steven Neumersky
2014/02/04
|
Category:
hierarchies
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,201 reads
Analysis Services Multidimensional
Read more...
By
Steven Neumersky
2014/02/03
|
Category:
analysis services (ssas)
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,284 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
2013/12/23
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
|
Discuss
|
Briefcase
|
1,418 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
|
12,680 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,105 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
|
940 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
|
917 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,860 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,267 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
|
4,977 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,679 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,884 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
2012/11/01
|
Source:
SQLServerCentral.com
|
Category:
mdx
Rating:
|
Discuss
|
Briefcase
|
12,520 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
|
12,680 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,461 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,972 reads
Backups in SQL Server Analysis Services
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI:...
Read more...
By
2012/07/24
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,440 reads
Using ASCMD to run command line scripts for SQL Server Analysis Services
Sometimes it would be helpful to run scripts from a command line for Analysis Services. This would be useful for things like creating backups, processing data or running other tasks. Is there a command line tool like sqlcmd for multidimensional databases and Data Mining?
Read more...
By
Additional Articles
2012/06/18
|
Source:
MSSQLTips.com
|
Category:
ascmd
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,250 reads
What happens when a SSAS Tabular model exceeds memory?
If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...
Read more...
By
2012/05/24
|
Source:
SQLServerCentral.com
|
Category:
blogs
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,747 reads
Items 1 to 20 of 224
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.
