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: *

  1. mikeG77

    Top 10 List?

    Hi, This MDX-statement should solve your problem: select { [Measures].[YOUR_MEASURE] } on columns, TOPCOUNT (CROSSJOIN({ [region].[all region].children }, { [geography].[zip].members }),10,[Measures].[YOUR_MEASURE]) on rows from YOUR_CUBE
  2. mikeG77

    mdx-problem: how can i get 2 levels from 1 dimension

    Hi, this is my problem: On rows i got a dimension with 3 levels, for example: year, month and day and on columns a measure like 'quantity'. now i´d like to write an mdx-query with a result like this: |quantity| |2001| January |...

Part and Inventory Search

Back
Top