Solved

Sub-Query Cognos 10

Posted on 2014-12-16
1
335 Views
Last Modified: 2015-01-05
Hello Experts,
I'm new to the Cognos world and need some guidance. From the attached file I want to combine column O into a single comma delimited field. I think this is going to involve an SQL script and a temp table to hod the data, but any better suggestions are great. The current report is a Excel/SQL based solution which I'm charged with migrating from to a new Cognos based one.
The final report could contain several hundred different customer with different material numbers. In the end I want to search the new field for certain item numbers.
Copy-of-cognosisapi.xls
0
Comment
Question by:R10131551
1 Comment
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 40505332
I think you're getting off onto the wrong foot with this approach.  Why do you want to combine the data into a single field?  That's going to restrict the usability of the final report.  Why not instead use a master-detail report or a repeater?

In other words, what is the ultimate objective of the report you're trying to build?
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

This is about my first experience with programming Arduino.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
This video shows how use content aware, what it’s used for, and when to use it over other tools.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now