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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply