Query don't appear in BI Connector

41 Views

Hi all,

We are running SSM 7.5 SP8.

Until now we created several querys to import in bica without problems, but now we have one query that donu2019t appear in bica...

(we activated the option: allow external access to the query)

One detail: In PAS, if I try to connect to the query, donu2019t appear the query details:

Schema> view cube rowset full cube 'ZTR_TRAF/PILOT_TR_040_2'

CATALOG_NAME SCHEMA_NAME CUBE_NAME CUBE_TYPE CUBE_GUID CREATED_ON LAST_SCHEMA_UPDATE SCHEMA_UPDATED_BY LAST_DATA_UPDATE DATA_UPDATED_BY DESCRIPTION IS_DRILLTHROUGH_ENABLED

Schema> end

But if I execute the same command to other query appear the details:

Schema> view cube rowset full cube 'ZTR_TRAF/TR_040'

CATALOG_NAME SCHEMA_NAME CUBE_NAME CUBE_TYPE CUBE_GUID CREATED_ON LAST_SCHEMA_UPDATE SCHEMA_UPDATED_BY LAST_DATA_UPDATE DATA_UPDATED_BY DESCRIPTION IS_DRILLTHROUGH_ENABLED

ZTR_TRAF - ZTR_TRAF/TR_040 CUBE {00390044-0045-00 2005-09-21 15:08:13.000000000 2008-06-25 15:34:48.000000000 TESTE 2011-05-07 20:38:08.000000000 - TESTE 0

What is the problem? What is missing in my query?

Thanks.

Miguel