94 IBM Cognos Dynamic Cubes
4.12.2 Publishing errors
Sometimes, you might see the following message after you publish a cube with all the publish
options set to On. This message indicates that the cube startup failed to respond before a
timeout.
BMT-MD-6587 The Query Service has not acknowledged that the cube configuration has
been received. Please verify the cube configuration and status in the IBM Cognos
Administration portal.
The reason for the message might be because of a problem with the cube. For example, if
you have a level where members are not unique, the cube will not start. Another reason might
be a transient timeout problem.
4.12.3 Missing metadata
If you imported metadata in a previous session of Cognos Cube Designer and cannot find it in
the data sources list, a possibility is that the model does not have anything in it that uses that
metadata.
4.12.4 Refreshing metadata that changed in the database
One of the databases that you are using for your model might contain changed metadata.
Changes can include added or deleted tables and columns and changed table and column
properties, such as column data types.
Select the data source and right-click Refresh metadata. Confirm that the changed metadata
displays in the metadata viewer. Validate the model. If something that is used in the model
was removed, correct the object references so that they point to the replacement objects.
4.12.5 Members
You must refresh the members every time you make a change to a dimension to view the
effect of the change. To refresh members, either select the members folder and right-click
Refresh members or select the dimension and right-click Refresh members.
If you made a change to any hierarchy, you must refresh members for the members folder for
any other hierarchy in the dimension.
4.12.6 Missing members
If a null exists in a source column for an attribute that is being used in the level key, some
members cannot be generated. If the null happens in a member caption, the member caption
displays NULL as its caption, even if other elements of the expression that are used to define
the member caption are not null.
To correct this problem, change the attribute expression to handle nulls.
4.12.7 Ellipses in the project viewer tree
Sometimes the project viewer tree might display ellipses for some parts of the project. To
force the tree to generate correctly, resize the project viewer tree.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.