Cognos Knowledge Points Summary

2. Some cells are hidden when the page layout

   Select the cells you want to hide, and set the box type to ' None ' in the box properties.

   List table (list) header is hidden, select the entire list--and general----select hide.

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6D/5D/wKiom1VigmHSO5VUAADnwjxerTQ490.jpg "title=" Cognos list hidden. png "alt=" wkiom1vigmhso5vuaadnwjxertq490.jpg "/>
   

   
   

4. Using local sql:

   You need to set the properties of the query--process-only local. Otherwise, the operation will be error.

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6D/58/wKioL1VihPWxGkpdAADy8K2qJ5s094.jpg "title=" Local SQL property settings. jpg "alt=" wkiol1vihpwxgkpdaady8k2qj5s094.jpg "/>

6. The following occurs when the crosstab fails to expand:

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6D/58/wKioL1VihZWxpK0wAACOwbclNIU648.jpg "title=" Cross table extension error. jpg "alt=" wkiol1vihzwxpk0waacowbclniu648.jpg "/>

   You need to set the corresponding data item property in its query to: Properties--Aggregate parameters--Total

   650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6D/58/wKioL1VihlOCw3G6AAEsOJo9m3s106.jpg "title=" Cross-table data entry settings. png "alt=" wkiol1vihlocw3g6aaesojo9m3s106.jpg "/>

8. Total

   1) Total problem in the cross-table

   The totals generated in the crosstab will be calculated from the columns and columns by the year, the ratio, and so on, when the sum of all the values in the column is added, then it is wrong for the series to get the total value. The correct is to participate in its calculation of the relevant columns of the total value of the corresponding calculation of the previous year, the proportion is correct. For such a problem, we need to set the divisor in the data Item property setting to 0, the number of the previous year or the operation order of the data item is set to >0.

   2) Total issues in the list

   In the list we need to put the total line under the title, so we need to define the total manually, as follows:

   Drag data Items--Set Total (field name for report) or total (field name for relative field name)

10. Conditional styles

    A row's overall background is set to the relevant color, or the ratio is less than 0 when the value is marked red, or the field value is a value when set its box properties, etc. can be resolved by the conditional style.

12. Date selection Box

    Set the SQL parameter to and a.ymd= #prompt (' YMD ', ' char () ') #或者to_char (#prompt (' YMD ', ' char () ') #, ' YyyyMMDD ');

    Drag date hint--use existing Parameters--select Set parameters (such as YMD)--Complete

    650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6D/5E/wKiom1Viig-R4d6-AAId7Ig-OBQ821.jpg "title=" Date hint setting. png "alt=" wkiom1viig-r4d6-aaid7ig-obq821.jpg "/>

    Select the generated Date prompt box and set the properties of the selection UI to the edit box in the property settings.

    650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6D/5E/wKiom1ViioXTgBhAAAKFzcwC12E085.jpg "title=" Date selection box settings. jpg "alt=" wkiom1viioxtgbhaaakfzcwc12e085.jpg "/>

    Drag a button Tip control, select the generated button prompt control, and set the type to complete in the general item inside the property settings.

    
    

This article is from the "Stormkai" blog, make sure to keep this source http://stormkai.blog.51cto.com/7934168/1654864

Cognos Knowledge Points Summary