Display # 5 10 15 20 25 30 50 100 All

MDX-How do I clear Analysis Services (SSAS) database cache?

Written by Vidas Matelis on 15 May 2007.

MDX-How do you specify SCOPE For Dimension to include all members after certain member

Written by Vidas Matelis on 28 March 2007.

MDX-How do you specify SCOPE For Dimension to include all members before certain member

Written by Vidas Matelis on 28 March 2007.

MDX-How do you calculate monthly average of one year, optionally including empty months?

Written by Vidas Matelis on 14 April 2007.

MDX-How do you compare dimension level name to specific value

Written by Vidas Matelis on 27 March 2007.

MDX-How do you extract first member from the tuple?

Written by Vidas Matelis on 27 March 2007.

MDX-How do you extract first tuple from the set?

Written by Vidas Matelis on 27 March 2007.

MDX-How do you format or round KPI expression value?

Written by Vidas Matelis on 07 May 2007.

MDX-How do you get Last month in the time dimension

Written by Vidas Matelis on 27 March 2007.

MDX-How do you make calculated measure to be default cube measure

Written by Vidas Matelis on 08 April 2007.

MDX-How do you write query that returns measure ratio to parent value?

Written by Vidas Matelis on 24 April 2007.

MDX-How do you write query that uses execution date/time (NOW()) as a parameter?

Written by Vidas Matelis on 15 April 2007.

MDX-How to create a SCOPE statement based on the Member property

Written by Vidas Matelis on 28 March 2007.

MDX-How to create calculated member for AVG sales over last 3 years based on NOW()?

Written by Vidas Matelis on 03 May 2007.

MDX-How to execute query from SQL Server

Written by Vidas Matelis on 02 April 2007.

MDX-How to use the Filter function in a SCOPE statement

Written by Vidas Matelis on 28 March 2007.

MDX-I would like to create calculated measure that instead of summing children amounts,uses last child

Written by Vidas Matelis on 17 April 2007.

MDX-Query example that returns list of months from start of year up to specified month

Written by Vidas Matelis on 03 April 2007.

MDX-Query to get count of months with sales amount > 0 in defined period

Written by Vidas Matelis on 05 April 2007.

MDX-Query to get latest months and previous years same months data

Written by Vidas Matelis on 03 April 2007.

• 17
• 18
• 19
• 20
• 21
• 22
• 23