List of Contributions

Ori

Contact Details

My Content

1 to 11 of 11 total
Posted By Ori May 5, 2021 3:19 AM
Found In Egroup: Cognos Analytics
\ view thread
Excellent. Thank you very much for your suggestions. ------------------------------ Ori ------------------------------
Posted By Ori May 3, 2021 6:15 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello community, Does anyone know if there is a functionality to generate multiple reports in multiple CSV-formats (different delimiters)? For example: Report A - CSV format with delimiter ";" Report B - CSV format with delimiter " " Thanks for your feedback. ------------------------------ Ori ----- ...
Posted By Ori Apr 21, 2021 9:52 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello community, can anyone suggest how to use data-table filtered by a master-detail relationship? We use CA 11.1.7 and this functionality seem not to be available in data-tables. Can anyone suggest a way to still utilize data-table filtered by a query? Thank you. ------------------------------ Ori ...
Posted By Ori Apr 19, 2021 2:13 AM
Found In Egroup: Cognos Analytics
\ view thread
You're very welcome. Glad it worked. The visualizations that allow sorting by a different data-items are in the "Charts" category (underneath "Legacy visualizations"). If you use for example the "Clustered Line" visualization then you can sort your x-axis according to a different data-item of your choice. ...
Posted By Ori Apr 19, 2021 1:37 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello Veljko, you can adjust your data-item definition to this: case when [dataitem] is null then '' else [dataitem] end Best, Ori ------------------------------ Ori ------------------------------
Posted By Ori Apr 19, 2021 1:29 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello Mauro, In cases where the automatic sorting is not performing as expected I create a new data-item in the relevant query only for the sorting and use that data-item for sorting in the visualization. I'm not sure which visualization you are using, but in the traditional charts there is the option ...
Posted By Ori Mar 10, 2021 2:53 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello community, About a year ago the CA Dashboards were described as a tool to explore and display data but not the right tool for designing "pixel-perfect" display of data. Since then the CA dashboards functionalities have been enhanced. What would you choose today (CA 11.1.7) for implementing an online ...
Posted By Ori Feb 22, 2021 3:39 AM
Found In Egroup: Cognos Analytics
\ view thread
After upgrading from CA 11.0.13 to 11.1.7 R2, executing an active report ends with a java exception: An unexpected exception occurred: java.lang.NullPointerException After further attempts to execute the report, eventually it does run with no errors. Has someone experienced such a behavior? IBM Support ...
Posted By Ori Feb 3, 2021 8:20 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello all, In an active report we have a data-list-box where a single item can be selected (items belong to query1). In a list below we wish to display only data items (query2) that correspond to the selected item above. The problem: Query2 returns by default 180K data-items and the active report either ...
Posted By Ori Feb 3, 2021 2:00 AM
Found In Egroup: Cognos Analytics
\ view thread
We have two instances of Cognos 11.1.7 SP2: DEV and PROD. When a new data module is completed in DEV, what would be the best method to deploy it to PROD? I couldn't find an export-option. Thanks for your advice.
Posted By Ori Nov 18, 2020 8:24 AM
Found In Egroup: Cognos Analytics
\ view thread
Hello community, In a crosstab I wish to have two global summary columns (on the far right). The first summary column works, the seconds doesn't. Here is the problem: The cross tab has a main measure - " Anzahl Tickets", which is used in the global summary column (average - Ø) on the right. ...