Analysis Services

• Topics

  Started by

  Posts

  Last post

• Problems executing Sql Agent job

  Hey! I have problems with my Sql job. When i am trying to process my ssas project (there is 3 cubes…

  a.aalto

  5 replies

  15 years, 7 months ago

  By: spaghettidba

• Problems with security in SSAS

  I have security problems with connecting to SSAS from BIDS as well as SSMS. If I try to deploy a pr…

  SQL Guy 1

  24 replies

  15 years, 7 months ago

  By: MostInterestingMan

• Analysis Service Admin - Day to day responsibilities

  i am trying gather some info on how do SSAS admin maintain cubes. I would appreciate if someone can…

  curious_sqldba

  1 replies

  15 years, 7 months ago

  By: gsc_dba

• MDX LastPeriods function works very slow

  Hi There, I have a query to show the customers for the last 7 days ending on a certain date. So, I …

  msharma 63918

  1 replies

  15 years, 7 months ago

  By: gsc_dba

• Passing parameters into MDX

  Hi, I have query like as shoen below, its working fine. but when i am trying to pass a parameter an…

  suresh.muppidi

  2 replies

  15 years, 7 months ago

  By: gsc_dba

• Help needed to optimize the MDX query

  Hi, I am working on a requirement where I need to extract data from cube and load it into a grid.…

  luisoliveira

  1 replies

  15 years, 7 months ago

  By: danielagger98

• Named Set

  Hi I need to create a Named set (Flag), which will take date from the table (DB_Date) and compare i…

  nitin.guglani

  2 replies

  15 years, 7 months ago

  By: Koen Verbeeck

• If i remove the Promary key constratint from the dimension, will it do any harm while processing the cube.

  After processing the cube once , i removed the primary key constraint from one of my dimension tabl…

  nitin.guglani

  1 replies

  15 years, 7 months ago

  By: Koen Verbeeck

• Is there a .net control for Ad-Hoc Reporting against SSAS?

  Hi, I wonder, if there is a control, that i can embedd in a .net application and would allow user t…

  Tobias Kiemes

  3 replies

  15 years, 7 months ago

  By: Raunak Jhawar

• SSAS Installation Recommendations

  I'm new to SSAS and have never used it or installed it. I understand SSAS can be installed on its …

  CavyPrincess

  2 replies

  15 years, 7 months ago

  By: CavyPrincess

• When I process the cubes and got SQL syntax error, how can I fix that ?

  I am new to SSAS, when I connected to Analysis Services thru SSMS, I expanded the databases, and ri…

  yu_wai

  1 replies

  15 years, 7 months ago

  By: jaciesla

• Problem with Linear regression

  Hi there I am trying to do a linear regression based on the most recent 6 months that have data Thi…

  Bad dog

  5 replies

  15 years, 7 months ago

  By: RonKyle

• Linear Regression

  Does SQL Server or Analysis Services have the ability to do Linear Regression? If yes, how do I do …

  tygun

  3 replies

  15 years, 7 months ago

  By: RonKyle

• ERROR: Subquery returned more than 1 value

  Hi, I have the following named calculation in Data Source View (Sql Server 2008) (SELECT data FROM…

  cafc

  8 replies

  15 years, 7 months ago

  By: cafc

• Order By for dimension

  I have a dimension table with 2 columns - ID (the PK, an INT) and Description (Char()). I want to d…

  Paul McCurdy

  3 replies

  15 years, 8 months ago

  By: Hari.Sharma