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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BSosa
  • Order by date
  1. 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...
  2. BSosa

    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...

Part and Inventory Search

Back
Top