SQL Command Editor in DB02

[Former Member]

Hello Experts,

I am trying query a column values from a cube using DB02 SQL Editor. I am able to get data using standard table like RSDDIME ect. When I try to use underlying table from a given cube, it bombs. Here is what I tried:

Ex: select 0FISCPER from "/BIC/EZMM_C01". I tried prefixing the system ID and didn't work.

Getting ORA-00903 or 942  > Table doesn't exist or invalid table name.

Please shed some light.

Thanks

Ravi

[Former Member]

I appreciate you both for suggestions. Looks like authorization issue. Let me run with security team and confirm.

Thanks

Ravi

[fidel_vales]

Hi,

another reason could be that you are not authorized to query such tables.

The editor has passed several "versions/phases"

the last one does not allows you to query any table unless explicitly indicated (and in that case the suggestion from Yves would not work.

Check the following notes:

1568173 DBA Cockpit: Authorization object for SQL Command Editor

1755304 Authorization problems with Oracle SQL Command Editor

the origin of the SQL is not to query "customer" data. Use SE16 for that. Even SE16 is a "generic" DB access.

[ACE-SAP]

Hi

This is just because you do not provide the schema for the SAP object, the editor is mainly meant for accessing to Oracle ddic table.

try : select 0FISCPER from sapsr3."/BIC/EZMM_C01"

Regards