?
Solved

Sub-Query Cognos 10

Posted on 2014-12-16
1
Medium Priority
?
425 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 12

Accepted Solution

by:
RWrigley earned 1500 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Six Sigma Control Plans

762 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