Search results for query: *

Thank you very much for the response. We have recently decided to stop using Cognos and go another direction, but hopefully someone else will find this thread helpful! Thanks!

I am working on writing a financial report and I've been having trouble getting my filters to work as intended. The two things I am attempting to do is to limit by "cost center" (department) and to hide the lines containing all zeros. In the end the goal is that the first page of our report is...

Yes, you are correct, I am using a cube. I'll give that a try, thanks! I just received a log in for KB, I didn't even think to look over there. Thanks!

I have not looked at the raw data, but based on the information in our ERP system I believe it is in dollar format (0.00). When I attempt to validate the expression I get the following error message: RSV-VAL-002 Invalid expression coalesce([Actual],0) = 0 and coalesce([Budget],0) = 0...

It looks like I was trying to make the syntax too complicated before. Now my report runs without error messages (I was getting errors before) but it doesn't seem to work. I'm still getting lines that have all zeros. Does it matter if I have the fact cells formatted to show a '-' rather than a 0...

Maybe I should add that I'm trying to evaluate: If [Actual] = 0 and [budget] = 0 then I want it to hide the line. I understand how to set up the rest of the instructions I received, other than the boolean variable.

I've only been using Cognos for a few months and we're still in the setup process, but I have a follow up question to a response I received a few days ago. I'd asked how to hide lines containing all zeros on a financial report. In the response I received (pasted below) I was told to "set up a...

Is there a way to do this for all lines, rather than having to do it for each data item? Also, my report is structured in such a way that each line (account) has actual numbers and budget numbers for the period selected). If both the actual and the budget are zero it want that line to be hidden...

We had a consultant take a look at this for us and here is his response: "There is a setting in the .ini file that allows for multiple files for a particular cube once a specified number of records is reached. If this is set to zero, as it was, no multiple files will be generated and 2GB is...

Is there a way I can set a date prompt to default to a specific date other than the current day? For example, I'd like to be able to set the date prompt on a sales report to default to yesterday's date. I'd also like to set the value prompt for a financial report to default to the current...

I'm writing a financial report and I'm wondering if there is a way to hide lines that are all zeros. Thanks!

It's Cognos 8. Yes, it's a parameter within Report Studio. I've been using a layout calculation to get the date as far as I have, I'll give it a try using a data item. We've been having trouble getting any dates to show up properly. Thanks!

If the date related to our data is shown as 2008-Apr for example, is there a way to make that display as Apr 30, 2008? The date would vary depending on what is selected on the prompt page. I have been able to get it to show Apr 2008, but can't figure out how to get the day to show up. Thanks!

nevermind, figured it out.

Is there a way to set the report to run as a PDF every time it is run, rather than html? I'm sure this is easy to do, I just can't figure it out.

Thank you! I'll give that a try!

Do you have any other suggestions on how I can limit my information? I'm trying to create a financial report and for one data item I need to limit it by two different means. Our accounts are broken down into 4 segments: Account, Sub-Account, Cost Center, and Project. I want the total of all...

Is there a way to use a filter on just one single data item?

I'm trying to create an income statement but can't figure out the best approach to narrow down a few pieces of information. I'm trying to create a data item that pulls in the info from the cube for a range of accounts if the department is either one certain department or a range of departments...