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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

display random sample

Status
Not open for further replies.
akaka

akaka

Programmer
Dec 15, 2004
9
US
Is there a was to display only a random sample of just say 100 rows from a result set of 10 milliom rows

thanks
Atul Kakade
 
Sort by date Sort by votes
what type of distribution would you want from these 100 million rows?
 
Upvote 0 Downvote
nothing particular
Functionality soemthing like teraminer random sample
 
Upvote 0 Downvote
nothing particular
Functionality something like teraminer random sample
 
Upvote 0 Downvote
check out technote TN4100-72X-0210 "How to create a report that returns a random sample of data in MicroStrategy."

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

szeiss
  • Locked
  • Question
Display FY2011 instead of FY-1 in Report
Replies
0
Views
152
szeiss
szeiss
jadr
  • Locked
  • Question
Line graph displays too much data
Replies
0
Views
74
jadr
jadr
mstrpup
  • Locked
  • Question
Displaying single date when metrics filtered by two diff date attr
Replies
2
Views
122
mstrpup
mstrpup
teccum
  • Locked
  • Question
Date Prompt Display
Replies
0
Views
54
teccum
teccum
Rambo2292468
  • Locked
  • Question
Attribute decimal display
Replies
1
Views
80
FLB
FLB

Part and Inventory Search

Sponsor

Back
Top