Does Voyager supports drill-through for MSAS 2005?
Voyager user guide states "Drill-through capability is available only with Microsoft SQL Server 2000 Analysis Services or later data sources."
Does it mean that Drill-through for MSAS 2005 is supported or not?
Boudhaditya Priyaranjan Banerjee replied
Just a quick question. Are u logging in to BOE using the administrator rights or some user rights?
Also let us know if it is the same user or aministrator used for connecting to the MSAS2005 server. Excel by default uses the administrator rights to connect to the server so drill through is possible from excel.
Please check the user used for connecting to the MSAS2005 server has the permission to do drill through. This could be checked by checking the roles assigned to the cube.
1. Double click on the roles.
2. Click on the Cubes tab.
3. Give access to the drillthrough for the cubes required.
4. Save the cube and then process.
This should be enough.
let me know if you still face some issues.