Analysis Services

• Topics

  Started by

  Posts

  Last post

• Date value associated with a max value of a measure at the lower level.

  Hi, Looking for an mdx statement to get a member value of a Hierarchy corresponding to the MAX val…

  JayKur

  1 replies

  11 years, 1 months ago

  By: Ashok Teotia

• Total Count

  Hi All, I would like to know how to get the sum in MDX Query for the below T-sql query . I took Exa…

  rkrishnamurthi

  1 replies

  11 years, 1 months ago

  By: Ashok Teotia

• out of memory error from excel

  Hi guys, Having a bit of an issue at a client. When pulling a report in excel, as long as the date …

  Ian C0ckcroft

  4 replies

  11 years, 1 months ago

  By: Ian C0ckcroft

• 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

  11 years, 1 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

  11 years, 1 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

  11 years, 1 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

  11 years, 1 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

  11 years, 2 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

  11 years, 2 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

  11 years, 2 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

  11 years, 2 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

  11 years, 2 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

  11 years, 2 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

  11 years, 2 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

  11 years, 2 months ago

  By: BGM