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!
-
Excel OLAP "Excel cannot find OLAP cube Test02...."
Ok so I'm sorta just guessing because there isn't quite enough information: 1. Make sure you've fully processed the cubes your refering to, if they aren't done processing you won't be able to connect to them (I have this issue ALL THE TIME with my users). Quick test would be to browse some of...- corilynn
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Only One Distinct Count Measure?
You can create "virtual cubes" (available as a right click) that contain each of your cubes with one distinct measure. I have one cube for each distinct measure I need, then I've created a virtual cube combining all of the distinct cubes (as well as a few calculated measures) and all...- corilynn
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
