Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: ssas
490 results found
Help! I Can’t Connect to Analysis Services in SSMS
A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well. While playing around with SSAS, I tried to open up SQL Server Management Studio (SSMS) and connect up to Analysis Services. The screenshot below shows how I
Author:
briankmcdonald
Date: 11/2/2010 Section:
Blog
tags :
Analysis Services
,
Brian K. McDonald
,
Connecting to SSAS using SSMS
,
no connection could be ma
,
SSAS
Creating a Data Source View(DSV) in SSAS
Continuing with the series on building your first cube, Adam takes you through exploring the UDM in SSAS 2008 and creating a DSV from which your cube can be designed.
Author:
AdamJorgensen
Date: 11/24/2009 Section:
Article
tags :
SSAS 2008
,
SSAS Development
,
SSAS Projects
,
DSV
BI Xpress SSAS MDX Builder and SSIS Deployment
BI Xpress SSAS MDX Builder and SSIS Deployment If you build SSIS Packages, or work on SSAS Cubes, BI Xpress is a must have tool for you. It has made my life so much easier in all of my BI work. I want to share with you just a couple of the features it con
Author:
MikeDavis
Date: 6/7/2011 Section:
Blog
tags :
BI MDX
,
BIxpress
,
Deploy
,
Deployment
,
SSAS
,
SSIS
Connecting to and Querying an SSAS Cube in SSIS
So imagine that you need to create a solution to moving the aggregated data from a cube into another location for a third party, such as a spread sheet, SQL Server table, or a flat file. We can accomplish this task using SSIS. First, create a new OLE DB C
Author:
DustinRyan
Date: 1/19/2011 Section:
Blog
tags :
connect to SSAS cube in SSIS
,
transfer data from SSAS cube with SSIS
,
query SSAS cube with SSIS
Configuring an SSAS 2008 Project
In this article, Adam takes you through the basics of configuring an SSAS project in Business Intelligence Development Studio. He explores some options you will use every day, and some you should consider using to improve your team development.
Author:
AdamJorgensen
Date: 11/24/2009 Section:
Article
tags :
SSAS Configuration
,
SSAS Development
,
Visual Studio
,
SSAS 2008
This Year - Last Year SSAS Calculated Member
In this quick demo I’m going to add a calculated member to the AdventureWorks cube that allows an end user to do a This Year/ Last Year comparison for a given measure.
Author:
tinocash
Date: 2/16/2010 Section:
Article
tags :
Analysis Services
,
Calculated Measures
,
SSAS
,
Calculated Members
How to Document SQL Server- BI Documenter
How to Document SQL Server So you created this amazing BI solution. You have SSIS Packages loading your data warehouse, you have SSAS Cubes, and you have reports in SSRS. But how do you document this entire solution? It used to be a long tedious process.
Author:
MikeDavis
Date: 6/7/2011 Section:
Blog
tags :
Database
,
Index
,
SQL Server
,
SSAS
,
SSIS
,
SSRS
,
Tables
,
Document
SSAS – Using the Euro or Pound currency Symbol in a measure Format String
SSAS – Using the Euro or Pound currency Symbol in a measure Format String If you have a set of measures and some of them are US dollars, some are Euros, and some are UK Pounds, you want to format them correctly in SSAS. First you will need to know the ASC
Author:
MikeDavis
Date: 6/3/2011 Section:
Blog
tags :
currency
,
Format String
,
measure
,
Pound
,
Symbol
,
.Euro
,
formatstring
,
SSAS
Near Real Time OLAP using SSAS Proactive Caching
If I had a nickel for every time I've heard from a business user that the OLAP solution must support current real time data from the source system, I'd have at least half a dollar. The fact is that in reality there is usually some acceptable degree of lat
Author:
MMilligan
Date: 1/13/2012 Section:
Blog
tags :
client initiated
,
partitioning
,
proactive caching
,
scheduled polling
,
sql server notification
SSWUG Free Expo Event: Understanding SQL Server Analysis Services on 20th May 2011
Here is another free expo/event from SSWUG about SSAS on 20th May 2011 Sessions will cover the following topics: Common Mistakes with SSAS Cube Designs SSAS Partitioning and Aggregation Strategies Properly Using the SSAS Query Cache Overcoming SSAS Implem
Author:
meganathank
Date: 3/20/2011 Section:
Blog
tags :
Free Event
,
SSWUG
,
SSAS
Microsoft Business Intelligence Certification 70-448, SSIS, SSAS, SSRS
I just passed the Microsoft BI certification test 70-448 on SSIS, SSAS, and SSRS. It was a tough test and covers all aspects of the Microsoft BI stack. I used a lot of different study materials. Here is my assessment of the study materials I used and whic
Author:
MikeDavis
Date: 1/30/2010 Section:
Blog
tags :
70-448
,
Microsoft Business Intelligence
,
Preperation
,
SSAS
,
SSRS
,
Test
,
SSIS
SSAS lazy processing
When we reprocess SSAS cube then it actually bring new/changed relational data into SSAS cube by reprocessing dimensions and measures. Partition indexes and aggregations might be dropped due to changes in related dimensions data so aggregations and partit
Author:
sirfnet
Date: 1/12/2011 Section:
Blog
tags :
Analysis services tutorial
,
Lazy processing
,
SSAS tutorial
,
SSAS
SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode
As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model (I covered these new features here ). During ins
Author:
jamserra
Date: 7/25/2011 Section:
Blog
tags :
Denali
,
SQL Server
,
SSAS
,
BISM
Data Mining and base knowledge.
Hi. With the recent article from Devin about mining, he has made me remeber that I was about to ask one thing to all of you about this subject. SSAS provides data mining. Are there a wide variety of models provided by SSAS, or just the most known ones? An
Author:
marcoadf
Date: 1/24/2010 Section:
Forum
tags :
mining
,
ssas
,
models
Steps to schedule and automate backups of all the SSAS catalogs/ databases within a server instance.
With the course of time, you might need to backup all the SSAS databases within a server instance automatically and schedule to backup these database monthly wise or according to your specific time set. May be there are a lot of alternative methods to per
Author:
Anil
Date: 3/11/2011 Section:
Blog
tags :
Job Agent
,
SSIS
,
SSMS
,
SSAS
Creating a Data Source in SSAS 2008
In this article, Adam walks through the process and options when creating a data source as your first step towards cube development in Analysis Services 2008.
Author:
AdamJorgensen
Date: 11/24/2009 Section:
Article
tags :
SSAS Data Sources
,
SSAS Development
,
SSAS Security
Seven Steps to a Cube in Analysis Services 2008
In this article, Adam walks you through the basics of building a cube in SSAS 2008.
Author:
AdamJorgensen
Date: 11/24/2009 Section:
Article
tags :
Cube Design
,
SSAS 2008
,
SSAS Development
,
SSAS
Clear SSAS Server Query Cache for MDX Query Performance Testing
When performance testing your MDX query, you should clear the SSAS server cache so that your queries are not answered from the cache. This could skew your query performance results. To clear the SSAS server cache, you need to use the <ClearCache> co
Author:
DustinRyan
Date: 10/12/2010 Section:
Blog
tags :
clear SSAS server cache
,
performance test MDX
,
MDX
Using Dimension Member Property Values in MDX/DataSets/Reports
I get a bit frustrated with accommodating SSAS cube design decisions for SSRS shortcomings. Specifically, it does not make sense in the cube design to set the AttributeHierarchyEnabled property to TRUE for attributes with high cardinality. These attribute
Author:
Timo
Date: 3/30/2011 Section:
Forum
tags :
AttributeHierarchyEnabled
,
custom member property
,
MDX
,
query designer
Reporting with Analysis Services tutorials needed
Check out William Pearson's library of SSRS articles (as well as SSAS and MDX series') here: http://www.databasejournal.com/article.php/1459531 The SSRS series here is focused entirely upon SSRS with SSAS as a data source - he does lots on paramterization
Author:
LAZARUS
Date: 5/31/2011 Section:
Forum
tags :
cube
,
mdx
,
reporting Services
,
ssrs
,
SSRS 2008 R2
SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. Part of those details were an update on the SQL Server Analysis Services ( SSAS ) roadmap. The main new feature in SSAS is a new d
Author:
jamserra
Date: 6/29/2011 Section:
Blog
tags :
Denali
,
SQL Server
,
SSAS
,
BISM
Creating dimensions in SSAS 2005 and 2008 -- differences
This article discusses the procedure to create dimensions in SAS 2005 and 2008. In both SSAS 2005 and 2008 we can create dimensions using wizards. The biggest difference is in 2005 the wizard asks lot more questions than in 2008. In 2008 the wizard is a l
Author:
indupriya
Date: 7/6/2010 Section:
Article
tags :
SSAS 2008
,
SSAS 2005
SSAS Compare, a cool tool for Microsoft Business Intelligence professionals.
Hello BIDN Family, It’s been long time gap and I was really missing my blogging time part. Through this blog I would just want to share the new tool developed by the Red –Gate called SSAS Compare . which I think , SSAS Compare is one of the co
Author:
Anil
Date: 6/12/2012 Section:
Blog
tags :
SSAS Compare
How to create Day,Month,yearwise Cube in SSAS
Well, there is a lot of concepts that you should take in consideration. 1st of all, you will need a fact table. In this table you should have a day code. This day code typically has YYYYMMDD format so it can be a integer and benefict from many advantages.
Author:
marcoadf
Date: 2/10/2012 Section:
Forum
tags :
code
,
day
,
month
,
quarter
,
table
,
time dimension
,
year
SSAS Impersonation Smackdown - Specific Windows Acct vs Service Account
Recently I was helping a client with their Analysis Services database structure. In this particular environment, there are a lot (and I mean A LOT) of AS db’s. One of the first things I noticed is that almost every single one was using the service a
Author:
ChrisSchmidt
Date: 1/23/2013 Section:
Blog
tags :
SSAS 2012
,
ssas impersonation modes
,
ssas service account
Page 1 of 20 (490 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]