The following issues were identified with software components of SAP BW data sources. We are managing the status of these problems with the vendor, but, at the time of this release, the following issues are still unresolved in the product.
When creating calculations in Report Studio and Query Studio, you may encounter problems with the units of measure. For example, the calculation Cost*Cost returns the unit of measure CAD^2 in BEx but * in Cognos 8.
Change the format of the corresponding column to obtain the desired unit of measure.
421591
If you add the Count summary to a non-fact column in a list and then group the column, the column will not be grouped when you run the report.
To resolve this issue, group the column first before adding the Count summary.
435017
If you have a crosstab with multiple measures (multiple summary types and semi-additive aggregations), one measure may not render if the default aggregation function for the measures is set to Automatic.
To resolve this issue, set the default aggregation function to None.
437751
If you run a crosstab report that has the same dimension on both edges, the report will not return any data.
To resolve this problem, specify that data not be suppressed for the query that is driving the crosstab.
In the report layout, right-click the crosstab and click Go to Query.
In the Properties pane, click the Suppress property and click None.
Save the report.
545657, 545661
If the SAP BW server administrator configures custom formatting for empty cells on the SAP BW server, the custom format does not appear in Cognos 8 reports.
Administrators should configure the formatting of empty cells in Cognos 8.
425064
SAP BW data sources may have problems with sections in reports under different circumstances:
If a section in a report uses the lowest-level query item in a ragged hierarchy, such as the children of the "not assigned" node, the following BAPI error may appear:
BAPI error occurred in function module BAPI_MDDATASET_SELECT_DATA. Value <valueName> for characteristic <cubeName> unknown
If you create a section in a report using conformed multicubes with SAP variables, an SAP error message may appear.
The solution is to remove the section from the lowest-level query item.
443696
The solution is to use one multicube when creating sections in reports.
437613
When the rollup summary function of a measure is minimum, summary rows return incorrect total values.
Currently, there is no workaround for this problem.
409532
Calculated key figures appear with the non-aggregate icon in the Key Figures folder.
To solve this, edit the variable in SAP BW and set the TIME OF CALCULATION to Before Aggregation.
nbna
If you create a filter expression such as the following, no data is returned.
[ <report item attribute> ] = ?prompt?
To resolve the problem, do one of the following:
Fully qualify the item by using items from the metadata tree instead of the report item tree
Build smart prompts in the report instead of hand coded prompts
495958496340