Analysis Services

• Topics

  Started by

  Posts

  Last post

• MDX -> Problems with ranking in this query, any ideas on why the rank always returns nulls for both prev and current?

  I think I am just missing something small, but can't seem to put my finger on it.....Hopefully a di…

  UserSmith

  1 replies

  13 years, 7 months ago

  By: UserSmith

• MDX -> What is the best way to splice the below set via a date?

  I am creating a set of data that ranks customers by their revenue. I can do this fairly easily. : …

  UserSmith

  3 replies

  13 years, 7 months ago

  By: Martin Schoombee

• SSAS opinion needed

  Hi everyone I am looking at creating an online reporting platform, but just want some input to see …

  Jako de Wet

  6 replies

  13 years, 7 months ago

  By: Sam Vanga

• How SSAS use TempDB and how to redue size of log file?

  Hi All, I try to check how SSAS use Tempdb and how to reduce size of SSAS log file? In my cas…

  jarupan

  1 replies

  13 years, 7 months ago

  By: Sam Vanga

• Client-side cube browsing application

  Does anyone have a recommendation for a thin client-side cube browsing application with similar abi…

  Erin Ramsay

  6 replies

  13 years, 7 months ago

  By: herladygeekedness

• Creating a dimension with User Defined Hierarchy - Browser showing repeated data

  Im creating my time dimension and I am adding a user defined hierarchy because Im told this is the …

  Debbie Edwards

  2 replies

  13 years, 7 months ago

  By: Debbie Edwards

• major differences between SQL 2008 R2 SSAS and Cognos

  so we have a few old cognos servers and we will need to go 64 bit soon since we're collecting a lot…

  alen teplitsky

  5 replies

  13 years, 7 months ago

  By: alen teplitsky

• Checking the number of SSAS get access(connection) for 1 month

  Hi All, Does anyone know how to check number of access to SSAS cube in 1 month? Please provide …

  jarupan

  1 replies

  13 years, 7 months ago

  By: Sam Vanga

• User is authentication as "anonymous login"

  I have a user who cannot refresh their reports. I ran a profiler trace and can see they are hitting…

  winston Smith

  1 replies

  13 years, 7 months ago

  By: winston Smith

• Large Dimension

  Hi All, I have a large dimension, with approximately 60, 000 records and a growth rate of 1600 a da…

  mulukenn

  8 replies

  13 years, 7 months ago

  By: Martin Schoombee

• Degenerate dimension with empty cells?

  We had an issue where some data was not loaded into the relational side of our data warehouse aroun…

  Don Halloran

  1 replies

  13 years, 8 months ago

  By: RonKyle

• MDX x Reporting Services: Month order incorrect when using Cube data

  Hi there, I created a very simple report using SSAS [Adventure Works DW 2008R2] and SSRS, to show o…

  labj123

  2 replies

  13 years, 8 months ago

  By: labj123

• Sybase varchar(10000) to SQL varchar(Max) getting problem in SSIS package only for 64 bit Machine.

  Hi All, i am transfer the data Sybase to SQL that time i am getting problem where ever varchar(max)…

  pkkrao1

  1 replies

  13 years, 8 months ago

  By: Mackers

• New partition takes a long time to process (AS 2000)

  anyone still using analysis services 2000? each year i add a new partition to our cubes for the new…

  jsqldba

  1 replies

  13 years, 8 months ago

  By: jsqldba

• Dimension error : Rigid relationships between attributes cannot be changed during incremental processing of a dimension

  Hi, I have a dimension DimCustomer which has only two Attributes DimCustomerKey(int),Segment(char(1…

  manivannan.kariamal

  3 replies

  13 years, 8 months ago

  By: Martin Schoombee