Matching .csv format to .xls formt

[prattsiii]

Good morning,
Long time lurker, first time poster.

I'm currently a moderately competent report writer within Cognos Analytics but all of my work is done through the UKG HR/Payroll system so I don't have access to the truest version of Cognos Analytics - only a cloud version that exists with my UKG product.

I have built out a report that matches the required template of one of our vendors who needs to ingest the data. It is three "Lists" stacked on top of each other essentially. One is the header table (one header row, one row of data), the second list is the meat and potatoes - all employees and necessary details, and then the final list is just two rows again (one header row, one count of all employees).

It runs perfectly fine as an .xlsx but when I run it as a .csv, it only populates the first list. Is there some sort of alternate solution I could employ for this to work?

[MFGF]

Good morning,
Long time lurker, first time poster.

I'm currently a moderately competent report writer within Cognos Analytics but all of my work is done through the UKG HR/Payroll system so I don't have access to the truest version of Cognos Analytics - only a cloud version that exists with my UKG product.

I have built out a report that matches the required template of one of our vendors who needs to ingest the data. It is three "Lists" stacked on top of each other essentially. One is the header table (one header row, one row of data), the second list is the meat and potatoes - all employees and necessary details, and then the final list is just two rows again (one header row, one count of all employees).

It runs perfectly fine as an .xlsx but when I run it as a .csv, it only populates the first list. Is there some sort of alternate solution I could employ for this to work?

Hi,

When you render a report as CSV (or as Excel Data), the output only contains the items held in the first query of the report. What you are seeing is what I'd expect - the contents of the first list (which is actually what is defined in the first query). This is the way it was designed to work.
Is there a reason you're not able to use the Excel rendering option (which reflects what you have on your page)?

Cheers!

MF.

[prattsiii]

Hi,

When you render a report as CSV (or as Excel Data), the output only contains the items held in the first query of the report. What you are seeing is what I'd expect - the contents of the first list (which is actually what is defined in the first query). This is the way it was designed to work.
Is there a reason you're not able to use the Excel rendering option (which reflects what you have on your page)?

Cheers!

MF.

I'm hoping to produce a true automation with this file. UKG has a Report Exporter feature that dumps BI reports as either .csv or .xml on a schedule. I was hoping to get this report dumped to a folder where our vendor also has access and could set their own schedule to ingest it. Of course the "must be .csv or .xml" has really limited the value of this automation as they are only getting the first list which provides no value.

[ashleh]

Does it need to appear as three separate lists with headers, or can you union the data together into a single query and feed a single list from that?

[dougp]

Building on MFGF's answer...

Each report should output exactly one list.  No header, no footer, no fancy formatting.  It looks like you'll need three reports.

So you're using a reporting tool as a step in a data integration process?  Sounds sketchy.

[prattsiii]

Hi all,
I went back to the receiving vendor and asked what purpose my header/footer lists truly served and they agreed they were unnecessary so the report is now just the content and can be pushed into the exporter tool now.
Appreciate the help everyone.