Purchase your Section 508 Compliance Support guide now!

Purchase your Section 508 Compliance Support guide now!

The table published from Contributor doesn't contain data for any nodes that aggregate data from their subnodes

The table published from Contributor doesn't contain data for any nodes that aggregate data from their subnodes.
 
 
Resolving the problem
A view publish produces a number of different views for different purposes.

Specifically, fv_cubename does not contain data for aggregate nodes, it is designed for reporting tools that perform their own aggregation.

The ev_cubename view holds data for both aggregate and leaf nodes.

More details on the different views can be found in the 'Publishing Data' chapter of the Contributor Administration Guide.

The table published from Contributor doesn't contain data for any nodes that aggregate data from their subnodes

The table published from Contributor doesn't contain data for any nodes that aggregate data from their subnodes.
 
 
Resolving the problem
A view publish produces a number of different views for different purposes.

Specifically, fv_cubename does not contain data for aggregate nodes, it is designed for reporting tools that perform their own aggregation.

The ev_cubename view holds data for both aggregate and leaf nodes.

More details on the different views can be found in the 'Publishing Data' chapter of the Contributor Administration Guide.

Unable to change an attribute that has a fact usage to have no aggregate property.

Unable to change an attribute that has a fact usage to have no aggregate property. It is possible to change the regular aggregate, but you can't change the semi-aggregate.
 
 
This can be done by setting the attribute usage to unknown and then redetermining usage on the attribute

In the Project Viewer pane, select one or more query subjects. In the Properties pane, change the following values -

  • the Usage property to unknown.
  • the Regular Aggregate property to unsupported

From the Actions menu, click Determine Usage to leave the aggregate properties to unsupported.

Unable to change an attribute that has a fact usage to have no aggregate property.

Unable to change an attribute that has a fact usage to have no aggregate property. It is possible to change the regular aggregate, but you can't change the semi-aggregate.
 
 
This can be done by setting the attribute usage to unknown and then redetermining usage on the attribute

In the Project Viewer pane, select one or more query subjects. In the Properties pane, change the following values -

  • the Usage property to unknown.
  • the Regular Aggregate property to unsupported

From the Actions menu, click Determine Usage to leave the aggregate properties to unsupported.

Cognos .NET

Install Microsoft .NET Framework
Cognos 8 BI Analysis requires Microsoft .NET Framework version 2.0 to be installed on all user
computers.
When you install Microsoft .NET Framework in a non-English operating system, Microsoft .NET
error messages, shortcuts, and utilities appear in English.
For a language other than English, you can apply the Microsoft .NET Framework Language Pack
to view error messages, shortcuts, and utilities in the language of your operating system. For example,
if your operating system is French and you installed Microsoft .NET Framework, you must also
apply Microsoft .NET French Language Pack.
Steps
1. Go to the Microsoft download Web site, http://www.microsoft.com/downloads/.
2. Search for .NET Framework 2.0, select the redistributable package, and follow the instructions
to download it.
3. Check for other security updates that relate to .NET Framework 2.0 and download them.

Cognos .NET

Install Microsoft .NET Framework
Cognos 8 BI Analysis requires Microsoft .NET Framework version 2.0 to be installed on all user
computers.
When you install Microsoft .NET Framework in a non-English operating system, Microsoft .NET
error messages, shortcuts, and utilities appear in English.
For a language other than English, you can apply the Microsoft .NET Framework Language Pack
to view error messages, shortcuts, and utilities in the language of your operating system. For example,
if your operating system is French and you installed Microsoft .NET Framework, you must also
apply Microsoft .NET French Language Pack.
Steps
1. Go to the Microsoft download Web site, http://www.microsoft.com/downloads/.
2. Search for .NET Framework 2.0, select the redistributable package, and follow the instructions
to download it.
3. Check for other security updates that relate to .NET Framework 2.0 and download them.

Cognos Configuration

Update a Resource
After you add a new resource, such as a Cognos Controller database connection, you must update
the resource for use in Cognos Controller.
Steps
1. Start Cognos Controller Configuration.
2. In the Explorer window, expand Database Connections.
3. Click the database that you want to update and, from the Actions menu, click Run.
The Database Conversion Utility opens.
4. Click Run Steps.
The database is updated for Cognos Controller.
5. Click Close.
6. From the File menu, click Save.

Cognos Configuration

Update a Resource
After you add a new resource, such as a Cognos Controller database connection, you must update
the resource for use in Cognos Controller.
Steps
1. Start Cognos Controller Configuration.
2. In the Explorer window, expand Database Connections.
3. Click the database that you want to update and, from the Actions menu, click Run.
The Database Conversion Utility opens.
4. Click Run Steps.
The database is updated for Cognos Controller.
5. Click Close.
6. From the File menu, click Save.

Cognos Configuration

Add a Resource
To use different data sources in your Cognos 8 Controller installation, add new Cognos Controller
database connections to your configuration.
Steps
1. Start Cognos Controller Configuration.
2. In the Explorer window, click Database Connections.
3. From the File menu, click New.
An untitled database appears under Database Connections.
4. In the Untitled window, in the Name box, type a name for the database, and press Enter.
5. Enter the values for the remaining properties.
6. From the File menu, click Save.

Cognos Configuration

Add a Resource
To use different data sources in your Cognos 8 Controller installation, add new Cognos Controller
database connections to your configuration.
Steps
1. Start Cognos Controller Configuration.
2. In the Explorer window, click Database Connections.
3. From the File menu, click New.
An untitled database appears under Database Connections.
4. In the Untitled window, in the Name box, type a name for the database, and press Enter.
5. Enter the values for the remaining properties.
6. From the File menu, click Save.