Search results for query: *

Hello All, I have a requirement to create a Claims report to display the claims that have been reviewed during the reporting period which is easy and straight forward. Adding to the above requirement we got to display decisions( approved Claim or Declined Claim) as well for that particulat...

Hello All, I have two queries with me. 1. In a crosstab Report there is average in the crosstab corner and display date in the rows area and Outcome in the column area. for the outcome I have given a case statement and segragated as GOOD Bad and worst. In the report output I want to get the...

Hi All, I am bit new to cognos environment. Just prepared some complex reports and got to do some technical documentation. Please help me out with Technical documentation format so that it should be simple and maintainable and should look professional. Please suggest me the technical...

Hello All, Please explain anyone what does the below error message mean?? when i try to run the report i am getting this message. "RQP-DEF-0556;Warning: Any scope defined for measure '<param type="string" index="1"/>' is ignored" Thanks in advance geetha

Hello All, We now have this fantastic star schema, with a neat fact in the middle, and dimensions on either side. All a good 0-to-N relationship and all working great, till users starting working with it.... What they are now requesting (users....) is show ALL the values in the dimensions...

Hello All, I have to create the report and got the package published already. The reporting requirements are: If the personal name has been changed within the reporting period; or registered company name has been changed within the reporting period then i have to provide id, code, previous...

Hello All, Suppose there are 4 tables tableI 1 -->n table II n---> 1 table III n---->1 table IV I need to create a report from two different tables(table I, table IV) where there is no link exactly between the tables. to create a link also there is no common identifier or common data item...

Hello All, I need to create a report using UNION relationship object. Please suggest me the procedure of using UNION in cognos report studiousing the below DB2 query.. select "NM" from "DTTSKC01"."TTS_FREIGHT_FORWARDER_REF" where "NM" IN(Select distinct "CLMN_NM" from...

Hello Ties, I need to integrate that chart report(Line graph) in a small window (portlet) on the cognos connection page. do i need to goto tools -- my preferences. How to get that graph in one corner of that cognos connection page. Please give me some idea so that i will start working on it...

Hello Ties, Thank you very very much. with your assistance i am able to finish my task. Now i got to integrate that line graph in to cognos connection portal. can you give me any idea? anyway thank you geetha

Hi Ties, Hope I m troubling you a lot. You been very helpful. I just used the above case statement with code name Day Names. In the filter i used expression : [Day Names] = _add_days(current_date, -7) Then i dragged Day Names on to X-axis and click sort-- advanced sorting and added...

Hi Ties, Thank you very much for the reply. I tried as per your suggestion. but i am getting mon to sun. then tried the below code: CASE Current_date WHEN (_add_days([Date], 0)) THEN ('THU') WHEN (_add_days([Date], -1)) THEN ('WED') WHEN (_add_days([Date], -2)) THEN ('TUE')...

Hi Ties, I am still trying to work on that garph. my requirement is to get previous week days plus today(day names) on X-axis and it should get refreshed everyday. for example: today is tuesday. on the x-axis of the graph it should represent Wed Thu Fri sat SUn Mon Tue. Please provide me the...

Yep its a typical report studio question. Got to prepare Performance Entreprise status report. i managed to build a line graph with days of the week on X_axis and execution time on Y-axis. but my team leader asking me to prepare to represent the previous 7 days from today's date on X-axis(such...

i need to build a small line graph from audit database showing performance report for the enduser and have to integrate with cognos connection portal pages.I got to create queries on the top of graph to get to know the performance whoever logs in and using cognos environment. I managed to build...

Hello All, How to build queries on the top of the chart in report studio? thanks for your help divya

Hello All, I need to create EDW status report from Audit package so that the report can be integrated to cognos portal pages which displays useful information to the user when he is using cognos environment. In that report there should be a graph showing all the data items like Users online...