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 Chriss Miller 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. RyanDonohue

    Report server not responding when moving filter to tuple. Please help.

    Thanks Blom. I guess I will finally make the switch. I did enjoy the guarantee that it would be you answering my questions here on Tek-Tips.
  2. RyanDonohue

    Report server not responding when moving filter to tuple. Please help.

    I have a list report that needs to use different members of my ledger (Budget and Actual), date (current month, prior month, prior year), and measures (current month vs YTD). I can successfully create the report using tuples for ledger and measure when the date is applied as a filter. In order...
  3. RyanDonohue

    Dynamic Measure in a tuple issue

    Good Luck! Hope you are able to figure it out easily.
  4. RyanDonohue

    Dynamic Measure in a tuple issue

    Ty, I am sorry for leaving you hanging like this! After reviewing my report, I realized I defined the ledger ([Actual]/[Forecast]) as a hidden column and thus used a standard measure. I tried to create the waterfall that you are asking for in a blank template. I am able to waterfall where...
  5. RyanDonohue

    Filter is dropped in the middle of a crosstab

    Hey Ties, I wanted to thank you for your help with this. I was able to figure it out finally! Basically what was happening, was that I had a calculated measure that was making decisions in one hierarchy (Income Statement) while my crosstab rows and filter we being defined in another (Company...
  6. RyanDonohue

    Dynamic Measure in a tuple issue

    Hey Ty, Please forgive me as I am rather new myself. Would you mind explaining what you are trying to do in more detail? I have a report similar to what you are trying to do that provides Actual up to the selected month, and then Forecast for the remainder of the year. My months only go...
  7. RyanDonohue

    Filter is dropped in the middle of a crosstab

    I have attached my report. Maybe you could have a look at it. Thanks.http://www.mediafire.com/?ha8pv0bu49clvcs
  8. RyanDonohue

    Filter is dropped in the middle of a crosstab

    I'm at the mercy of DBAs backlogged with months worth of work. If I was able to fix the SQL so that it could compile (replace all of my tokens with a fixed member), would I be able to do something to fix it (assume it is stitching)? Let me set up this mediafire hosting and I will load my report.
  9. RyanDonohue

    Filter is dropped in the middle of a crosstab

    I've tried after auto-aggregation, but it gives me the same results. I've even tried aggregate([Revenue] within set [Branch]) thinking this would force the crosstab to evaluate at the branch level, but this too did not change my results.
  10. RyanDonohue

    Filter is dropped in the middle of a crosstab

    Thank you Blom. Your explanation for the scenario makes a lot of sense and I feel this may be indeed what is happening. Unfortunately, I am unable to view the SQL due to validation errors caused by my token (this occurs in several reports, but they all work as expected). Assuming this is the...
  11. RyanDonohue

    Filter is dropped in the middle of a crosstab

    I have had my entire team look at the following issue and none of us can figure it out. I certainly hope you can. I have a report with 4 crosstabs; each one gives a little more detail than the level before it. They all refer to the same query 1) Aggregate(Division) (1 Column) 2) Division (As...
  12. RyanDonohue

    One List affects the results of a second list - WHY?

    I have a list in my report that uses a custom grouping based on the name of the object. For example, Case when [Name] in ('Cat','Dog') then ('Mammal') When [Name] in ('Lizard') then ('Reptile') ...etc... End In some circumstances, the grouped items will repeat themselves based on level below...
  13. RyanDonohue

    Column issue in cognos

    You will need to have a data item for country. This would typically come from the database, but from the sounds of it you would have to derive country from the country-state combination. To do this, create a new data item and use the following definition: substring([Country-State], 1, position...
  14. RyanDonohue

    Dynamic Measure in a tuple issue

    I figured out a solution that required using Tokens. This allows my tuples to be flexible but avoid using case when statements.
  15. RyanDonohue

    Token prompt removes another parameter from parameter list

    This is a very peculiar situation and I am looking for some assistance to make sense of it all. I have a report with a parameter for Brand (without a value prompt as this is a pass through value). This displays on the parameter list for the pass through. I am adding a token prompt called...
  16. RyanDonohue

    Dynamic Measure in a tuple issue

    I have a report with a series of crosstabs and graphs that works fine with a static measure of Current Amount or YTD Amount. I created a prompt in the report so the user can switch between the 2 measures. I created a calculated measure using case when else. I added this calculated measure to my...
  17. RyanDonohue

    Scroll down to previous position after drilldown

    The issue that I have encountered is more of just a nuissance and would like to fix it if possible. In my report, I have several Crosstabs. Each crosstab has drilldown enabled and works fine. What I am experiencing, is when I scroll down to the bottom crosstab and drill into, the webpage...
  18. RyanDonohue

    Loss of drill up/down behavior for custom sets (using unions)

    Hello All, I am pretty new to Cognos, but have been having fun creating reports with custom sets using unions for items in the same hierarchy level until I realized this causes the issue of losing the ability to drill up or down. Is there anyway to enable drilling up/down for these sets? I...

Part and Inventory Search

Back
Top