BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

DISTINCT_VALUES Parameter in IDT - Can this be disabled?


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Blowers
Senior Member
Senior Member



Joined: 30 Sep 2009

Posts: 94



PostPosted: Fri Jan 10, 2020 10:04 am 
Post subject: DISTINCT_VALUES Parameter in IDT - Can this be disabled?

Is there an option to delete or disable the DISTINCT_VALUES Parameter in IDT? Currently it is set to DISTINCT on my universe, the only other option I have found is to change this to GROUPBY. I would like to remove this DISTINCT option if possible as I am not getting all rows displayed in webi for sql server table - I want to see the duplicate row in my reporting.

Thanks! icon_biggrin.gif
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002

speaker.gif*16
Posts: 22161
Location: Dallas, Texas


flag
PostPosted: Fri Jan 10, 2020 4:31 pm 
Post subject: Re: DISTINCT_VALUES Parameter in IDT - Can this be disabled?

The Distinct or Group By clause is used only for LOV queries. It does not impact what you are describing.

In Web Intelligence there is a setting on the table (block) that says something like "Avoid duplicate row aggregation." Turn that on and you will stop Webi from aggregating your data.

_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2019-09-19 Stephen Few Blog Post on Multivariate Visualization
• 2019-02-11 Update on Query Banding
• 2018-10-19 BI Evolution
Back to top
Blowers
Senior Member
Senior Member



Joined: 30 Sep 2009

Posts: 94



PostPosted: Mon Jan 13, 2020 9:59 am 
Post subject: Re: DISTINCT_VALUES Parameter in IDT - Can this be disabled?

Ah okay, that makes sense. One further question on this, Is there a way to remove the GroupBy function being added in Business Objects - aside from editing the custom SQL?
I have rows of data, that look like duplicates - but are not actually duplicate rows, they are valid data, but business objects shows the distinct rows only.

I was able to achieve this by editing the custom SQL and removing GroupBy and then unchecking the Avoid duplicate row aggregation option in webi, but wondered if there was another way as changing custom SQL in webi is not ideal.
Thanks!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0278 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0241)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo