heyinlangley
Programmer
Has anyone been able to link to an Analysis Services cube using Access?
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!
Access connection to Analysis Services
- Thread starter heyinlangley
- Start date
- Status
heyinlangley,
Do you mean calling a cube report from, say, an Access form?
the Microsoft BI/DW community
Do you mean calling a cube report from, say, an Access form?
the Microsoft BI/DW community
Create a connection via Data Sources in the Control Panel in Administrative Tools, then add mdb drivers. The Analysis Manager Concepts and Tutorial will help walk you through creating the connection.
I am currently using a Cube based off an access query, then using the Cube to create pivot tables. However, when I process the query it is very slow when I have more than 5 dimensions. Is there a better way to create a faster detailed cube?
I am currently using a Cube based off an access query, then using the Cube to create pivot tables. However, when I process the query it is very slow when I have more than 5 dimensions. Is there a better way to create a faster detailed cube?
- Status
Similar threads
- Locked
- Question
- Locked
- Question