Meta Data Search option "in all" is missing for package.
Missing search option in CAFE.
This is caused by multiple data sources set for Package.
In a particular case a cube package was published from Framework Manager 8.4.1 and migrated to 10.1.1 using deployment. Although not used there was a second data source set up in the FM project and the package had this second data source associated.
Diagnosing the problem
In Cognos Connection use the link "More..." and then "View the package data sources..." to evaluate whether there is a second data source associated to this package.
Resolving the problem
* Remove the second data source from the Package by republish the package again in Framework Manager 10.1.1 without a second data source.
* Publish the package from Transformer 10.1.1 without second data source.
* Publish the package by connecting the cube to the 10.1.1 environment and use the upcoming package publish dialog.
More support for:
Cognos Analysis for Microsoft Excel
Analysis for Excel
Software version: 10.1.1
Operating system(s): Windows
Software edition: All Editions
Reference #: 1614040
Modified date: 12 October 2012