Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. geethkal12

    Business requirement to create a report in report studio

    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...
  2. geethkal12

    Report Studio Questions

    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...
  3. geethkal12

    Technical documentation

    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...
  4. geethkal12

    Error Message in Report Studio

    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
  5. geethkal12

    Framework Modelling Question

    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...
  6. geethkal12

    Quarterly report --Change in Personal name/Company name

    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...
  7. geethkal12

    Report Studio Report

    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...
  8. geethkal12

    How to create a union in report studio

    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...
  9. geethkal12

    Enterprise status report

    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...
  10. geethkal12

    Enterprise status report

    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
  11. geethkal12

    Enterprise status report

    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...
  12. geethkal12

    Enterprise status report

    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')...
  13. geethkal12

    Enterprise status report

    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...
  14. geethkal12

    Enterprise status report

    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...
  15. geethkal12

    How create a chart from a query?

    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...
  16. geethkal12

    How create a chart from a query?

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

    Enterprise status report

    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...

Part and Inventory Search

Back
Top