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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

[IDT 4.x] IDT Not creating GROUP BY clause on SUM Aggregation


 
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
PGO_AIM
Senior Member
Senior Member



Joined: 10 Nov 2006

Posts: 41
Location: Houston, TX


flag
PostPosted: Mon Apr 16, 2018 4:12 pm 
Post subject: IDT Not creating GROUP BY clause on SUM Aggregation

4.2 SP3 ....

SELECT
dm_fj_gstat_client_Payment.memberFirm,
dm_fj_gstat_client_Payment.companyCode,
SUM(dm_fj_gstat_client_payment.paymentAmtDocCurr)
FROM
dm_fj_gstat_client_payment

Why would the GROUP BY clause not get generated? I have DISTINCT_VALUES parameter set to GROUPBY.
-----------------------------------------------------------------------
The strange thing is, I have another class in SAME universe, which has measures, and when I select two dimensions and a measure from this class, the GROUP BY clause gets added to the built Select statement (see below)

Second Query from SAME universe:

SELECT
dm_fj_gstat_voucher.MemberFirm,
dm_fj_gstat_voucher.companyCode,
sum(dm_fj_gstat_voucher.glAmtDocCurr)
FROM
dm_fj_gstat_voucher
GROUP BY
dm_fj_gstat_voucher.MemberFirm,
dm_fj_gstat_voucher.companyCode
Back to top
MichaelWelter
Forum Aficionado
Forum Aficionado



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 14979
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way


flag
PostPosted: Tue Apr 17, 2018 12:42 pm 
Post subject: Re: IDT Not creating GROUP BY clause on SUM Aggregation

The DISTINCT_VALUES parameter has nothing to do with this. It is used only to determine how Lists of Values are generated.

Make sure that the object, SUM(dm_fj_gstat_client_payment.paymentAmtDocCurr), is defined as a measure.

_________________
Michael Welter, BOCP-BOE, Webi Image link
Looking for my next adventure
(909)899-3002

______________________
Follow me on Twitter

Latest Blog Posts
• 2016-02-02 Universe Design Best Practices
• 2015-11-05 Review of Information Design Tool 4.1
• 2015-04-29 Impact of a Database Migration
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.0102 seconds using 18 queries. (SQL 0.0031 Parse 0.0002 Other 0.0070)
CCBot/2.0 (http://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