Hi there,
Does anyone know what I can do when a list of cubes is not returned, even though there are cubes there? There is one database that contains a cube that does not show up in Excel, but I can browse data in Management Studio. I can see other cubes fine. Here are the results of XML to list cubes.
<return xmlns="urnchemas-microsoft-com:xml-analysis">
<root xmlns="urnchemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsdchema targetNamespace="urn
chemas-microsoft-com:xml-analysis:rowset" xmlns
ql="urn
chemas-microsoft-com:xml-sql" elementFormDefault="qualified">
<xsd:element name="root">
<xsd:complexType>
<xsdequence minOccurs="0" maxOccurs="unbounded">
<xsd:element name="row" type="row" />
</xsdequence>
</xsd:complexType>
</xsd:element>
<xsdimpleType name="uuid">
<xsd:restriction base="xsdtring">
<xsdattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
</xsd:restriction>
</xsdimpleType>
<xsd:complexType name="xmlDocument">
<xsdequence>
<xsd:any />
</xsdequence>
</xsd:complexType>
<xsd:complexType name="row">
<xsdequence>
<xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsdtring" />
<xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="CUBE_TYPE" name="CUBE_TYPE" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="CUBE_GUID" name="CUBE_GUID" type="uuid" minOccurs="0" />
<xsd:element sql:field="CREATED_ON" name="CREATED_ON" type="xsdateTime" minOccurs="0" />
<xsd:element sql:field="LAST_SCHEMA_UPDATE" name="LAST_SCHEMA_UPDATE" type="xsdateTime" minOccurs="0" />
<xsd:element sql:field="SCHEMA_UPDATED_BY" name="SCHEMA_UPDATED_BY" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="LAST_DATA_UPDATE" name="LAST_DATA_UPDATE" type="xsdateTime" minOccurs="0" />
<xsd:element sql:field="DATA_UPDATED_BY" name="DATA_UPDATED_BY" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="IS_DRILLTHROUGH_ENABLED" name="IS_DRILLTHROUGH_ENABLED" type="xsd:boolean" minOccurs="0" />
<xsd:element sql:field="IS_LINKABLE" name="IS_LINKABLE" type="xsd:boolean" minOccurs="0" />
<xsd:element sql:field="IS_WRITE_ENABLED" name="IS_WRITE_ENABLED" type="xsd:boolean" minOccurs="0" />
<xsd:element sql:field="IS_SQL_ENABLED" name="IS_SQL_ENABLED" type="xsd:boolean" minOccurs="0" />
<xsd:element sql:field="CUBE_CAPTION" name="CUBE_CAPTION" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="BASE_CUBE_NAME" name="BASE_CUBE_NAME" type="xsdtring" minOccurs="0" />
<xsd:element sql:field="CUBE_SOURCE" name="CUBE_SOURCE" type="xsd:unsignedShort" minOccurs="0" />
</xsdequence>
</xsd:complexType>
</xsdchema>
</root>
</return>
Any help is much appreciated!
This is just an empty result set. What was the query that you ran to get this?|||I resolved the issue.
No comments:
Post a Comment