Analysis Services

• Topics

  Started by

  Posts

  Last post

• help with dupicated values in dimension and facts

  I have a situation in DWH where one of the dimension is not loading properly which is product dime…

  Sachin4all

  2 replies

  14 years, 7 months ago

  By: VALEK

• Role totalling problem

  Hi there. I've created a role and limited certain dimension attribute members so that users can onl…

  Bunx

  1 replies

  14 years, 7 months ago

  By: Daniel Bowlin

• Deploying first Cube and failing

  Hi I am new to SSAS and I have been working through the microsoft online tutuorials to build and de…

  Mark F-428640

  10 replies

  14 years, 7 months ago

  By: MichaelBrown

• Connection string property to SSAS 2008

  Dear All, Due to pooer performance we have migrated all the cubes from SSAS 2005 to SSAS 2008 64-bi…

  Gangadhara MS

  1 replies

  14 years, 8 months ago

  By: Koen Verbeeck

• 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 months ago

  By: Basit