Início > Functions > How do I?

How do I?

 have seen developers searching for a last minute MDX query / script to create a calculated member on the cube. Many start in an organized fashion with a start from some simple MDX tutorial, and learning tuples, namedsets, axis, MDX Select Query Syntax etc… But still after that, many queries remain unsolved, and the real answer comes after a hands-on experience of some real-time project when one really starts applying functions, tweaking or nesting queries and parameters.
Any material found in MDX should be treasured. By far I have just seen 3-4 books on SSAS flavor of MDX. Below are the links to code-snippets which are FAQ’s or used frequently while either querying the cube or creating calculated members on the cube.

 

Hope this helps all the last minute MDX requirements of those developers who don’t have time to spend in learning all the syntax, structure and theory behing MDX syntax just to solve a little query or requirement on a cube in production or last-minute patch.

 

 

Download MDX Tutorial – Code Snippets of Various FAQ Queries (PDF)

Download MDX Tutorial – Code Snippets of Error Handling (PDF)

Download MDX Tutorial – Cope Snippets SCOPE statement (PDF)

    1. MDX – How do you get Last month in the time dimension
    1. MDX – Query example that returns list of months from start of year up to specified month
    1. MDX – Query to show the first day of the last date month in the cube
    1. How in the report can I order date dimension members in descending order?
    1. MDX – query to get the last Month loaded into a cube
    1. MDX – Query to get the first month of the last year loaded into a cube
    1. MDX – How do you write query that uses execution date/time ( NOW() ) as a parameter?
    1. MDX – Query to get latest months and previous years same months data
    1. MDX – Query to show year level data for all years except last one, and month level data for last year
    1. MDX – How to create calculated member for AVG sales over last 3 years based on NOW()?
    1. MDX – How do I calculate sales for 12 Month to date?
    1. MDX – How can I get Last (Previous) Year to Date (YTD) values?
    1. MDX – Query to get count of months with sales amount > 0 in defined period

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

  1. MDX – How do you calculate monthly average of one year, optionally including empty months?
Categorias:Functions
  1. Ainda sem comentários.
  1. No trackbacks yet.

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s

%d bloggers like this: