Top "Ssas" questions

Multiple Joins from one Dimension Table to single Fact table

I have a fact table that has 4 date columns CreatedDate, LoginDate, ActiveDate and EngagedDate. I have a dimension table called …

ssas olap olap-cube

Mdx , All and All Members differences

In MDX what is the difference between [Period].[Period Name].[Period Name].ALLMEMBERS and [Period].[Period Name].ALL are these …

ssas mdx

creation of dimension and fact table through source tables

I have imported my flatfiles to SQL Server 2012 and created few tables (source tables). I need to build a cube …

sql ssas cube dimension fact

Analysis Services Processing Task Fails When Run By SQL Server Agent

I have an SSIS package which contains an Analysis Services Processing Task. This package is kicked off by a SQL …

ssis sql-server-2008-r2 ssas sql-server-agent

Best Practise to populate Fact and Dimension Tables from Transactional Flat DB

I want to populate a star schema / cube in SSIS / SSAS. I prepared all my dimension tables and my fact …

database ssis ssas etl business-intelligence

Model a relationship between two fact tables

I have a Sales fact table, an Orders fact table (both line level detail), and two date roleplaying dimensions (from …

ssas olap olap-cube ssas-2008

Using Entity Framework with an SSAS Cube

Is it possible to use Entity Framework (any version, including, and preferably 4.0) to query an SSAS cube (preferably SSAS 2008)?

entity-framework ssas

Create member with description in MDX

This is a pretty straight forward question that may or may not be possible but, when you create a measure …

ssas mdx olap-cube

Handling nulls in Datawarehouse

I'd like to ask your input on what the best practice is for handling null or empty data values when …

sql ssis ssas data-warehouse

SSMS Change Connection for Query Editor Window

Normally when I want to change the connection for a Query Editor Window in SQL Server Management Studio, I can …

sql-server-2008 ssas ssms