Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by BSosa
-
Calculated member within a hierarchy
Hello, I have a [Product] dimension that is a hierarchy of product groups, sub-groups and families. I've created a few calculate members, such as: With Member [Product].[Product 1] as '[Product].[ProductLongName]' Along with that, I've created a calculated measure that returns a product's... -
Selecting/Ranking Top Items
Hello, I have a question about writing an SQL query. I have a table with the following fields (amongst others): City Store SalesDollars There are 10 cities, with each city containing 100+ stores, each with a SalesDollars numeric value. 1) How do I write a SELECT statement that will return...
