February 25, 2015 at 8:09 am
Hi Experts,
I have a mdx query that give me headach.
I have an hierarchy Clients like this
Region -> Country -> City -> Clients
With my actual query I have this
Country City Measure
France Paris 10
Nice 50
England London 80
Manchester 100
And what I want to add a total(Country) in my query to obtain this
Country / City / Measure
France / Paris / 10
France / Nice / 50
England / London / 50
England / Manchester / 100
Total / Country / 210
Can U help me ?
February 25, 2015 at 9:02 am
Re All,
I tried this
SELECT NON EMPTY {[Measures].[MyMeasure]} ON COLUMNS,
NON EMPTY {
Hierarchize (
Generate (
[Client].[Client Hierarchy].[country ]
, ascendants ( [Client].[Client Hierarchy].CURRENTMEMBER )))
) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
from MyCube
That's work well but it's very slow.
And My "All Member" is null.
Do you know how I can rename the "All member" ??
Thanks U in advance
February 25, 2015 at 9:29 am
Lidou123 (2/25/2015)
Re All,I tried this
SELECT NON EMPTY {[Measures].[MyMeasure]} ON COLUMNS,
NON EMPTY {
Hierarchize (
Generate (
[Client].[Client Hierarchy].[country ]
, ascendants ( [Client].[Client Hierarchy].CURRENTMEMBER )))
) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
from MyCube
That's work well but it's very slow.
And My "All Member" is null.
Do you know how I can rename the "All member" ??
Thanks U in advance
Instead of all the above, just do <Hierarchy>.<Level>.allmembers which will return all members including the "All" level (which is the total you want)
February 25, 2015 at 10:20 am
Thank you Sir.
I tried this and that's work well.
But I dont't know why my [ALL MEMBER] is null.
Do you know I can rename it like ' All Clients' ??
February 25, 2015 at 10:29 am
Lidou123 (2/25/2015)
Thank you Sir.I tried this and that's work well.
But I dont't know why my [ALL MEMBER] is null.
Do you know I can rename it like ' All Clients' ??
There should be a property for the "ALL" member. Check your dimension properties in SSDT.
February 25, 2015 at 10:37 am
OK. But I have not possibilities to have the SSAS solution.
But I can't do it in my report ?
It's only for a report !!!!!!!!!
February 25, 2015 at 10:47 am
Lidou123 (2/25/2015)
OK. But I have not possibilities to have the SSAS solution.But I can't do it in my report ?
It's only for a report !!!!!!!!!
The "ALL" member usually comes to SSRS as an empty string, so use an expression to test for that and rename as you wish.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy