Thursday, March 22, 2012

analysis serices, cubes and access

How to get data from cubes in analyses manager to MS access using for
example ODBC ? Does existe any other posibilities to get data from cubes
directly to the accees ?
thanks
KrisHow did you get them in cube format to begin with? If you mean transfer
the data from the underlying warehouse in SQL to Access you can use DTS.
The example that ships with AS (foodmart) is actually in Access, so you
can build cubes from data within Access. If this doesn't answer your
question, please elaborate.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sql

No comments:

Post a Comment