Answered Questions

  • What is subject area?

    shaik

    • May 6th, 2006

    Subject Area is place where  we draw the entities and attributes of the dimensions and fact table with relationships in ERWIN

    girish

    • Mar 16th, 2006

    Dimension modelling is brokent into subject Areas which are nothing but functional areas of an enterprise.

  • How can I create a dynamic column name in Cognos

    1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight the report, and then right-click. 3.Select Properties, and then click the Headers/Footers tab. 4.Clear the Column Title Header check box. This will remove the headers from your columns. 5.Reinsert the rest...

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: moissi

    • Nov 3rd, 2007


    1. add a data item to the query(the query on which the report is based)
    2. define an expression which u want to use for the dynamic column label
    3. from the report page click on the column label
    4. from properties pane look for "column label" the default would be "data item label/name" change that to "data item value"
    5. in the same pane change the "data item" property to have the data item that u created for the column label.

    srihari

    • Apr 6th, 2013

    Two ways to used in dynamic columns in Report Studio

    1.Query Calculation
    2.DataItem

    Joseph Thekkath

    • Jan 16th, 2012

    Mgani, How we can create the column headers dynamically using parameter maps. Here is what I am facing, in the data table we have following columns Id, Fact Period And in a Translation Table I have...