Analysis Services

• Topics

  Started by

  Posts

  Last post

• Semi-additive measures with SSAS Standard edition

  How do people handle semi-additive measures with SSAS Standard edition? (other than switching to E…

  robert.gerald.taylor

  1 replies

  13 years ago

  By: boxta

• Indexing Fact and Dimension Tables

  Is there a way to create index on fact and dimension tables in cube?

  sqlizer

  2 replies

  13 years ago

  By: boxta

• Adding average makes all metrics blank

  All, I have a SiteCharacteristic fact table surrounded by a SiteDimension, CharacteristicDimension …

  Mike Austin-398977

  1 replies

  13 years ago

  By: sqlizer

• Translations not completely supported for BI Semantic Model (Multidimensional) in Standard & BI Edition of SSAS 2012

  Hi all, When you have a look at the msdn page 'Features Supported by the Editions of SQL Server 20…

  eXuberate

  1 replies

  13 years ago

  By: ricardosada

• Fact Table Not Processing

  I really could use some help figuring this one out. We started receiving the following error today…

  robshobs

  2 replies

  13 years ago

  By: robshobs

• nable to build SQL Server OLAP Cube when there is no rows corresponding to foreign key in a table

  I am new to SQL Server OLAP Cubes. I am having the following issue like ex I have purchase order an…

  grasshopper26

  5 replies

  13 years ago

  By: MMartin1

• applying filter in MDX

  Hi, i have one MDX query which i am using for reporting, i have around 30 different fields which ha…

  nish71

  5 replies

  13 years ago

  By: MMartin1

• Good MDX tutorial ?

  Hi, Could anybody recommend good MDX tutorial ? Thanks.

  SQL Guy 1

  9 replies

  13 years ago

  By: MMartin1

• unable to restore AdventureWorks 2008 R2 database

  Hi Experts, Whenever i try to restore the AdventureWorks 2008 R2 cube database i get the following …

  H4K

  1 replies

  13 years ago

  By: robert.gerald.taylor

• Date in Date Time Dimension not ordering correctly

  I have the following in Date time dimension ID Date 2011100606/10/2011 2011100707/10/…

  Debbie Edwards

  6 replies

  13 years ago

  By: Debbie Edwards

• Conditional Calculated Measures

  I am having an issue trying to add some conditional logic to a calculated measure. What I am trying…

  michael.french 172

  1 replies

  13 years ago

  By: Mackers

• "Avoid defining measure groups with zero dimensional overlap" how to add overalp?

  I am newbie to SSAS I am trying to understand the following sentence from SSAS cube i just buil…

  grasshopper26

  1 replies

  13 years ago

  By: robert.gerald.taylor

• SSAS partitions

  Everything I read says you need Enterprise edition to partition a measure in a SSAS cube. I'm runn…

  robert.gerald.taylor

  13 replies

  13 years ago

  By: robert.gerald.taylor

• Joining two queries in MDX

  I have two queries that has been implemented in MDX for different dates: SELECT NON EMPTY { [Measur…

  Aspet Golestanian Namagerdi

  2 replies

  13 years ago

  By: Mackers

• MDX to Calculate Moving Avarage

  Hello everyone, I am a mdx newbie and I neep (please) your Help. I have created a Cube that has 3 d…

  rena24

  9 replies

  13 years ago

  By: rena24