Possible in Cognos.. Please check the flowchart and please post your updates.

[siemenkarts]

Please check the flowchart (Attachemnt) and Kindly reply me  whether this requirement is possible in cognos.


The entire report has to be created in Cognos Report Studio. I am really confused in starting the report.

How to arrange the requireements ? ? How to develop this report. Since I am totally confused.


Kindly sort this issue and please post  the possibilities in developing this kind of report.

[blom0344]

Some elements are indeed possible, but the proces you describe is much more in the domain of ETL then within the reporting domain. Comparing and subsequently performing actions is not within the normal range of RS capabilities.  It really is a workflow, not a report challenge

[siemenkarts]

Thanks dear.. Can please post the possible areas in the reporting flowchart. How to link the Cognos Query towards public Directory (Unavailable in Package and Database). how to process the searching methods in the directory.

The intitial stage to extract the database names and the user names that , I can do that in SQL,
Next stage is that the report has to search for Listing availability in the share directory as per the user name passed .  I dont understand this possbility. please check the flowcart.

Please post your update

[blom0344]

Has someone told you that Cognos Report Studio CAN do these things and are you responsible for the actual technical realization? Or do you expect an answer to the question  : "CAN Report Studio facilitate the actions in the workflow?


AFAIK  RS is not the tool you want for the job, but I hope to be proven wrong..

[siemenkarts]

My dear Friend,

The attached flowchart is the given requirement by the client. But we have done reports on package extraction and Hash reports, We have not faced a report in this model in my experiance. So please guide me the possibilities in this report.

[blom0344]

My replies focus on whether you should not use another tool for the assignment. Like using a hammer to drive a nail in the wall to hang a picture instead of trying to do the same with a saw.   ;)

[siemenkarts]

I must develop in Cognos Report Studio alone , If not I have to give it back as saying that It is not possible.

[Lynn]

I think your flowchart is a little vague to expect really specific advice. Your boxes for "Listing Logic", "Override Logic", and "Compare Logic" could be easy or difficult to implement depending on what the specific requirements are.

Also, your post that mentions you need to search a directory and have nothing in the package or the database about it. Hmmm....I have to agree with Blom that Report Studio is probably not the right tool for this job or at least it isn't the *only* tool you need for this job.

[siemenkarts]

Thanks friends.... Will see for one more day for Comments... Will check the client in the other end.