Search results for query: *

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)

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

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

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.

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

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

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.

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.

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

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

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

extract(year,[YourDateField])

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

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

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

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

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.

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.

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

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