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

    Date prompt default

    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!
  2. ARustad1645

    Filter hiding subtotal line?

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

    Setting up a boolean variable

    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!
  4. ARustad1645

    Setting up a boolean variable

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

    Setting up a boolean variable

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

    Setting up a boolean variable

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

    Setting up a 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...
  8. ARustad1645

    Hiding lines with zeros?

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

    [TR1901] A PowerCube Table or index is full

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

    Date prompt default

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

    Hiding lines with zeros?

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

    Date display?

    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!
  13. ARustad1645

    Date display?

    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!
  14. ARustad1645

    Default Output?

    nevermind, figured it out.
  15. ARustad1645

    Default Output?

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

    Filters

    Thank you! I'll give that a try!
  17. ARustad1645

    Filters

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

    Filters

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

    Creating Financial Report...

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

Part and Inventory Search

Back
Top