Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error using Rank function in Answers

ImtiazSep 2 2010 — edited Sep 9 2010

Hi All,

Am trying to generate a report in Answers which lists Top Accounts with Revenue.

I Ranked the Revenue field and it is returning me correct values. ( Rank(account.revenue) )

But, when I try to filter on this field and restrict the rows which shows only top 10 Accounts, it is returning the following error:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1792, message: ORA-01792: maximum number of columns in a table or view is 1000 at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

Can any one help me on this.

Thanks in Advance,

Imtiaz.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2010

Added on Sep 2 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

16 comments

1,967 views