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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLAP Drill down in Microsoft OLAP server. 3

Status
Not open for further replies.
afzalz

afzalz

Programmer
Aug 17, 2000
6
GB
How do I drill down form the the cube to the Underlying transactional data in Microsoft OLAP server???? [sig][/sig]
 
Sort by date Sort by votes
The OLAP cube is only supposed to contain aggregates. For getting down to the transactional data, query your datamart database directly AND NOT the cube.
[sig][/sig]
 
Upvote 0 Downvote
Can't do in SQL 7, but can do in SQl 2000 - Have a look at the Microsoft site for the difference.

Fiona.

Fiona Williams


 
Upvote 0 Downvote
thanks,

looks like I need to upgrade.


Can I run Analysis services on SQL Server 7.0??
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vktrez
  • Locked
  • Question
Best OLAP Tools 1
Replies
1
Views
501
fominlena
fominlena
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
489
dcern
dcern
josmi
  • Locked
  • Question
OLAP modeling: one cube versus many cubes?
Replies
7
Views
585
blom0344
blom0344
Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
470
Vary88
Vary88
Malbordio
  • Locked
  • Question
ODBC in PHP to connect to ServiceNow
Replies
1
Views
532
k5tm
k5tm

Part and Inventory Search

Sponsor

Back
Top