Axis in MDX

By
roopesh.valluru
-
123
15579

Friends,

Most important function of MDX is AXIS. The Axis function returns a set of tuples on the specified axis. PFB syntax of AXIS function.

“Axis(Number)”

Number – is a valid numeric expression which specifies the axis number.

The position starts from 0 and it can be continued as the cube database data is MULTI dimensional. MDX query is capable of returning data in more than two dimensions but our systems doesn’t support it. As our systems support only up to two dimensions, our MDX queries will stick to two AXIS only. For example, Axis(0) returns the COLUMNS axis, Axis(1) returns the ROWS axis, and so on. The Axis function cannot be used on the filter axis. The Axis numbers should be in order. You cannot use AXIS(1) without defining AXIS(0). PFB the sequence –

AXIS(0) or simply 0 – Columns

AXIS(1) or simply 1 – Rows

AXIS(2) or simply 2 – Pages

AXIS(3) or simply 3 – Sections

……….

……….

You can use any format to define AXIS like AXIS(Number) or Simply Number or with name like columns,rows,pages .. PFB sample queries of all three kinds –

Using AXIS –

select [Measures].[Sales Amount] on Axis(0),
[Dim Product].[Products].[Products] on Axis(1)
From [Adventure Works]

Using Number –

select [Measures].[Sales Amount] on 0,
[Dim Product].[Products].[Products] on 1
From [Adventure Works]

Using Name –

select [Measures].[Sales Amount] on Columns,
[Dim Product].[Products].[Products] on Rows
From [Adventure Works]

For all the above three queries the result set is same and the screenshot of the same is shown below –

That’s the complete story about AXIS function and hope you understood the concept. Happy Coding !!

Regards,

Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

123 COMMENTS

  1. critical thinking in writing
    [url=”https://criticalthinking2020.net”]critical thinking and problem solving examples[/url]
    another word for critical thinking

  99. Best bitcoin games are trendy because of Bitcoin’s high level of security. Bitcoin games offer progressive Bitcoin jackpots that expand with every game. A casino offering games does not ask to share personal details and this is something the players want. The customer support team at Bitcoin sites is quite quick and responsive, and Bitcoin payment methods allow fast deposits and instant withdrawals (within minimum withdrawal limits). No, not all gambling sites accept deposits by Bitcoin. Check our complete guide for the best Bitcoin gambling sites where you can deposit from your crypto wallet. Some of the sites also accept other coins as well. One of the key advantages to using a Bitcoin sportsbook to wager on sports is that Bitcoin payments are fast. So, we look for Bitcoin betting sites that can deliver payouts in under 48 hours in most cases. Some of the best Bitcoin sports betting sites, like Bovada and BetUS, can pay out the same day you request a withdrawal. https://africacancerhub.com/forum/profile/beiaustin273661/ Though Bitcoin and other cryptocurrencies do not have a solid legal basis in Canada, the organisation won the second split of the Brazilian League of Legends Championship. There will often be six reels and, making the modality represent 31% of all earnings. As a result, you can use the bar found at the bottom of the screen to change your bet. Land-based bitcoin casinos offer an exciting environment, the state-owned crypto lottery Danske Spil was the only entity with a valid license allowing it to legally offer cryptocurrency gambling services to Danes. According to various reports, casinos that accept cryptos as a form of payment make over $150 million in profit over those who don’t. This is a clear sign that the future of virtual currencies in gambling is veritably bright. Another advantage that Bitcoin and other crypto have is that they do n’t bear any gambling license for the casino to have in order to use them.

  113. [url=https://over-the-counter-drug.com/#]over the counter arthritis medicine[/url] over the counter viagra substitute

  123. [url=https://over-the-counter-drug.com/#]diuretics over the counter[/url] best sleeping pills over the counter

LEAVE A REPLY

Please enter your comment!
Please enter your name here

9 + 1 =