to
indicate that it is different from namespaces containing other types
of metadata.IBM Cognos 8 supports many different types of data sources. The data source connection information may vary for each type of data source you use.
For detailed information about connections for specific data sources, see the IBM Cognos 8 Administration and Security Guide. If you require additional information about the parameters to connect to your specific data source, see the vendor documentation for the data source you are using.
In a Framework Manager model, catalogs and schemas are properties that are associated with a data source object. If present, these properties qualify any object that is generated in an SQL statement at run time.
When switching the data source against which a model is mapped, qualification levels are often removed. The Relational Database Management System (RDBMS) applies appropriate name space searches as it prepares the SQL statements it receives. Depending on the vendor, the RDBMS may look in up to two places to resolve a reference to an object. An error results if a reference cannot be resolved.
Framework Manager preserves the names of tables and columns as presented by the RDBMS. These names appear in generated Cognos SQL statements. Cognos uses quotes for the names to preserve case and to avoid conflicts with special characters or keywords.
IBM Cognos 8 supports OLAP data sources as
well as relational data sources. The term native metadata refers
to objects such as models, packages, and queries that are based
on an OLAP data source. A namespace that contains native metadata
uses this icon to
indicate that it is different from namespaces containing other types
of metadata.
OLAP data sources are metadata rich data sources. Explicit modeling for these data sources is not enabled in Framework Manager and the package is published directly to the portal. For more information, see Publish a Package Based on an OLAP Data Source.
Levels are created using the generation names in the labels. If you want to alter the way levels are named, you can do this by changing the dimension build settings in the application that generated the cube. For more information, see the vendor documentation.
Relational data sources require dimensional modeling to enable them to work in Analysis Studio and to work with drill capabilities in the other studios. For more information about dimensional modeling, see Dimensions.
If you installed IBM Cognos 8 components on UNIX servers,
we recommend that you also locate the file-based data source on
a UNIX server. You should then use a UNIX path, such as /servername/cubes/Great
Outdoors Company.mdc to access the file. For more information, see 
.
Compound packages contain both OLAP and relational metadata.
