So i just received a connection string to a Cube in our one of our SQL databases. I'm supposed to create a report that can be emailed to 30 something people off of this data.
I would much rather write a stored procedure and just let SSRS send it out whenever its supposed to. The problem is that the database is extremely complex and I'm not sure I can match everything up and get the correct information.
Is there anyway that I can write a store procedure that will look at the information in a cube?
I'm not sure if this matters but the database and the cube are on the same SQL server.
Any information about cubes would be helpful. I know that they to some pre-calculations based on what they will probably be used the most for.
Thanks