Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using MS Excel to access OLAP cube partition
Thanks for the clarification. The problem to resolve is when users are viewing cube data from MS Excel there is a requirement to restrict or filter the data to that specific user is allowed to view. It sounds like dimension security may be one option, are there any others? Again, when MS Excel...- wkenny
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Using MS Excel to access OLAP cube partition
Hi, I have a SQL 2000 cube with 5 partitions, one partition includes all locations (dimension) and 4 others are filtered by location. These location filters are needed to filter the cube for ease of use and security reasons. I am trying to find a way to use MS Excel to access a specific OLAP...- wkenny
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
