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!

Can I turn off "Select Distinct" in ReportStudio?

Status
Not open for further replies.
cindyw

cindyw

Technical User
Jun 6, 2001
74
US
We have many large tables (50 million + rows). The automatic select distinct is killing us. Is there a way to get rid of this without giving users the ability to edit the sql?
 
Sort by date Sort by votes
Never mind...I figured it out. From Query Explorer, go to the Tabular Model properties. Go the line for "Auto Group and Summarize". Change this from the default "Yes" to "No".
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
256
tushargaurav
tushargaurav
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
280
NileshDhande
NileshDhande
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
221
deborahyr63
deborahyr63
NicolaTesla1
  • Locked
  • Question
Hi, Anyone has ever had issues w
Replies
0
Views
217
NicolaTesla1
NicolaTesla1
beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
302
beegeeblueboy
beegeeblueboy

Part and Inventory Search

Sponsor

Back
Top