No announcements
Found 1689425 threads
-
0 VotesMDX Calculation on a Measure for different dates
Is there a good site with MDX samples?Answered | 5 Replies | 4741 Views | Created by amir tohidi - Thursday, November 11, 2010 2:18 PM | Last reply by amir tohidi - Friday, November 12, 2010 11:51 AM
-
3 Votes
MDX - Calculate measure in date buckets
Simplistic answer if its only one query..Answered | 7 Replies | 1956 Views | Created by Koen Verbeeck - Monday, August 1, 2016 10:04 AM | Last reply by Koen Verbeeck - Wednesday, August 3, 2016 9:01 AM -
0 Votes
Aggregate MDX calculated measure
The base for the calculation is also a calculated measure, which depends on other calculated measures ...Answered | 6 Replies | 1117 Views | Created by renezmar - Tuesday, January 20, 2015 2:12 PM | Last reply by yger - Tuesday, January 20, 2015 3:11 PM -
0 Votes
MDX using Two IF condition in Same Calculated Measures
Basically you have 2 possibilities: 1) Create a physical measure (can be bound to any measure field) and provide a scoped cell ...Answered | 2 Replies | 5780 Views | Created by MS308 - Wednesday, July 25, 2012 4:15 PM | Last reply by Pavel Pawlowski - Thursday, July 26, 2012 9:07 AM -
0 Votes
mdx to calculated measure
[Date],[Measures].Answered | 3 Replies | 4365 Views | Created by RahulKiwi - Wednesday, June 23, 2010 5:20 AM | Last reply by Scott.X.Lu - Thursday, June 24, 2010 1:17 AM -
1 Votes
Calculate the measure in mdx code
&[2012-10] ,[Measures].Answered | 1 Replies | 2925 Views | Created by BandSr - Friday, March 23, 2012 9:44 AM | Last reply by Suhas Kudekar - Friday, March 23, 2012 9:54 AM -
0 Votes
MDX - Calculated measure over date dimension
As I said initially, I am trying to come up with the MDX that will populate the exprression pane in the "New Calculated Member" of a cube.Answered | 7 Replies | 6167 Views | Created by JeffCAS - Saturday, November 27, 2010 1:46 PM | Last reply by Deepak Puri - Monday, November 29, 2010 8:21 PM -
1 Votes
SSRS Report MDX DataSet: Getting Calculated Measures' Names and their values
Please refer following MDX query SELECT { [Measures].Answered | 2 Replies | 4230 Views | Created by Joss83 - Thursday, January 5, 2012 12:35 PM | Last reply by Sandip Shinde - Thursday, January 5, 2012 1:07 PM -
0 Votes
Calculated measure problem in mdx
darin try out this MDX SELECT [Measures].Answered | 5 Replies | 5842 Views | Created by darim - Wednesday, May 5, 2010 3:22 PM | Last reply by Avinob Roy - Wednesday, May 5, 2010 8:54 PM -
0 Votes
Changing MDX calculated measure in calender year
I have successfully calculated '[max used previous months value]'¨using below mentioned MDX.Answered | 6 Replies | 995 Views | Created by MahAdv - Thursday, December 7, 2017 10:47 AM | Last reply by MahAdv - Friday, January 19, 2018 8:33 AM -
3 Votes
MDX Calculated Measure.
I have quite a lot and creating calculated fields for every scenario would be a bit too cumbersome.Answered | 5 Replies | 1140 Views | Created by PentAgraMm - Tuesday, March 21, 2017 5:03 AM | Last reply by PentAgraMm - Wednesday, March 22, 2017 10:35 PM -
0 Votes
Mdx to get the Expression of a calculated Measure
Just click on your calculated measure i.e.Answered | 7 Replies | 2961 Views | Created by Anandh_SG - Tuesday, April 3, 2012 4:20 AM | Last reply by Darren Gosbell - Tuesday, April 3, 2012 6:42 AM -
0 Votes
Dynamic Calculated measure in MDX
You can't evaluate a member name as an expression in MDX.Answered | 2 Replies | 966 Views | Created by BharathRS - Friday, May 8, 2015 4:30 PM | Last reply by Darren Gosbell - Monday, May 11, 2015 12:00 PM -
0 Votes
MDX - EXCEPT in Calculated Measure
&[11] is specific group of material which need to be excluded from calculations if 5 of 6 categories are shown.Answered | 3 Replies | 19112 Views | Created by JesseO - Friday, October 29, 2010 6:56 PM | Last reply by Elvar - Saturday, March 12, 2011 9:40 PM -
0 Votes
Calculated Measure Question in MDX
Hi Victor, You can use the IIF function: WITH MEMBER [Measures].Answered | 1 Replies | 4391 Views | Created by Victor Xiao - Tuesday, May 25, 2010 7:35 PM | Last reply by Boyan Penev - Wednesday, May 26, 2010 1:04 AM -
0 Votes
MDX Sytax for SSAS Calculated Measure using "OR"
Set up a big CASE statement in your MDX Expression window: CREATE MEMBER CURRENTCUBE.Answered | 3 Replies | 2505 Views | Created by kayluhh - Tuesday, August 7, 2012 7:37 PM | Last reply by Todd C - Tuesday, August 7, 2012 8:21 PM -
0 Votes
MDX equivalent of DAX YTD measure
but without the MDX for the actual measure incorporating the periods to date, i cannot make it work because i'm a total MDX noob.Answered | 8 Replies | 1240 Views | Created by PentAgraMm - Monday, January 15, 2018 1:27 AM | Last reply by RichardLees - Tuesday, January 23, 2018 5:14 AM -
0 Votes
Create Calculated Measure with MDX and Where Clause
The Exchange Rate measure can be put into the MemberExpression of Sales measure so that you don't need to create a calculated measure.Answered | 1 Replies | 879 Views | Created by ColacoCT - Saturday, June 11, 2016 2:13 PM | Last reply by Simon_Hou - Monday, June 13, 2016 8:43 AM -
0 Votes
Date of a max value in measure
Hi Baracus , You just need to filter your days with the Max value .. adding an AdventureWorks example : With member [Measures].Answered | 1 Replies | 734 Views | Created by BI_Baracus - Wednesday, February 18, 2015 10:46 AM | Last reply by David Harazi - Wednesday, February 18, 2015 3:57 PM -
3 Votes
MDX Calculation
Generally, when working with MDX, I try to get a query scoped calculation working first before migrating the calculation to the calculations tab of the ...Answered | 8 Replies | 4150 Views | Created by Dz0001 - Friday, March 16, 2012 2:32 PM | Last reply by Martin Mason - Tuesday, March 27, 2012 12:15 AM - Items 1 to 20 of 1689425 Next ›
No announcements
