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 Wanet Telecoms Ltd 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: justins57
  • Content: Threads
  • Order by date
  1. justins57

    Row ID for DataSet

    Does anyone know an easy way to include the Row Number in the dataset results? I am hoping to get something like this: Row Store Sales 1 NE #11 10,000 2 SE #3 200 3 WC #22 5,000 Thanks, Justin
  2. justins57

    Crossjoin Two Levels in a Dimension

    Hi, Is it possible to show two levels of a dimension in the rows? For Example, Product Group Product Unit Sales Dairy Milk $100 Cheese $50 Butter $25 Produce Apples $100 Tomatoes $75...
  3. justins57

    MDX - Avg Per Store

    Is it possible to iterate through a level above store to get the number of stores, aggregate for stores, and the per store averages for several measures shown in the columns? Example MDX below. WITH SET OrgSet as 'Descendants([Store].[All Stores].[USA], [Store].[Store State])' SET RowSet...

Part and Inventory Search

Back
Top