Top 10 Customers, Vendors in SSAS

Question

Hello

I am very new to SSAS

I have been given assignment

to get top 10 across all dimentions for some measures in  current year, last year , specific year, and overall which wil be supplied as filter

Top 10

Vendors        Salewise,  purchasewise, salereturn%, prevous stockwise , profitwise, margin

Customers    Salewise,  purchasewise, salereturn%, prevous stockwise , profitwise, margin

Products       Salewise,  purchasewise, salereturn%, prevous stockwise , profitwise, margin

Designs          Salewise,  purchasewise, salereturn%, prevous stockwise , profitwise, margin

 have measures and dimentions made for all above indicators

I dont know how to approach this assignement,

i can calculate it with mdx  querey  but individually like top 10 vendors as per sale  but dont know how to make measure of this and how should i approach,

Should i bring querey directly in SSRS dateset as we usually do.

Kindly help me in this problem

i willl be privillaged.

With Regards

---

Asrar

Answer 1

SELECT 
       [Measures].[Sales] ON COLUMNS,
       TOPCOUNT([Customers].[Customer Name].[Customer Name].MEMBERS, 10, [Measures].[Sales]) ON ROWS
FROM Sales

Getting the top 10 is as per above - what you would then do is change the Measure, and the dimension you are pulling the top 10 from to get the other 3

---

Josh Ash