How can individuals with Autism or Asperger's, known for their unique cognitive abilities and attention to detail, leverage the power of IBM Cognos Analytics for Big Data processing and interpretation? Are there specific strategies or tools within the software that could be particularly beneficial for neurodiverse individuals in this field?
 
Forum Asperger

I want to find keyword(s) in the text value. Im looking for AND/OR solution that the query loops in 1 text value for all keywords and then goes to the next.

Query sample that im currently using:
[Dataitem].[textvalue] CONTAINS 'Test1' OR
[Dataitem].[textvalue] CONTAINS 'Fox' OR
[Dataitem].[textvalue] CONTAINS 'Cat' OR
Etc...

I found a solution in SQL with cross join but this one needs to be done in Cognos Analytics, which I not found a good solution.

This topic has been moved to Announcements.

https://www.cognoise.com/index.php?topic=38317.0

This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38319.0

This topic has been moved to Reporting.

https://www.cognoise.com/index.php?topic=38327.0

Thank you, Adam, for the response

I did remove those columns, but it still gave me the same result.

After a while from posting this issue

The item seems not duplicated anymore.

However, new items shown have the same issue: they are duplicated 


I've attached a sample from the report. I grouped all the report columns, and I highlighted the item that is duplicated


All the item seems to work fine, but when you look at the column in the cells not merged as one Cognos start a new row, but the item in it

it happened from time to time in certain items

I think what you have shown are your two inputs:  The list of keywords for the filter and a sample text description.

Please show the expected outcome.  More sample text descriptions, at least one that contains none of the keywords, would also be helpful to better demonstrate the problem.

We have column that contains a text description and we want to filter on certain keywords, and a column which shows which keywords have been filtered (as not all keywords are in the same description).

I've tried several options with CASE, IF and IN_RANGE statements, but do not get the desired report.

Example
Keywords:
Test1
Fox
Cat
Dog
Test2

Text description:
The test1 module has been tested and shows good results on cats and dogs.

The example has 3 keywords, test1, cat and dog, which I try to filter with cognos queries. The other 2 keywords, fox and test2 are not in text description examples, but might appear in another text description.

Hope someone can help me out.

QuoteResults are:"a","b","123","2025-02-20","Hello, World!",....
Again, this indicates that .csv output format is doing something unexpected to the result set.

If that is what you see in HTML,

"""a""","""b""","""123""","""2025-02-20""","""Hello, World!"""
...is the expected outcome.  That's because if a value contains a quote, the CSV must be encoded as such a way as to not lose that character when the data is read.

Using Excel, for example, if I start with this data...

c1	c2	c3	c4	c5
a	b	123	2025-02-20	Hello, World!
"a"	"b"	"123"	"2025-02-20"	"Hello, World!"

...and save as CSV, I get...

c1,c2,c3,c4,c5
a,b,123,2025-02-20,"Hello, World!"
"""a""","""b""","""123""","""2025-02-20""","""Hello, World!"""
Clearly, modifying your data by adding characters to every value is not the right answer here.


Looking through https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=reference-report-service-batch-report-service-advanced-settings I see you can set the qualifier, but there is no way to force the qualifier to be used when it is not needed.


A CSV parser will read the following rows as identical:

a,b,123,2025-02-20,"Hello, World!"
"a","b","123","2025-02-20","Hello, World!"
It seems unlikely that the vendor can't consume generic CSV.  Is the vendor really not using a generic CSV parser?  Did they go to the effort to develop their own, non-standard CSV parser?

If this truly is a requirement, something like this PowerShell script would work.

$fileIn = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book1.csv"
$fileOut = Join-Path (New-Object -ComObject Shell.Application).NameSpace('shell:Downloads').Self.Path "Book2.csv"

Import-Csv -LiteralPath $fileIn | Export-Csv -LiteralPath $fileOut -UseQuotes Always
But if you're going that route, you should also have PowerShell (or your script runtime of choice) run the query to get the data to begin with.  This is not a good task for Cognos Analytics.

To answer some of your questions.

When I run to HTML the results look as I would expect, a single set of quotes wrapped around each data item regardless of data type. To confirm each data item looks like '"' || cast([Data Item] as varchar(256)) || '"'.

Results are:"a","b","123","2025-02-20","Hello, World!",....
Again, this indicates that .csv output format is doing something unexpected to the result set.


The need is to replace a manual data dump for a Vendor executed out of Toad.
The idea is to match the current data format of the existing data feed so that the vendor has no impact on their end.

We want to automatically trigger it to run on a dependency of two file loads completing on the database (this we have successfully done).
I don't see any reason why Cognos shouldn't be a perfectly good fit to produce this output - There may be other tools, but Cognos should work too!

Again, any help would be greatly appreciated.
Thanks,
Adam.