Search code examples
ssas

From ssas multidimensional cube, How to get top sales from factsales by salesPoint and month

I am using SSAS Multidimensional cube.I have factsales and two dimdate,dimsalespoint table. I need to show top sales every month by sales point.Also i need to show this data into power bi.My cube brower will be look like July salespoint1 1254 Aug Salespoint2 2589 Sep SalesPoint3 85236. Per month which sales point sales high. It will also filter year, product etc. Can any one help me.

Solution

  • I think that you can do this with only PowerBI

    You juste need to drag you sales infos and select max aggreagate and filter them by month and salespoint.

    In powerBI you connect to your cube enter image description here

    you drag and drop your salesvalue and select the matrix visual enter image description here

    you use salespoint in row , date in column and salesvalue in values

    enter image description here

    You can select a max aggregate on your values enter image description here

    You'll get something like this : enter image description here

    and you can navigate in the date hierarchy by using the arrow on the top right

    enter image description here

    If you use a live connexion with an OLAP cube. You can replace you max in powerBI by doing these step :

    enter image description here

    and select max enter image description here

    you then have to use this measure in the powerBI report because it will be based on your table filtered by what you put in the visual(date, salespoint,...)