Cognos Analytics

 View Only

  • 1.  Dimensional reporting: setting context

    Posted Sun April 14, 2019 02:32 AM

    Hi, in a crosstab I would like to show in three rows the differents product lines (accessoires, camping,...). For the values I want to have the context of year 2013, but only for this three items, without dragging the year in front of this three lines. Moreover I do not want to add 3 explizit members, but only one line, if that ist possible.
    I tried something like set (member(aggregate tuple(currentMeasure,2013) within set [camping]);'camping';'camping');member2...)   but it only gives me error messages. Do you have a good way to set the context of another dimension for a set of three prouduct lines, without seeing the context in the crosstable?

    Thanks a lot,

    Ole



    ------------------------------
    Ole Schmidt
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Dimensional reporting: setting context

    Posted Tue April 16, 2019 11:09 AM
    Edited by System Fri January 20, 2023 04:38 PM
    Hello @Ole Schmidt
    Building on your expression, you can do something like the following:

    set(
    member(aggregate(tuple(currentMeasure,[2013]) within set [Camping Equipment]), '', 'Camping Equipment', [Sales (analysis)].[Products].[Products]),
    member(aggregate(tuple(currentMeasure,[2013]) within set [Golf Equipment]), '', 'Golf Equipment', [Sales (analysis)].[Products].[Products]),
    member(aggregate(tuple(currentMeasure,[2013]) within set [Outdoor Protection]), '', 'Outdoor Protection', [Sales (analysis)].[Products].[Products])

    )

    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Original Message