Wednesday, March 25, 2015

MDX Interview Questions

  1. How do I find thebottom 10 customers with the lowest sales in 2003 that were not null?
  2. How in MDX querycan I get top 3 sales years based on order quantity?
  3. How do youextract first tuple from the set?
  4. How do youcompare dimension level name to specific value?
  5. MDX query to getsales by product line for specific period plus number of months with sales
  6. How can I setupdefault dimension member in Calculation script?
  7. I would like tocreate MDX calculated measure that instead of summing children amounts,useslast child amount?
  8. How to calculateYTD monthly average and compare it over several years for the same selectedmonth?
  9. MDX query to getsales by product line for specific period plus number of months with non emptysales?
  10. How do I groupdimension members dynamically in MDX
  11. How can I comparemembers from different dimensions that have the same key values?/Lets say Ihave dimensions [Delivery Date] and [Ship Date]. How can I select just recordsthat were Delivered and Shipped the same day?
  12. How can I getattribute key with MDX?
  13. How do I create aRolling 12 Months Accumulated Sum (InternetSalesAmtR12Acc) that can show atrend without seasonal variations?
  14. How to setup calculated measure as default measure for a cube?
  15. How can I write MDX query for the count of customers for whom the earliest sale in the selected time period (2002 and 2003) occurred in a particular Product Category
  16. How do you write MDX query that returns measure ratio to parent value?
  17. What MDX functions do you most commonly use?
  18. How in MDX query can I get top 3 sales years based on order quantity?
  19. How do you extract first tuple from the set?
  20. How can I setup default dimension member in Calculation script?

No comments:

Post a Comment