Thursday, March 8, 2012

Cubes missing from Excel picklist

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="urnTongue Tiedchemas-microsoft-com:xml-analysis">
<root xmlns="urnTongue Tiedchemas-microsoft-com:xml-analysis:rowset" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsdTongue Tiedchema targetNamespace="urnTongue Tiedchemas-microsoft-com:xml-analysis:rowset" xmlnsTongue Tiedql="urnTongue Tiedchemas-microsoft-com:xml-sql" elementFormDefault="qualified">
<xsd:element name="root">
<xsd:complexType>
<xsdTongue Tiedequence minOccurs="0" maxOccurs="unbounded">
<xsd:element name="row" type="row" />
</xsdTongue Tiedequence>
</xsd:complexType>
</xsd:element>
<xsdTongue TiedimpleType name="uuid">
<xsd:restriction base="xsdTongue Tiedtring">
<xsdStick out tongueattern 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>
</xsdTongue TiedimpleType>
<xsd:complexType name="xmlDocument">
<xsdTongue Tiedequence>
<xsd:any />
</xsdTongue Tiedequence>
</xsd:complexType>
<xsd:complexType name="row">
<xsdTongue Tiedequence>
<xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsdTongue Tiedtring" />
<xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsdTongue Tiedtring" minOccurs="0" />
<xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsdTongue Tiedtring" minOccurs="0" />
<xsd:element sql:field="CUBE_TYPE" name="CUBE_TYPE" type="xsdTongue Tiedtring" 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="xsdBig SmileateTime" minOccurs="0" />
<xsd:element sql:field="LAST_SCHEMA_UPDATE" name="LAST_SCHEMA_UPDATE" type="xsdBig SmileateTime" minOccurs="0" />
<xsd:element sql:field="SCHEMA_UPDATED_BY" name="SCHEMA_UPDATED_BY" type="xsdTongue Tiedtring" minOccurs="0" />
<xsd:element sql:field="LAST_DATA_UPDATE" name="LAST_DATA_UPDATE" type="xsdBig SmileateTime" minOccurs="0" />
<xsd:element sql:field="DATA_UPDATED_BY" name="DATA_UPDATED_BY" type="xsdTongue Tiedtring" minOccurs="0" />
<xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsdTongue Tiedtring" 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="xsdTongue Tiedtring" minOccurs="0" />
<xsd:element sql:field="BASE_CUBE_NAME" name="BASE_CUBE_NAME" type="xsdTongue Tiedtring" minOccurs="0" />
<xsd:element sql:field="CUBE_SOURCE" name="CUBE_SOURCE" type="xsd:unsignedShort" minOccurs="0" />
</xsdTongue Tiedequence>
</xsd:complexType>
</xsdTongue Tiedchema>
</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