Analysis Services

• Topics

  Started by

  Posts

  Last post

• Week Grand Total not equal to sum across 7 days

  Hi, I have this strange situation where the week dimension Grand Total for a measure, say NumberOfU…

  1Ankit1

  8 replies

  14 years, 2 months ago

  By: 1Ankit1

• ssas isolation property

  can any one explain about isolation property in SSAS [font="Verdana"]SRIHARI(:~[/font]

  miriyalasrihari

  1 replies

  14 years, 2 months ago

  By: barsuk

• How to remove distinct clause from processing cube

  hi... i'm newbie to the ssas ... my problem is i want to add the nvarchar field i.e wchar field in…

  vinayak.v

  4 replies

  14 years, 2 months ago

  By: vinayak.v

• Role Security to deny members

  I have 3 roles setup. I have removed all member except for my domain login. I have setup deny attri…

  matt.newman

  2 replies

  14 years, 2 months ago

  By: alanmoore

• Need to show all dimension values

  Hi All, I need to show all dimension values in cube report even if those are not present in fact ta…

  neeta.chander

  2 replies

  14 years, 2 months ago

  By: neeta.chander

• SSAS role security on measure with scope statement - Reply ASAP

  role security cant be applied on calculated measure so i created calculated measures from this link…

  abc144

  2 replies

  14 years, 2 months ago

  By: matt.newman

• Calculated Measure using Grand Total

  Hi, Could you please help me with the MDX for calculated measure below? When the user selects a shi…

  umas

  9 replies

  14 years, 2 months ago

  By: umas

• Cube Update Processing Job is Successful but unable to browse reports. Manually processed the cube and everything works fine, Why?

  Hi, SQL Server 64 bit, SSAS 2005. Since last several days, the SSIS package job to update the SSAS …

  iBar

  1 replies

  14 years, 2 months ago

  By: c_m_kim

• SSAS (.abf) backup information set

  Hi, is possible to retreive backup set information from a backup file for SQL Server Analysis Servi…

  sgovoni

  1 replies

  14 years, 2 months ago

  By: suskno@saif.com

• Calculations based on Dimensional values

  I have a dimension called Clients I have a dimensional property called [Clients].[User Count] I als…

  mtassin

  7 replies

  14 years, 2 months ago

  By: mtassin

• How to avoid aggregations for the measure?

  I have a problem designing a cube, probably it is simple for experienced people. To simplify idea, …

  Vitik

  5 replies

  14 years, 2 months ago

  By: Basit

• SSAS handling measure differently on month or year level

  situation: -SSAS 2008R2 -need for a calculated measure -the measure must show the sum of its value …

  jvanderlouw-960980

  4 replies

  14 years, 2 months ago

  By: jvanderlouw-960980

• The datasource , ''local - SRDB'', contains an ImpersonationMode that that is not supported for processing operations.

   get the below error when i try to process my cubes: The datasource , 'local  - SRDB', co…

  winston Smith

  9 replies

  14 years, 3 months ago

  By: William McQuinn

• MDX for Today's date

  All Can anyone help me with the syntax for Today's date? I need to add it as slice information for …

  ProKelly

  3 replies

  14 years, 3 months ago

  By: happycat59

• aggregate on two dimensions

  How is possible to aggreagate with the avg respect two dimension? How is possible to aggreagate (by…

  matarese.nicola

  2 replies

  14 years, 3 months ago

  By: matarese.nicola