I am connecting to my SSAS cube through excel Pivot table. I have the following questions:
1) I have a filter for Company. However, instead of selecting multiple companies from a drop down list, I would like to have a range e.g. Company between 100 and 200. We have this "Filter expression and operator" option in SSAS but I dont see in excel.
2) I have 90 users who will be using my cube via pivot tables. How do I automatically have the data in excel refresh automatically such that when the user comes in, in the morning and open the pivot table, they have the refreshed data. Instead of them manually
refresh it as it runs the query for a long time.
Thanks in advance for all your help and suggestions!
View Complete Post