Analysis Services

• Topics

  Started by

  Posts

  Last post

• Error in System Log: "The SQL Server Analysis Services (xxxxxx) service terminated unexpectedly. It has done this x time(s)."

  My SSAS service stopped twice today with this message in the System Log: The SQL Server Analysis S…

  Marios Philippopoulos

  1 replies

  15 years, 5 months ago

  By: Marios Philippopoulos

• Is there any downside of using a named query in SSAS

  Hi, I have to create 3 measure to my existing cube and I was wondering if it is a good idea to use …

  Karen Roslund

  2 replies

  15 years, 5 months ago

  By: Karen Roslund

• One Dimension table, multiple foreign keys to Fact Table

  Hello, My fact table contains the columns "key_1_id" and "key_2_id". My dimension table contains th…

  ganeshmuthuvelu

  3 replies

  15 years, 5 months ago

  By: Daniel Bowlin

• invalid column while processing 'DEFAULT' partition of a measure group

  I am trying to deploy a cube using the Deployment Wizard. In the Wizard I choose "Retain Partition…

  Ken Ross-344285

  2 replies

  15 years, 5 months ago

  By: Ken Ross-344285

• Drilling down only for a subset of another dimension on the same axis

  this is my current query: Select non empty ( DrillDownMember( [ Incident].[Incident Date Year - …

  wchan 64207

  1 replies

  15 years, 5 months ago

  By: wchan 64207

• Issue accessing cube file

  Hi, One of the users reported the below error "File system error: Error opening file; "\\?\C:\Progr…

  karthik -450760

  6 replies

  15 years, 5 months ago

  By: karthik -450760

• SQL Server 2005 - Rollup with distinct (Help)

  Folks, I realize that group by rollup for distinct values in SQL Server 2005 is not supported. Can…

  Ashish Kumar-1095774

  1 replies

  15 years, 5 months ago

  By: brdudley

• How to transform table with few rows to one row?

  Hi, I am beginner.Just an example. If I have table with 3 rows and 3 columns: customer number n…

  Jagger-784276

  5 replies

  15 years, 5 months ago

  By: John McC

• CANNOT CONNECT TO THE REPOSITORY

  Dear All, From last weak onwards we were not able to establish a connection to the Analysis server.…

  jishar

  3 replies

  15 years, 5 months ago

  By: Koen Verbeeck

• Can I intall Analysis Services on Vista?

  Hi there, I have SQL Server 2008 Developer edition. Is it possible to install this on Vista ultima…

  pablavo

  3 replies

  15 years, 5 months ago

  By: pablavo

• Refresh Data Source view

  Hi All, I have created a data source view in SSAS project connected to some tables in database x. A…

  Baskar B.V

  1 replies

  15 years, 5 months ago

  By: randy.jaye

• How to process OLAP cube using T-SQL

  Hi, Pls let me know if anyone knows "How to process OLAP cube using T-SQL Stored procedure" Thanks…

  sntiwary

  1 replies

  15 years, 6 months ago

  By: Dirk Wegener

• AS2008 - Change settings (Process) does not keep changed settings

  According to hint "Do not ignore duplicate key errors." ( http://technet.microsoft.com/en-us/librar…

  ThoseWhereTheDays

  2 replies

  15 years, 6 months ago

  By: ThoseWhereTheDays

• Parent-child dimension alternative

  Hello I am a newbie on Analysis Services so be patient. I manage to build an accountable cube which…

  DouglasAcosta

  2 replies

  15 years, 6 months ago

  By: DouglasAcosta

• Problem starting SSAS 2005

  Setting: Windows 2003, SP1. Box member of workgroup. Clean install of Sql 2005, installed as instan…

  Barkingdog

  9 replies

  15 years, 6 months ago

  By: bijayanix24