I have got a SSAS Cube, we have written an windows application which would issue MDX queries to access the data from the cube and show it in the reports .
This windows application is a licensed application, meaning only those who have got license from us could be able to run the application and then could be able to access the data from the cube.
The problem we are having is what some unlicensed users tries to access our cubes through other cube browser application like Excel.
so we are generally wondering how to protect the cubes and data present in the cube so that only who has got license to our application could be able to access.
Could anyone please advise that how to give this type of security to SSAS database?