Home Forums Data Warehousing Analysis Services Creating lists from multiple dimensions where there is no logical count RE: Creating lists from multiple dimensions where there is no logical count

  • SSAS is really meant for higher-level, aggregated type of work. There are a couple of ways to get to these "lists" and each have their pros and cons....

    1) You could create a Drillthrough Action on the cube which will contextually display details of a particular aggregated cell.

    2) You could create the things you want to see in a list as properties of an attribute of a dimension so they can be queried or ignored as is needed.

    ...moving away from SSAS...

    3) You could create these reports in SSRS directly from your data warehouse and then link to the reports from the cube using a Report action.

    Without knowing your exact setup it's difficult to say which one will be right for you (and I'm sure there are other approaches - these are just the ones I have used personally).


    I'm on LinkedIn