[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Optimizer goal
- Subject: [sqr-users] Optimizer goal
- From: "Ganesh, Muralidhar \(IE10\)" <Ganesh.Muralidhar@honeywell.com>
- Date: Fri, 2 Jun 2006 18:33:29 +0530
- Delivery-date: Fri, 02 Jun 2006 09:05:55 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: AcaGRPGYS8UJfjrKRKqkUpOYrkX+bw==
- Thread-topic: Optimizer goal
1) When I used the
Alter Session set Optimizer_goal = CHOOSE before all the SQL statements
in my reporting SQR the report data changed completely. Can any one give
the reason for this.
2) when I used the
Begin-select B-1000
EMPLID,
...
....
It gives a compilation error . Oracle 9i is the database for the
peoplesoft. What is the reason
Regards
Ganesh A.M
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users