derived table in XIR2 - Informix

[system]

I think you may not be able to create derived tables in certain release levels of informix…version 11 does it

120×120 10.4 KB

Hello, This is my first post, as I am a new Business Objects user! I am creating a Universe which includes two tables: Circuit and District. Both tables are included in the Universe I am building. I want to create a Derived Table which contains each circuit and the number of districts for each circuit. When I enter the following SQL into the Derived Tables SQL Expression textfield and click the Check Syntax button: SELECT jfactdba.circuit.circuit, count(jfactdba.district.district) as …

I created views based on the proposed derived table SQL

---

jemstar (BOB member since 2006-03-30)