Answered Questions

  • Jan 10 2008
    03:33 PM
    7316
    6

    Import two data sources to Framework Manager in Cognos
    • manjula_g

    please explain me How to import two data sources into Framework Manager?Can anyone tell me what is role of reporter writer in Cognos?

    binay.bk

    • Jan 24th, 2008

    We can import two data sources to Framework Manager  in the Run Metadata  Wizard.Go to Run Metadata  Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.

  • Dec 21 2007
    02:22 PM
    5385
    6

    Query Studio
    • mail2alert

    Why we are prefer to query studio for simple reports and any extra feature is there in query studio other than report studio?

  • Feb 14 2006
    06:29 PM
    11067
    11

    what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

    • suresh babu

    Star Read Best Answer

    Editorial / Best Answer

    binay.bk  

    • Member Since Jan-2008 | Jan 24th, 2008

    Hi

    Drill Through is used to link the master & detail reports.
    After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

    Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

      For Cascading no need of two reports.If a report having two related columns (e.g. Country & States),then we can cascade these two columns by adding two value prompts.

    If you select a country (e.g INDIA),in the next prompt all the states will be displayed those which are under INDIA.

    If you want to see the details for the state Tamilnadu,then select TN from the list which will display all the details for TN.

    binay.bk

    • Jan 24th, 2008

    HiDrill Through is used to link the master & detail reports.After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that...

    subbu

    • Nov 4th, 2007

    Cascading report contains one report and it work based on the condition.drill through contains two reports parent report(summary),child report(detail report)child report contains a parameter that must accept the values passed from parent report.

  • Oct 09 2005
    12:55 PM
    37705
    38

    How can I create a dynamic column name in Cognos
    • Jagan

    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 4th, 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...