May 2, 2018 at 3:17 pm
I cannot find any reference to the 5 default axes definitions
I know that 1 and 2 are on columns and rows, but I cannot
find any reference that tells what a Pages reference in On Pages
May 2, 2018 at 7:25 pm
According to BOL:
<SELECT query axis clause> ::= [ NON EMPTY ] Set_Expression [ <SELECT dimension property list clause> ] ON Integer_Expression | AXIS(Integer) | COLUMNS | ROWS | PAGES | SECTIONS | CHAPTERS
Here's the reference: https://docs.microsoft.com/en-us/sql/mdx/mdx-data-manipulation-select?view=sql-analysis-services-2017
I would recommend using the integer values (0..5) instead, as it's easier to remember and decode.
May 9, 2018 at 12:52 am
gfm - Wednesday, May 2, 2018 3:17 PMI cannot find any reference to the 5 default axes definitions
I know that 1 and 2 are on columns and rows, but I cannot
find any reference that tells what a Pages reference in On Pages
0 and 1 are columns and rows, respectively, 2 is Pages.
Aside from the already mentioned BOL reference, there is a discussion about using the Pages axis here: https://www.ptr.co.uk/blog/sql-server-mdx-working-more-two-axes
But, as it notes, only 0 and 1 are recognised by SSMS and only two at a time are recognised by SSRS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply