Excel add-in: invisible measures

I've a cube in Analysis Services 2005 with two measuregroups. Each group contains about 4 measures. Those measures are only used for making some calculated measures. Only the calculated measures have to be visible to the user. Whenever I put the property 'visible' on false for al the normal measures in the two measuregroups, the retrieval of the measures (selecting measures in dimension-tab) in excel-add-in takes too lang (more then one minute). The retrieval of the measures works fine in other front-en tools like proclarity.

Does anyone knows about this problem and knows a solution or a workaround?

Thanks,

ADL

Try to hide the measures you dont like to see using perspectives feature of Analysis Services.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Does Excel 2003 with PTS9 support perspectives?|||

The excel 2003 add-in for analysis services supports perspectives, but that gives no alternative:

It seems that I can't disable all measuregroups in a perspective. When you uncheck all measuregroups, the excel add-in will still show those measuregroups. The unchecking of just one measuresgroups works fine ?

By further investigation and looking at the profiler I noticed that the retrieval of de measures in Proclarity works fine, but the soapcall is somewhat different :

PROCLARITY : event subclass:MDXSCHEMA_MEASURES

<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><CATALOG_NAME>Demo Emmaus</CATALOG_NAME><CUBE_NAME>DWH Emmaus</CUBE_NAME></RestrictionList>

<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>Demo Emmaus</Catalog><MdxMissingMemberMode>Error</MdxMissingMemberMode><LocaleIdentifier>2057</LocaleIdentifier><DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility></PropertyList>

EXCEL ADD-IN : event subclass:MDXSCHEMA_MEASURES

<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><CUBE_NAME>DWH Emmaus</CUBE_NAME></RestrictionList>

<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>Demo Emmaus</Catalog><SafetyOptions>2</SafetyOptions><LocaleIdentifier>2057</LocaleIdentifier></PropertyList>

Is this giving anyone a clue of what can cause the long response time of retrieval of measures metadata in excel-add-in whenever the measuresvisibility is set to false?