informer30
MIS
Hi All,
I am new to MS Excel and cubes. I do have MS Excel experience.
I working with MSAS 2005 and MS Excel 2007. I have brought across the cube via msexcel
connections.
I am trying to restrict the data by applying a filter on one of the fields, however I can only
apply the filter if the field is dragged across in the excel worksheet. This means I sit there
for 10 mins for the data to return and 99% of the time it times out. Is there a way I can apply
my filters and then after run query against the MSAS 2005.
Many Thanks
I am new to MS Excel and cubes. I do have MS Excel experience.
I working with MSAS 2005 and MS Excel 2007. I have brought across the cube via msexcel
connections.
I am trying to restrict the data by applying a filter on one of the fields, however I can only
apply the filter if the field is dragged across in the excel worksheet. This means I sit there
for 10 mins for the data to return and 99% of the time it times out. Is there a way I can apply
my filters and then after run query against the MSAS 2005.
Many Thanks