Analysis Services

• Topics

  Started by

  Posts

  Last post

• Concatenating string to measures in MDX query

  Hi, I have MDX Query which is select non empty { ORDER( TOPCOUNT(NonEmpty({ [Measures].[Date] },(…

  sqlbi

  5 replies

  13 years ago

  By: sqlbi

• SSAS-

  hello I am getting error when i am processing qube on instance . But it works fine on one instance …

  hpatelc

  11 replies

  13 years ago

  By: hpatelc

• multi level fact table

  Hi, I am trying to model an insurance claims process that contains 2 levels. Each claim has a main …

  scottcabral

  2 replies

  13 years ago

  By: scottcabral

• Calculating a percentage across a matrix group

  Dear All, I am developing a report in Report Builder 3.0 Thus far I have a matrix which uses Servic…

  iain.cowden

  4 replies

  13 years ago

  By: iain.cowden

• persist data in pivot report in excel 2007 from ssas data source

  Hi all, I am very new to this. I built a pivot report (excel 2007) on ssas. It has data, rows, colu…

  nzhang6666

  2 replies

  13 years ago

  By: nzhang6666

• Help With MDX

  Hi everyone, I need help with building a Cube Calculation. I have this MDX below that works OK. It …

  Jonathan Mallia

  1 replies

  13 years ago

  By: a4apple

• Fact - Fact Relationship ?

  Hi Experts, Please Help !! I had a Manager who asked me this question during interview that: whethe…

  H4K

  1 replies

  13 years ago

  By: Tee Time

• hierarchy Help

  I am trying ti build hierarchy based on FirstName,MiddleName,LastName,ContactID My Dimension table …

  Smash125

  1 replies

  13 years ago

  By: a4apple

• Cube processing error

  1) Scheduling the processing of the full cube was working fine until I disabled one of the columns …

  SQL_Surfer

  2 replies

  13 years ago

  By: SQL_Surfer

• excel 2007 pivot on ssas

  Hi everyone, I am new to this. I built a pivot report in excel 2007 on a SSAS cube on my local pc. …

  nzhang6666

  4 replies

  13 years ago

  By: nzhang6666

• ssas 2008 how to remove total for non hierarchy dimension attributes

  Hi all, I am new to SSAS. As you can see there is a Total added automatically by SSAS. The Birth Da…

  nzhang6666

  2 replies

  13 years ago

  By: nzhang6666

• SSAS any recommendation for installing this on a separate server from SQL Server Instance

  Hi, I have to install SSAS but I don't know what is the best practice to follow whether installing…

  APA0876

  1 replies

  13 years, 1 months ago

  By: richykong

• dimension ordering

  Is it a possibility to order the dimensions of an Analysis Services project? For Example I want to …

  antonela

  2 replies

  13 years, 1 months ago

  By: antonela

• Filter on measure?

  I have a cube with measures and dimensions. Now, one of reports which I need to create must have fi…

  Ognjen Kovacevic

  1 replies

  13 years, 1 months ago

  By: Mackers

• Report Builder - How to total percentages and find the average

  Hi Everyone. Hope someone here can help me out. I am new to Report Builder and Expressions. I was …

  lmd999

  3 replies

  13 years, 1 months ago

  By: lmd999