Analysis Services

• Topics

  Started by

  Posts

  Last post

• Creating lists from multiple dimensions where there is no logical count

  Hopefully the title is about right - hard to put this into one line. I have had an SSAS 2012 cube, …

  S_francis_uk

  3 replies

  10 years, 11 months ago

  By: PB_BI

• Date Hierarchy CurrentMember returns Null, what am i doing wrong

  When I run the following query, [Measures].[Previous Period] and [Measures].[X] are coming back wit…

  mailbox.jon

  1 replies

  10 years, 11 months ago

  By: PB_BI

• Reading XML data in MDX ?

  Hi All, I am trying to read XML data from an XML datatype columnin MDX The query i am using is SEL…

  Shadab Shah

  1 replies

  10 years, 12 months ago

  By: PB_BI

• Rolap & Molap Dimensions

  Hi all I am new to the BI side of SQL Server so I have a couple of newbie questions. Am I correct i…

  SQLSACT

  7 replies

  10 years, 12 months ago

  By: PB_BI

• SSRS issues: LastPeriods resulting in different number of columns being returned based on date level passed in

  SELECT ([Measures].[Fact TOL Activity Count]) ON COLUMNS, TopCount( Except( {[ADVISER]…

  mailbox.jon

  9 replies

  10 years, 12 months ago

  By: mailbox.jon

• How to filter 2 dimension values

  i have two dimesion tables tables (Country and State) .i want amount based on country and state fi…

  raghavag7

  1 replies

  11 years ago

  By: PB_BI

• Two Different Dimension Attribute values filtaration

  Hi, I have 2 different dimensions and fact table,but i want amount based on 2 dimension Att…

  raghavag7

  1 replies

  11 years ago

  By: PB_BI

• Need MDX query to pull empty hierarchy

  Hi all, I am trying to pull a corporate hierarchy, and there are multiple levels (level 2 (CEO), le…

  Alan Kwan

  1 replies

  11 years ago

  By: PB_BI

• Kill all connections to a specific database

  Hi All, I am wondering if there is a way to kill automatically all connection to a specific databas…

  Rem70Rem

  2 replies

  11 years ago

  By: Rem70Rem

• MDX query using hierarchy gives Subtotals

  Hi, I don't have a background in MDX queries so I may be missing an obvious point here. I have a MD…

  andrew.manning

  1 replies

  11 years ago

  By: PB_BI

• SSAS Tabular- possible to display just detail level data in Excel?

  Imagine an HR model and one requirement is to just list all the employee "dimension" data: Group by…

  Maxer

  2 replies

  11 years ago

  By: Maxer

• YTD MDX Question

  I have the following MDX calculation in my SSAS cube that returns Prior YTD Sales based on the curr…

  randy.jaye

  6 replies

  11 years ago

  By: happycat59

• Cube Claculations

  SSAS 2012 Bit of a weird issue here. Created some cube calculations. CREATE MEMBER CURRENTCUBE.[Me…

  Ells

  3 replies

  11 years ago

  By: Ells

• Missing BIDS package

  I am running SQL Server 2008, and have recently been handed over all the SSAS packages to manage. I…

  Shaira

  2 replies

  11 years ago

  By: Shaira

• show distinct Dimension Attribute for Date

  Current Level - All April April April May May May June June June so on..... How do i make sure to s…

  hpjack433

  1 replies

  11 years ago

  By: PB_BI