Parsing Error on Reporting Business

[JrolQasys]

Hello! 

I've run into an error where I made a copy of the standard report "Top Employees with Unassigned or Unsubmitted Credit Card Transactions" and I'm trying to add the field "[Expense].[Employee Information].[Org Unit 4 - Name]" in order to add the Cost Center to the Report.

But by doing that I'm getting a parsing error and I'm unable to make it work.

Can someone help me with this issue?

Thank you!

[KevinD]

@JrolQasys from what you described, my guess is you are trying to add the data item directly to the report page instead of the queries that make up the report. 

What is your level of experience with Cognos? Let's say on a scale of 1-10 with 1 being "what is Cognos" to 10 being "I can build reports in my sleep"? 

[JrolQasys]

Hi Kevin! My level of experience is a 3/4, I did the Cognos/Report Business learning lessons, but by trying to create the queries for the Cost Center first and then putting the data item on the report page.

How should I do it?

Thanks!

[KevinD]

@JrolQasys that report uses what is called a Union, which requires that the data item you want to use be added to both the queries built into the report. Then, once added to each query, you need to pull that data item from the Union into the Main query. Once in the Main query, you can then pull that data item into the Report Page. 

It's a bit of a process and difficult to explain in writing. I'm asking someone if they have any resources that shows how to do this.