Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Can you have different delimiters for specific reports

    Posted Thu April 04, 2024 10:27 AM
    Edited by brenda grossnickle Thu April 04, 2024 10:27 AM

    Re: Can you have different delimiters for specific reports

    I have one report where i want to use the pipe "|" delimiter and others where i want to use comma "," delimiter. Is this possible and how would i set this up? Cognos 11.1.7.



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------



  • 2.  RE: Can you have different delimiters for specific reports

    Posted Thu April 04, 2024 10:45 AM

    Is this for sending the results out to csv or something similar?



    ------------------------------
    Chris Turner
    ------------------------------

    Original Message


  • 3.  RE: Can you have different delimiters for specific reports

    Posted Thu April 04, 2024 11:35 AM

    Yes, this is for "Run CSV"

    Cognos Run CSV


    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 4.  RE: Can you have different delimiters for specific reports

    Posted Thu April 04, 2024 12:01 PM

    To the best of my knowledge, that's a system-wide setting...you can't change it for a subset of reports.



    ------------------------------
    Chris Turner
    ------------------------------

    Original Message


  • 5.  RE: Can you have different delimiters for specific reports

    Posted Fri April 05, 2024 08:04 AM

    Hi Brenda

    Would routing the reports to dispatchers with the required advanced RSVP property work for you?



    ------------------------------
    TREVOR COMEAU
    ------------------------------

    Original Message


  • 6.  RE: Can you have different delimiters for specific reports

    Posted Fri April 05, 2024 10:42 AM

    Hi Trevor,  

    Can you expand on what you mean by "required advanced RSVP property"?  Brenda and I work together, and she had asked the question for one of our customers. We did update the report service and the dispatchers service to RSVP.CSV.DELIMITER         , .  The customer would like both pipe and comma.  



    ------------------------------
    Kathrina James
    ------------------------------

    Original Message


  • 7.  RE: Can you have different delimiters for specific reports

    Posted Fri April 05, 2024 01:09 PM

    I think what Trevor is suggesting is that if you have multiple dispatchers each running a report service, you set the RSVP.CSV.DELIMITER property to different delimiters on each dispatcher, then use routing rules to make sure that the reports requiring one delimiter (eg |) get routed to the dispatcher configured for that delimiter, and reports requiring a different delimiter (eg ,) get routed to the dispatcher configured for that one.

    Cheers!

    MF.



    ------------------------------
    Mark Fry
    Technical Consultant
    ------------------------------

    Original Message


  • 8.  RE: Can you have different delimiters for specific reports

    Posted Fri April 05, 2024 03:42 PM

    [Quote]

    Thanks Mark! This is exactly what we need but I am not sure how to get this done. Do you have any documentation on how to setup the two dispatcher and setup the routing rules.  

    [/Quote]

    You would need a distributed install with at least two application servers in the mix. Documentation for installing the application server component is here:

    https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=installation-application-tier

    Once you have multiple application servers configured and running, you would then set the RSVP.CSV.DELIMITER property on each of them.

    Then you would need to set up server groups and routing rules:

    https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=routing-creating-server-groups-advanced-dispatcher

    https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=routing-setting-rules-dispatchers

    I haven't ever tried this, but hopefully somebody here will have done it and can confirm.

    Cheers!
    MF.



    ------------------------------
    Mark Fry
    Technical Consultant
    ------------------------------

    Original Message


  • 9.  RE: Can you have different delimiters for specific reports

    Posted Mon April 08, 2024 07:06 PM

    Hi,

    If you need a different delimiter for specific reports, you could try this:

    Create a report and add columns what you need and create "query calculation" where you concatenate all necessary columns with specific delimiter. For example:

    Query columns:

    1. Column "Product Line"
    2. Column "Order Method"
    3. Column "Revenue"

    Calculated "Query Calculation" My Csv column:

    "1.Product Line" || '|' "2.Order Method" || '|' || "3.Revenue"

    (If needed convert numbers to string e.g. (Revenue) )

    You could replace delimiter '|' with different value e.g. "1.Product Line" || '***MY_Delimiter***' "2.Order Method"



    ------------------------------
    Jaakko Forsberg
    ------------------------------

    Original Message