on 06-24-2009 5:41 PM
Is it possible to create a Universe object to support the following SQL query:
SELECT * FROM (SELECT ROWNUM rownum1 FROM TABLE) WHERE rownum1 = (SELECT (MAX(ROWNUM)) FROM TABLE)
for every query you create in the webi, you have an objects showing how many rows has been returned by this query. i dont remember the name and i dont have an access to the system now, but i'm sure there is one like object or function like this.
i think its NumberOfRows(Query 1), it returns the number of rows in "Query 1"
just give it a try.
good luck
Amr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Venessa,
It would be easy to do as either a Derived Table in your universe or as a view in your database.
Thanks,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.