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: *

  • Users: MrTy
  • Order by date
  1. MrTy

    Using Comparison Operators with sets and members

    Thanks, Blom for the response, but I talking about comparison operators. The users guide covers this in the dimension coercion section, but to be fair does not really provide any good examples. What I'm trying to do is this: The columns are the twelve months of the fiscal year starting with...
  2. MrTy

    Using Comparison Operators with sets and members

    Well, I figured it out. The "in" and "not in" operators do not apparently work or I'm still missing something in their syntax. If anyone has some insight on this, I would appreciate it.
  3. MrTy

    Using Comparison Operators with sets and members

    New update. It is now returning results, but only Budgeted for all rows, regardless of the currentMember([PLSummTM1].[Periods].[Periods]) member. (I had removed currentMember() from the dataitem after my first post in trying different things) If I swap Actual for Budget in the THEN...ELSE...
  4. MrTy

    Using Comparison Operators with sets and members

    Okay, the parsing problem is resolved! Needed parathesis around the subject of the "in" operand. Now, however, I get no results, just "--" in the crosstab. Also, the validate on the dataitem itself does not like the if statement. Complains it is looking for a member and the parameter being...
  5. MrTy

    Using Comparison Operators with sets and members

    According to COGNOS documentation, one should be able to use these operators: =, <>, in, and not in. For example: currentMember([Period].[Years].[Years]) in [ThisYearPeriodsToDate] and have it return TRUE if the currentMember is in the set [ThisYearPeriodsToDate]. I am trying the following...
  6. MrTy

    COGNOS - prompts in dynamic columns and slicer sets

    My report should use single prompt that determines the value used for slicer set and also determines the value of tuple arguement. The problem is one or the other will work, but if both are implemented, it fails. Below is what works in each instance: This calculated measure used the...
  7. MrTy

    Dynamic Measure in a tuple issue

    No problem, thanks for responding! I have had a time with the rolevalue. I've tried to just put it in a data item and cannot get an expected result. I'll play with it some more. I'm thinking the only way to achieve this is through dual columns and hide as needed. Thanks again and chat with...
  8. MrTy

    Dynamic selection in cascading prompts

    If you are reporting from a dimensional model, use one of the dimensional functions. firstchild([Camping Equipment]) will return the first child. You might try FirstChild(currentmember([productline hierarchy])). I'm not sure what the hierarchy name is, but this may work for you.
  9. MrTy

    Dynamic Measure in a tuple issue

    Ryan, How did you do the conditional measure? I've done some, but I'm needing to do it within the framework of a tuple. The dynamic argument is currency.
  10. MrTy

    Dynamic Measure in a tuple issue

    Hey, Ray, when you get a chance, I'd like to know more about that conditional you use in the calculated measure to determine which set is being used. I have a report like yours also, but simply used a seperate calc under each set.
  11. MrTy

    Dynamic Measure in a tuple issue

    I just finished up an identical report as you described and pretty much the same way. This one is different however. Here is a small example: _________Jul 10______Aug 10_____Sep 10_____Oct 10 Jul Actual Forecast Forecast Forecast TOTAL Aug Actual Actual Forecast...
  12. MrTy

    Newb questions

    Is there anyway in a calculated measure (or other item) to compare members of a set or hierarchy? For example, I need a waterfall report: CASE WHEN [RowFiscalPeriod] <= [ColFiscalPeriod] THEN [Actual] ELSE [Forecast] END The columns are all the months of the designated fiscal year and the...
  13. MrTy

    Dynamic Measure in a tuple issue

    Ryan, I am something of a newbie to dimensional reporting, although in the last few weeks, I've gained a LOT of ground. You describe something in your post I'd like to know more about: calculated measures with case statements. I have been unable to do that in my crosstabs, but I'm trying to...

Part and Inventory Search

Back
Top