hello,

I have 3 questions regarding Analysis Server(AS) and its cube. I am
connecting to AS remotely; the server is also the SQL Server DB. I am
not creating the Cube locally.
1) When I create the cube and process it - Storage is MOLAP - it seems
the cube's data is stored on the remote servers as files - <cube
name>.data. I just want to confirm this. It isn't stored in a SQL
server Repository under a certain database and table?
2) Based on the 1st question, if the above is true then if another
computer whether using Report Services or AS accesses those files if it
wants to use the cube's data. Correct?

3) Is there a way to filter specfic data out of the cube? For Example,
I have a dimension which is a Timeseries(date) and I say I just want
data in the cube for year 2005. Can I process the cube with filters? If
so how?

thanks very much!