Who is online?
Become a member
» search results
Search Results: Cube Design
8 results found
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
Date: 3/30/2011 Section:
custom member property
How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?
Hi people, How can I write an MDX statement or query that selects the clients who paid last month but have not paid this(Current Month) month?. I have a data cube designed and deployed on Microsoft SQL Server Analysis Services R 2. I have a customer dimen
Date: 12/14/2011 Section:
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
Date: 3/20/2011 Section:
MDX Calculation Builder Automatically Builds MDX Calculations for You
One of the most powerful aspects of Analysis Services is the ability to easily view your facts over time. What's not always so easy is writing those calculations that make complex time analysis possible. MDX can have a steep learning curve, which is where
Date: 10/31/2011 Section:
MDX Calculation Builder
Different Granularity in a Single Dimension
There is no perfromance hit due to the lack of foreign keys, in fact I would suggest using views in you DSV instead of the actual tables. That is dicussed in this book. Expert Cube Design. There is a perfromance hit when using strings instead of int's in
Date: 10/18/2010 Section:
Understanding Analysis Services Relationships using Dimension Usage
In this article Devin examples how each relationship type works inside Analysis Services. After reading this you should be able to translate your data warehouse design into a cube design that can be used by your end users.
Date: 3/29/2011 Section:
Free SSAS Expo again from SSWUG on FRiday (20th May 2011)
SSWUG.ORG’s virtual expo will review various aspects of SQL Server Analysis Services (SSAS), which enables the server to be used for analytical processing and data mining. Through our in-depth sessions with four of the leading experts in the information t
Date: 5/19/2011 Section:
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.
Date: 11/24/2009 Section:
Page 1 of 1 (8 items)
Copyright © 2013 Axero Solutions LLC.
Business Intelligence Developer Network powered by
® Version 2.5.4240.2964
Choose your language: