August 19, 2011 at 11:46 am
I had a reqier ment as shown
Hierarchy Country.States.City and the measure in Population
I need to get top 5 countries and top 5 States . By using Population as Measure How can i get it.
....
Second one
I am getting #error only at AllSum(total) in my report I headrd that Summing Nulls with 0 is the cause for that is there any other reasons for that
August 26, 2011 at 5:51 am
Run using something like
SELECT [Measures].[POPULATION] ON ROWS,
Topcount([Hierachy].[Country States].[City],5,[Measures].[POPULATION]) on Columns,
FROM [YOURCUBE]
August 28, 2011 at 11:52 pm
Run following query
Select [Measures].[Population] ON Columns,
Topcount ([Hierachy].[Country States].[City].Members, 5, [Measures].[Population]) on Rows
From [Cube]
Use NonEmpty function to resolve the Second Query nd let me know
August 29, 2011 at 12:02 am
bhushan_juare (8/28/2011)
Run following querySelect [Measures].[Population] ON Columns,
Topcount ([Hierachy].[Country States].[City].Members, 5, [Measures].[Population]) on Rows
From [Cube]
Use NonEmpty function to resolve the Second Query nd let me know
Isn't that exactly what I had put?!? ha!
August 29, 2011 at 3:04 am
I think, u didn't.
August 30, 2011 at 3:48 pm
This will return the top 5 populous countries sorted in DESC order, followed by the top 5 States/Provinces (in the world) in the same DESC order.
SELECT [measures].[population] on Columns,
{SUBSET(ORDER([heirarchy].[states].members, [measures].[population], BDESC),0,5)
, SUBSET(ORDER([heirarchy].[country].members, [measures].[population], BDESC),0,5)
} on Rows
FROM [cube]
Viewing 6 posts - 1 through 5 (of 5 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