As I am sadly also fairly new to SSAS, I am currently on a project which requires some assistance in allowing users access to data in order to slice and dice data within excel.
Now I have managed to create a cube containing the relevant information required by business, however when users are working within excel and as an example an amount shows negative you are able to double click the amount and drillthrough to the detail. The problem is that users would like to see more detail i.e. invoice numbers, sales order numbers etc and not simply the data contained in the reference links.
Now, I see that using Drillthrough actions would potentially solve this problem however we are currently only using 2008 R2 Standard Edition and the use of semi-additives are restricted.
Are there any alternatives to providing the relevant non-aggregated data without having to upgrade to Enterprise Edition? Any expertise would be greatly appreciated!