stored procedures - SQL - Query Cubes -

So I just received a connection string in a cube in one of our SQL databases. I should prepare a report that can be emailed to 30 people with this data.

I expect to write a stored procedure and just send it to SSRS whenever it needs. The problem is that the database is extremely complex and I am not convinced that I can match everything and get the right information.

Is there anyway that I can write a shop procedure which will see the information a cube?

I'm not sure this is the case but the database and the cube are on the same SQL Server.

Any information about cubes will be helpful, I know that they are based on some pre-calculations that they will probably be used for the most.

Thanks