### MDX calculation Expected value

call that portfolio. What we would like to achieve is knowing for the current portfolio the expected value. Meaning that for example for salesperson x, I want to ...
| 4 Replies | 2320 Views | Created by BramDe - Thursday, October 4, 2012 9:34 AM | Last reply by BramDe - Thursday, October 4, 2012 2:50 PM

### Problem in MDX query for calculating total sales.

of the customers.  - The expected output is 2 values of sales ,one for all male customers and other for all female ...
| 2 Replies | 5299 Views | Created by jaee83 - Friday, March 9, 2007 3:04 PM | Last reply by jaee83 - Saturday, March 10, 2007 5:43 AM

### Converting Attribute to Integer for calculation

FROM [Adventure Works] Error I get for the calculated cell: CellOrdinal    ...
| 1 Replies | 2635 Views | Created by AaronLST - Tuesday, September 20, 2011 4:46 PM | Last reply by Sorna Kumar Muthuraj - Tuesday, September 20, 2011 5:09 PM

### Cube calculation order with a not commutativity calculated measure

, shows the value right calculated. My problem is... if the user define a calculated member in his query, example WITH MEMBER ...
| 2 Replies | 4496 Views | Created by santiago16 - Saturday, February 27, 2010 4:19 PM | Last reply by santiago16 - Tuesday, March 2, 2010 2:59 AM

### How Is the Following Calculated Member Interpreted? Getting Unexpected Results...

for [invoice date_key] but have a value for [Margin \$].  I guess I assumed or expected that those would be filtered out and that the MDX would ultimately mimic the SQL ...
| 0 Replies | 7843 Views | Created by JawKnee - Wednesday, December 7, 2005 9:38 PM

### Rows not part of MDX result-set showing up with aggregate information

the Data tab, I get the expected results, with all the aggregation working correctly. However, when I run the report additional rows appear that are performing aggregation and interfere with ...
| 0 Replies | 3885 Views | Created by Kenneth Cottle - Wednesday, September 3, 2008 7:12 PM

In MDX, a union is usually performed on a Set of attribute members, not on measures - but I suppose this is possible.  Without seeing your data or an example of the current and ...
| 2 Replies | 4371 Views | Created by nijojo - Saturday, March 21, 2009 10:30 PM | Last reply by nijojo - Sunday, March 22, 2009 10:59 PM

### Applying Non-Empty on All-To-Date calculation (MDX/SSAS)

([Type].[Type].[ATD]);   THIS = AGGREGATE({NULL: [Time].[Date].CURRENTMEMBER},[Type].[Type].[Actuals]); END SCOPE; Basically it calculates as ...
| 2 Replies | 525 Views | Created by MichaelMDX - Monday, March 7, 2016 7:12 AM | Last reply by MichaelMDX - Monday, March 7, 2016 9:42 AM

### CASEing ParallelPeriod by weeks for a special situation

Thanks...the fix makes sense when you see it... ...however I am getting a !Value error when I use that calculated member. The error
| 3 Replies | 3840 Views | Created by Ludis - Friday, September 5, 2008 3:42 PM | Last reply by Deepak Puri - Monday, September 8, 2008 4:35 PM

### Newbie MDX question - calculated measure

(doesn't work).  I get NULL values for the Merchants with no payments during the month (expected), but for the ones WITH payments I always get 1.#INF.  I believe that ...
| 1 Replies | 4220 Views | Created by Erik Dahl - Wednesday, November 4, 2009 3:51 PM | Last reply by Raymond-Lee - Monday, November 9, 2009 5:02 AM

### MDX calculation slice not working as expected

Ehm, I didn't know you were expecting that value for N too. Which confuses me. Since you have just two members on that dimension, C and N, when do you expect False case of ...
| 10 Replies | 3746 Views | Created by Stefan Z. _ - Wednesday, January 13, 2010 7:13 PM | Last reply by Tomislav Piasevoli - Friday, January 15, 2010 11:24 AM

### MDX Calculated Measure Grouped by dimension

Hi all, I'm very new to MDX, so working through things slowly and trying to understand how I can do certain things. Currently I have a ...
| 2 Replies | 428 Views | Created by JKB71 - Friday, September 29, 2017 2:35 PM | Last reply by JKB71 - Monday, October 30, 2017 6:46 PM

### Is it possible to create a cube that totals specified data together?

In AS2000 you would probably start delving into the realms of customising the dimension itself. As such, you can either add MDX that wil calculate what you want based on a given ...
| 5 Replies | 4245 Views | Created by shkrbby - Monday, March 29, 2010 3:14 PM | Last reply by Philip Stephenson - Thursday, April 1, 2010 3:17 PM

### SSAS Grand Total based on the Last Dimension attribute from the Pivot.

Hello Team, Good Morning. With respect to the Our Business team, we do have requirement to show the EMPTY values as zero. With respect to that, we have applied below the ...
| 1 Replies | 683 Views | Created by Kumar Pradeep M - Monday, August 1, 2016 5:29 PM | Last reply by Simon_Hou - Tuesday, August 2, 2016 7:52 AM

### Scope MDX

Hi, I am using SSAS solution and have few semi-additive measures added with MDX formulas that looks like: CALCULATE(SUM([cumulative_members]), ...
| 1 Replies | 446 Views | Created by Sonam P - Thursday, March 3, 2016 6:31 AM | Last reply by Alexei Stoyanovsky - Tuesday, March 8, 2016 7:54 AM

### Calculated member from SSAS stored procedure

Hello, I am trying to create a calculated member from analysis services stored procedure. The below statement returns me the expected ...
| 2 Replies | 2370 Views | Created by Palash Aich - Tuesday, September 11, 2012 2:02 PM | Last reply by Palash Aich - Wednesday, September 12, 2012 4:15 PM

### MDX Exists with Filter

those rows. I am expecting the sum of [Measures].[Met] values  of only filtered rows (i.e. rows with [Measures].[row_num] =1 values) but MDX is returning SUM ...
| 2 Replies | 643 Views | Created by Aniruddha Thengadi - Saturday, March 3, 2018 2:35 PM | Last reply by Aniruddha Thengadi - Sunday, March 4, 2018 8:21 AM

### Help needed with parameterized MDX for YTD calculations

Hi,       I need to calculate the YTD values for fiscal years using the parameterized MDX expression.My fiscal hierarchy looks ...
| 2 Replies | 3822 Views | Created by krishna.v - Monday, August 23, 2010 9:08 PM | Last reply by nairgokul - Monday, August 23, 2010 10:02 PM