Analysis Services

• Topics

  Started by

  Posts

  Last post

• column should be a measure or dimension attribute

  I have to show the count of new customers. I have a customer dimension and related fact table. My q…

  diwakarjha.80

  9 replies

  10 years, 10 months ago

  By: sergio.rocchetti

• Calculated measures in SSAS cube development

  Hi, I encountered an issue with calculated measures in SSAS cube development. Thank you in advance …

  old_cool

  2 replies

  10 years, 10 months ago

  By: old_cool

• Drillthrough in excel

  Hello, I have an issue when trying to drill through in excel. I have a fact table of employee termi…

  kreierson 17259

  2 replies

  10 years, 10 months ago

  By: kreierson 17259

• Allow users to access my local instance

  Hi, I have a local instance of SSAS running that I want to make available to users across the netw…

  hurrican3p

  5 replies

  10 years, 10 months ago

  By: hurrican3p

• Case Statement for SSAS Dimension's using mdx

  Hi Guys, I have designed a cube, Now I want to filter Dimension's data using Case statement. Here i…

  bhushan_juare

  4 replies

  10 years, 10 months ago

  By: sdreddy.sql

• Full year / YTD & YTG and stitching together different measure groups to make one continuous version

  Hi everyone, First post in here about this so here goes. We use MS Dynamics Nav as our ERP and I'm …

  Tattysnuc

  7 replies

  10 years, 10 months ago

  By: Tattysnuc

• Calculate the No. of Days for the Date period selected using MDX

  Hi ALL, I need help on one the requirements where i need to find the no of days for the Date p…

  Guitar_player

  19 replies

  10 years, 10 months ago

  By: Guitar_player

• the database cannot be attached because an error occurred while loading the detach log

  I can not atachar database analysis services. "the database can not be attached Because an error oc…

  rodrigo.carrasco.e

  2 replies

  10 years, 10 months ago

  By: Eirikur Eiriksson

• Tabular Model Memory Issues

  I have a tabular-model which has recently started to run out of memory when the job that performs t…

  Simon-220850

  2 replies

  10 years, 10 months ago

  By: Simon-220850

• Pull in Most Recent Visit Date MDX (SSAS)

  I am attempting to pull in the most recent visit date based on a cube containing claims data and am…

  jhanson 2516

  4 replies

  10 years, 11 months ago

  By: jhanson 2516

• Calculating MODE (most common number in a set)

  Is there a way to calculate the MODE in SSAS? I see there are Microsoft provided functions for Medi…

  adaltonveloso

  1 replies

  10 years, 11 months ago

  By: PB_BI

• Semi-Additive over Date AND Time Dimensions?

  Hi, I am continually thinking that this must be possible... but how do you do semi-additive measure…

  BGM

  1 replies

  10 years, 11 months ago

  By: BGM

• How to start DAX Editor ?

  Hi all. I downloaded DAX Editor from codeplex site, ran installation, closed and opened my Visual S…

  SQL Guy 1

  3 replies

  10 years, 11 months ago

  By: PB_BI

• Cannot connect to SSAS 2012 - the connection timed out. (microsoft.analysisservices.adomdclient)

  Had a real pain in installing SQL 2012 developer on Windows 8. Most of it seems to be working but w…

  Ells

  5 replies

  10 years, 11 months ago

  By: Ells

• SSAS 2012 Drillthrough Doesn't Return all Values

  I have an issue where sometimes a DrillThrough does not return a record for all values. I found thi…

  jhanson 2516

  1 replies

  10 years, 11 months ago

  By: jhanson 2516