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.

Aggregate Aware Objects & Conditions


 
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
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Thu Aug 27, 1998 10:39 am 
Post subject: Aggregate Aware Objects & Conditions



I have run into a problem using the aggregate aware feature in BusinessObjects. We are at 4.1.2. I have created several aggregate aware objects and also set up the incompatible objects. When choosing the objects everything works as expected choosing either the summary or the detail table as needed. Where my problem comes in is with the predefined conditions I have set up that are based on those objects. The predefined condition references the aggregate aware object using the @select syntax. The predefined condition works properly if I have the aggregate aware object that it references in the query also. If it is not in the query I get an SQL sentance error. When I look at the SQL, the @aggregate_aware syntx is in the sql instead of the table and column name. Wondering if anybody else has this problem and/or if they have a solution?

Glenn Fredericks
Data Warehouse Specialist
glenn_fredericks@aal.org
(920) 730-4700 x4236 or 1-800 CALL AAL

Aid Association for Lutherans
4321 N. Ballard Road
Appleton, WI 54919-0001
Visit our Web site at www.aal.org or e-mail us at aalmail@aal.org

AAL... Financial services. Lutheran heritage. A powerful combination.


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Sun Aug 30, 1998 11:17 am 
Post subject: Aggregate Aware Objects & Conditions



Glenn,

I'm not sure you can use aggregate aware objects as an argument for @Select. I once tried to use @Select(AggregateAwareObject) in the SELECT part of an object, and I think "Parse..." whined something about this being illegal.

Maybe BO programmers forgot to check the same thing for the syntax of WHERE clause...

-Harri



_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Sep 04, 1998 9:08 am 
Post subject: Aggregate Aware Objects & Conditions



Glen,

>From my experience (up to BO 4.1.0) it is not possible to use the
aggregate aware function AT ALL in the WHERE part of the query. It simply doesn't get translated and SQL doesn't understand it off course.
>From the white papers you can read between the lines that the function
was invented for measure object (like revenue coming from different aggregations). Probably that is why the WHERE part got left out.

However I would appreciate it if BO got it to work for the WHERE part as well.

Greetings,
Marianne Wagt
IDETA
The Netherlands


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
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.0348 seconds using 17 queries. (SQL 0.0105 Parse 0.0008 Other 0.0234)
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