...I think.
I'm using Cognos Analytics 11.2.4.2 and I am having trouble with an uploaded file for a new report I am building.
This topic involves an uploaded file, a data module, and a report. It's all report development work, so I'm dropping it into the Reporting area.
My user has a need to add narrative to a nicely-formatted report that is mostly data from our data warehouse. The narrative text includes paragraphs -- so, line feeds. It looks like somewhere between uploading the file and viewing it in the grid view in the data module, the line feeds are being changed into spaces.
When I copy the value from the Excel cell into Notepad++, I see CR LF. (Could be Windows "helping" me?)
When I use VBA to write the value to the immediate pane, changing CR and LF to something readable along the way, I see LF, but not CR.
I created a simple report and tried to view the data, noticing that it's all one one line. That could be HTML rendering, so I did...
replace([Query Item], chr(10), '|||')
...but there's no ||| in the output.
Is there a way to verify this? I don't see any indication in the Content Store of where the data from an uploaded file is stored. I think uploaded files end up in the data folder. Searching by date, I think I found the parquet files. It looks like it went to two files because there are two worksheets in the workbook. But I can't read the contents, so I can't tell for sure. I don't see a straightforward way to open a parquet file (.data in Cognos) in a human-readable format. I'd love to see what data Cognos stored.
Any help is appreciated.