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!

Register Log in
  • Congratulations Rhinorhino 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. AngelaCognos

    Complex Reports

    You can either create the 30 day query and the 60 day query and join them into an output query or you can create your 30 and 60 data items with logic in them like: if (Date is in the date criteria) then (Fact) else (0)
  2. AngelaCognos

    Drill thru based on multiple paramenters

    You want to pass a data item when you want the PLACEMENT of the drill-through to matter. Like, I click on a row and it passes the Store Number that's in the row. There may be many store numbers in the list, but the specific one from the click is the important part. You want to pass a...
  3. AngelaCognos

    Drill thru based on multiple paramenters

    It sounds like you have single parameters, like = instead of multi parameters like in(). You said your SOURCE has an 'or' so there's 2008 OR 2009. How could you possibly pass both? Now let's say your source has 2008 AND 2009. You could definitely pass them IF THEY ARE A PROMPT choice and not...
  4. AngelaCognos

    Need help in creating unique ID's in cog report studio.

    Additionally, you can use Event Studio so that you only get the list of customers the FIRST time they appear no matter how many days pass.
  5. AngelaCognos

    how to make my own parametrs in check box in cognos?

    To group by user choices you need to make a data item in your query, call it "Group A". Inside, it try something like: CASE ?FirstGroup? When 'Sales' Then [Sales] When 'Profit' Then [Profit] END You can do that for Group B, C, etc. Then in your list, put those new data items in the list...
  6. AngelaCognos

    Conditional Filters

    Why are you using a specific yes/no instead of just using an optional filter? The whole purpose of an optional filter is so that if the user skips it they get "all". If you must have this option I think you still have to make your data parameter optional (otherwise the no won't work). Then...
  7. AngelaCognos

    How to create a union in report studio

    You are most welcome. And yes, you can use the database or Framework Manager to set up unions (think 'Views'). In your case you'd need to talk to IT but I'm pretty certain it's possible.
  8. AngelaCognos

    How to create a union in report studio

    So you're all solved now? FYI, to see an item's data type in Report Studio, when looking at the DataSource pane, right click a data item and it'll tell you if it's a charachter, integer, whatever.
  9. AngelaCognos

    How to create a union in report studio

    Hmm, I put 'Unable to find query information' in at IBM and got nothing of use back so I don't know what that is referring to. That error doesn't sound like a data type error. Does it give you an error number that could be researched at...
  10. AngelaCognos

    How to create a union in report studio

    I think this post got overlooked. Hopefully it's not too late to provide some help. Create a Query (Query1) and put in it the 'CLMN_NM' data item from your "DTTSKC01"."TTS_BUS_DETAILS" source. Create another Query (Query2) and put in it the 'NM' data item from your...
  11. AngelaCognos

    Forcing 'zero' rows

    How are you concatenating them? I mean, do you have queries joined together to get to your final presentation query or just one query and all the elements in it? If it's just one query then you have a modelling problem and I think you need left joins somewhere. If you're using sub queries...
  12. AngelaCognos

    extract year from Date prompt

    extract(year,[YourDateField])
  13. AngelaCognos

    each radio button for each separate report

    If all the reports are built from the same package you could combine them all into one 'report' having each output on a separate page the have a prompt page with your radio buttons which would control a conditional variable which would decide which page to display. If they're from separate...
  14. AngelaCognos

    Changing the Filter Display in Query Studio

    Cognos has a tool called DRU that is a mass find/replace (it scares me). http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bfind+%2breplace&uid=swg24021248&loc=en_US&cs=utf-8&cc=us&lang=all Brightstar Partners has a tool called MetaManager that can do it, too...
  15. AngelaCognos

    How to show all present users in cognos

    There are also third party tools such as MetaManager which can help achieve this.
  16. AngelaCognos

    How to change the catalog for multiple reports

    Please elaborate on what you mean by "catalog" - I think this is only needed for DB2 sources. With SQL we delete the catalog property in the source in FM and it means that we can easily change the datasource in Cogno Connection to point to different servers or databases (as long as the...
  17. AngelaCognos

    Trying to create a report of users

    If you're getting the login information from the Audit Package, you can edit that model to include your user list info with an appropriate join and then report on the combination.
  18. AngelaCognos

    Report Studio - Table of Contents

    Hopefully this isn't too late to help. The only way I know to do this in 8.2 is to insert a table, use standard text to jump to bookmarks that are placed in strategic areas of your report. We use bookmarks sometimes here and it's quite handy, though I've never used them for a TOC.
  19. AngelaCognos

    Scheduling

    Regarding the first item, we do this by having a column in our date dimension table which is populated with the first day of each fiscal period (for each date). Then in Event Studio, the criteria is [Date_Column] = [current_date] and [First day of Fiscal Period] = [current_date].
  20. AngelaCognos

    Cognos 8.0 Report Writer

    Yes, the advice to take a step back is ideal. In fact, I would say do not proceed without training in both report writing AND modelling. Of course, it doesn't have to be the same person, but the modelling is such a key to your success that I would estimate you could face project failure...

Part and Inventory Search

Back
Top