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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

OVER partition in measure


 
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
frank35
Principal Member
Principal Member



Joined: 25 Aug 2005

Posts: 401
Location: London


flag
PostPosted: Wed Jun 12, 2019 4:49 am 
Post subject: OVER partition in measure

I have created a measure that requires using OVER(partition by dimension a, dimension b). However when I run the query I get a GROUP BY error. Is there a way around this? Do I need to redefine the measure / is there a universe parameter that needs changing/adding?

thanks

BOE 4.1 SP5
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11460
Location: Manchester, UK


flag
PostPosted: Mon Jun 17, 2019 9:11 am 
Post subject: Re: OVER partition in measure

What group by error do you get?

I tend to build ranking in a query condition.

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
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.0292 seconds using 17 queries. (SQL 0.0026 Parse 0.0009 Other 0.0258)
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