Sp_find

select * from Sys.sysobjects

select * from sys.dm_exec_objects

Sp_helpobjects

Analysis ,redo,undo

Redo.Analysis ,undo

Undo,analysis,Redo

Analysis,Redo,Recovery

SET XMLSTATS IO ON

SET STATISTICS TIME ON

SET STATISTICS I/O ON

SET STATISTICS IO ON

3

Depends on senario

2

1

auto

hash

entire

same

administrator

manager

designer

directror

ENV

$UNSET

$PROJDEF

None of the above

sequential file stage

File set stage

Lookup file set stage

Row generator stage

Constraints,Derivations,Stage variables

Derivations,Constraints,Stage variables

Stage variables,Derivations,Constraints

Any of the above

LeftOuter Join,Right Outer Join,Inner join

Outer Join,Inner Join

Left Outer Join,Inner Join

Left Outer Join,Right Outer Join

Automatically handle activities that fail

Add checkpoints so sequence is restartable on failure

Log warnings after activities that finish with status other than ok

Log report messages after each job run

Derivations,Stage variables,Constraints

Stage variables,Constraints,Derivations

Constraints,Stage variables,Derivations

Constraints,Derivations,Stage variables

Run the cube through the pcoptimizer utility that is shipped with Cognos 8 BI.

Enable the Allow dynamic usage of dimension information governor in Framework Manager.

Edit the EnablePCOptimizer entry in the Cognos.ini file so that its value=1, and then rebuild the cube.

Ensure that the Pass-through SQL setting is enabled onall regular dimensions in the Framework

Create relationships from date fields inone dimension to date fields in another dimension.

Use parameter maps to map date values in one query subject to date values in another query subject.

Use theTime Dimension wizard togenerate a time dimension and create the appropriate relationships.

Identify a time dimension table source, import into the model and create relationships to fact query subjects.

Using a different query subject icon for display inthe studios.

Viewing the properties of the query subjects in Report Studio.

Viewing the properties of the query subjects in Framework Manager.

Using the same name for the dimension in each star schema grouping.

Create regular and measure dimensions and set scope.

Create shortcuts to regular dimensions and fact query subjects.

Create star schema groupings for dimension and fact query subjects.

Create relationships between regular dimensions andmeasure dimensions.

Cognos 8 must be configured to use only one authentication provider at a time

Toperform authentication of users, a connection to the Cognos namespace must be defined

In Framework Manager, object security is implemented by defining access toobjects for users, groups and roles defined in theauthentication providers

In Framework Manager, object security is implemented by defining access toobjects for groups and roles (of which users are members), not individual users

BMTScriptPlayer.exe

pcaccel.exe

CubeSwap.bat

RSUpgrade.bat

Virtual star schema models require a time dimension for multi-fact queries.

Report authors cannot create multi-fact, time-based queries.

Time-based rollups for multi-fact queries may be difficult to handle.

Report authors cannot create multi-fact, time-based queries unless using a union.

Query items.

Data sources.

Relationships.

Parameter maps.