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: Cube
767 results found
Does Linked Measure Group allows to delete the not used Measures for that cube?
Hello BIDN family, After long time gap, I just want to share something regarding the Linked Measure Group and which might be sure helpful to all of us mainly in the field of SSAS . While creating and processing cube with Linked Measure Group I got certain
Author:
Anil
Date: 8/30/2012 Section:
Blog
tags :
Linked Measure Group
Ten MDX Calculations For Your
Cube
I get lots of questions about how to implement various types of calculations in a cube so I figured I'd cover some of the more commonly used calculations I run into on a regular basis. All of these example calculations I'll be providing were written again
Author:
DustinRyan
Date: 11/17/2011 Section:
Blog
tags :
BI xPress
,
count leaf members
,
MTD
,
YTD
Retrieving Data From Multiple
Cube
s in an MDX Query Using the Lookupcube Function
In response to a forum question a fellow BIDN user had posted, I decided to write a blog that covers and expands upon what I demonstrated in my answer. Basically, the question boiled down to being able to query multiple cubes in a single MDX statement. Th
Author:
DustinRyan
Date: 7/1/2010 Section:
Blog
tags :
MDX query two cubes
,
LOOKUPCUBE function
Cube
Design
This is not what a cube is designed for. A cube is designed to view the measures sliced up by dimension. Really no built in way to compare one dimension to another. This would take two different queries from the cube. Or you could right some mdx caculatio
Author:
MikeDavis
Date: 2/4/2010 Section:
Forum
tags :
cube
,
dimension
,
fact
,
measure
,
SSAS
ssas
Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
ssas
Cube
Hi there. Well, there is a lot to consider before creating a cube, depending on your needs. I would ask you this: 1) Refresh frequency that data will be refreshed? daily, hour? 2) How many records will be updated in each refresh? 3) Is there any security
Author:
marcoadf
Date: 4/3/2012 Section:
Forum
tags :
Design
,
Security
SSIS: parallel processing not supported by analysis services processing task
I'm processing all the Dimensions related to the Cube through SSIS. I process the Cube separately once all the Dimensions have been processed. I use the SSIS component "Analysis Services Processing Task": - In the editor, I add the required Dimensions wit
Author:
amrit
Date: 3/22/2011 Section:
Forum
tags :
Enterprise Edition
,
Parallel Processing
,
SSAS
,
Standard Edition
,
Warning
,
SSIS
Reporting on an SSAS
Cube
with SSRS 2008
In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.
Author:
DustinRyan
Date: 5/7/2010 Section:
Article
tags :
MDX query
,
MDX query designer
,
SSRS cube report
,
SSRS 2008
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
Super Seven
Cube
Cleanup Steps
Everyone likes to get a project done, but many times in our rush to deploy we bypass some of the things that demonstrate the consistency and usability that give our projects the credibility they need. How many times have you used an application that had w
Author:
AdamJorgensen
Date: 11/23/2009 Section:
Blog
tags :
BIDS
,
Cube
,
SSAS Development
Tuning Multi-Dimensional
Cube
Processing
In my last post ( HERE ) we talked about troubleshooting and resolving issues with problematic MDX queries. In this post we will look at techniques to tune and troubleshoot the processing side of your Analysis Services cube. Understanding Cube Processing
Author:
cprice1979
Date: 12 days ago Section:
Blog
tags :
Analysis Services
,
Cube Processing Dimension Attribute
Processing a SSAS cube -- Steps for beginners
I thought today I will cover the steps that can be followed to process a Sql Server Analysis Services Cube from Sql Server Management STudio. The assumption is that you already have a cube that is built in SSAS and you would like to process this cube from
Author:
indupriya
Date: 3/1/2011 Section:
Blog
tags :
process SSAS cube
,
SSAS cube
Free Webinar Tomorrow (7/21) @ 11 am EST: Reporting on a
Cube
with SSRS 2008
Tomorrow (7/21) I’ll be speaking on reporting on an SSAS cube with SSRS 2008 at 11 a.m. EST. It’s a completely free event hosted by Pragmatic Works and it last about an hour. In this session I’ll give you an introduction to reporting on a cube with SQL Se
Author:
DustinRyan
Date: 7/20/2011 Section:
Blog
tags :
Free Training
,
SSAS
,
SSRS
Dimension "Process Update"
I am working in a scenario where I want to update certain cell values in the dimension tables (in the DW) and then bring those changes to the cube dimensions using "Process Update". I know there is a writeback option but I want to update my datawarehouse
Author:
az.asharma
Date: 7/6/2011 Section:
Forum
tags :
cube
,
Dimension
,
Distinct Count
,
Process Update
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
LookUp
Cube
Function MDX Query Performance Test
In my previous blog post , I mentioned that there was a performance cost for using the LookUpCube function. Well recently a coworker asked me just home much of a performance hit was the LookUpCube function going to cause. So I decided to conduct a test. I
Author:
DustinRyan
Date: 7/7/2010 Section:
Blog
tags :
MDX query performance
,
LookUpCube Function
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
Cube
Design
I created a sample data warehouse using the values you gave above. The only problem was the SK on the budget table. I had to create a row on the budget table to match the new sk's in the fact table. I was able to build and deploy the cube and I can browse
Author:
MikeDavis
Date: 2/2/2010 Section:
Forum
tags :
cube
,
dimension
,
fact
,
measure
,
SSAS
Cube
Deployment - Credential Problems
I recently upgraded to SQL Server 2008 R2 on my local machine and had to go through the joyous occasion of reloading all the adventure works sample databases. This is never a problem, until I have to deploy the sample cubes. I'm not too knowledgeable in t
Author:
ShawnHarrison
Date: 7/21/2010 Section:
Blog
tags :
Analysis Services
,
deployment
,
impersonation
,
SSAS
,
Cubes
SSAS Different Dimension Granularity
In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example, if you have budget measures and actual numbers. If you are trying to budget your expenses you budget at a higher level than the actual
Author:
MikeDavis
Date: 5/28/2010 Section:
Blog
tags :
Cube
,
DImension
,
Granularity
,
Define Relationship
,
SSAS
Showing Measure values as either ‘0’ or ‘NULL’ in
Cube
?
Hello BIDN Family, It been long time and I really miss BIDN family group network ,after a long time gap I would love to post this blog which might be helpful to the one who works in SSAS. While designing a cube everyone simply doesn’t care about the
Author:
Anil
Date: 4/9/2012 Section:
Blog
Use SQL Server Agent to Process
Cube
You may want to use SQL Server Agent to have a Cube processed as part of a scheduled job. This is how you create the step to process the Cube. After connecting to the Analysis Server, right click on the Cube and select Process. When the process window ope
Author:
timmurphy
Date: 1/8/2011 Section:
Blog
tags :
SQL Server Agent
,
Process Cube
MDX Scripting with SCOPE Statement
In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.
Author:
DustinRyan
Date: 3/15/2010 Section:
Article
tags :
MDX Scripting
,
SCOPE statement
,
MDX
Difference between SSAS ProcessUpdate and ProcessFull
In my website post, I have explained about optimal strategy for incremental cube processing . same post talks about using ProcessUpdate for dimension processing. In this post, I have tried to compare ProcessUpdate and ProcessFull options so you can better
Author:
sirfnet
Date: 1/10/2011 Section:
Blog
tags :
Dimension
,
SSAS
,
SSAS Tutorial
,
Tutorial
,
Advanced Feature
Dump MDX OLAP Query output to a relational table from SSMS
I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.
Author:
artuladhar
Date: 5/16/2012 Section:
Blog
tags :
dump
,
file
,
MDX data
,
OLAP
,
output
,
query
,
Table
Page 1 of 31 (767 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]