Cognos Analytics

Expand all | Collapse all

developerworks Cognos articles

  • 1.  developerworks Cognos articles

    Posted Mon April 12, 2021 06:23 AM
    Hi friends,
    I was searching some articles regarding relative time measures in FM .
    I remeber an old articles on developerworks site but developerworsk site is not reachable anymore.
    What happened to all the articles and pdf on Cognos on the developerworks?
    Where can i find and consult them?

    Thanks & regards

    ------------------------------
    Leonardo Russo
    ------------------------------


  • 2.  RE: developerworks Cognos articles

    Posted Tue April 13, 2021 06:27 AM

    Magnum BI – I have played with Relative Time quite a bit and from experience, the best solution we have found is to add relative time fields into a conformed date dimension in the mart.  Please advise if you like to see a further elaboration of our implementation.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     






  • 3.  RE: developerworks Cognos articles

    Posted Tue April 13, 2021 08:54 AM
    Hi Mr Chan,from your experience would you explain me further how would be a good solution for my problem?
    I have found that Data module doesn't fulfill my situation.
    I would like to build a robust a fm package with all fields simple and ready for without doing calculation on reports.


    Thanks for your answer and your collaboration.

    ------------------------------
    Magnum BI
    ------------------------------



  • 4.  RE: developerworks Cognos articles

    Posted 30 days ago

    Magnum BI – so what we have done in the past is to augment our Date Dimension in our mart to add additional fields, I have cut and pasted a snippet of our Date Dimension, the following are some notes:

    -          Assuming today is April 1, 2021

    -          Our date dim in this case is at the month grain.  We have it in the day grain, but for demo purposes, I decided month as the post would have been super big

    -          We then calculate and add columns Relative Year and Relative Month

    o   Note: we have many other relative fields like year, month, quarter, day, but just didn't note this

    -          Once you have these additional fields, you can add levels to an existing FM query package assuming you are creating DMR query packages.  You can also add additional hierarchies, one for standard date and one for relative date

     

    Hope this helps.

     

    Year

    Month

    Date

    Relative Year

    Relative Year Desc

    Relative Month

    Relative Month Desc

    Today

    2020

    2020-Jan

    1-Jan-20

    -1

    Previous Year

    -15

    15 Months Previous

    1-Apr-21

    2020

    2020-Feb

    1-Feb-20

    -1

    Previous Year

    -14

    14 Months Previous

    1-Apr-21

    2020

    2020-Mar

    1-Mar-20

    -1

    Previous Year

    -13

    13 Months Previous

    1-Apr-21

    2020

    2020-Apr

    1-Apr-20

    -1

    Previous Year

    -12

    12 Months Previous

    1-Apr-21

    2020

    2020-May

    1-May-20

    -1

    Previous Year

    -11

    11 Months Previous

    1-Apr-21

    2020

    2020-Jun

    1-Jun-20

    -1

    Previous Year

    -10

    10 Months Previous

    1-Apr-21

    2020

    2020-Jul

    1-Jul-20

    -1

    Previous Year

    -9

    9 Months Previous

    1-Apr-21

    2020

    2020-Aug

    1-Aug-20

    -1

    Previous Year

    -8

    8 Months Previous

    1-Apr-21

    2020

    2020-Sep

    1-Sep-20

    -1

    Previous Year

    -7

    7 Months Previous

    1-Apr-21

    2020

    2020-Oct

    1-Oct-20

    -1

    Previous Year

    -6

    6 Months Previous

    1-Apr-21

    2020

    2020-Nov

    1-Nov-20

    -1

    Previous Year

    -5

    5 Months Previous

    1-Apr-21

    2020

    2020-Dec

    1-Dec-20

    -1

    Previous Year

    -4

    4 Months Previous

    1-Apr-21

    2021

    2021-Jan

    1-Jan-21

    0

    Current Year

    -3

    3 Months Previous

    1-Apr-21

    2021

    2021-Feb

    1-Feb-21

    0

    Current Year

    -2

    2 Months Previous

    1-Apr-21

    2021

    2021-Mar

    1-Mar-21

    0

    Current Year

    -1

    Previous Month

    1-Apr-21

    2021

    2021-Apr

    1-Apr-21

    0

    Current Year

    0

    Current Month

    1-Apr-21

    2021

    2021-May

    1-May-21

    0

    Current Year

    1

    Next Month

    1-Apr-21

    2021

    2021-Jun

    1-Jun-21

    0

    Current Year

    2

    2 Months in the Future

    1-Apr-21

    2021

    2021-Jul

    1-Jul-21

    0

    Current Year

    3

    3 Months in the Future

    1-Apr-21

    2021

    2021-Aug

    1-Aug-21

    0

    Current Year

    4

    4 Months in the Future

    1-Apr-21

    2021

    2021-Sep

    1-Sep-21

    0

    Current Year

    5

    5 Months in the Future

    1-Apr-21

    2021

    2021-Oct

    1-Oct-21

    0

    Current Year

    6

    6 Months in the Future

    1-Apr-21

    2021

    2021-Nov

    1-Nov-21

    0

    Current Year

    7

    7 Months in the Future

    1-Apr-21

    2021

    2021-Dec

    1-Dec-21

    0

    Current Year

    8

    8 Months in the Future

    1-Apr-21

    2022

    2022-Jan

    1-Jan-22

    1

    Future Year

    9

    9 Months in the Future

    1-Apr-21

    2022

    2022-Feb

    1-Feb-22

    1

    Future Year

    10

    10 Months in the Future

    1-Apr-21

    2022

    2022-Mar

    1-Mar-22

    1

    Future Year

    11

    11 Months in the Future

    1-Apr-21

    2022

    2022-Apr

    1-Apr-22

    1

    Future Year

    12

    12 Months in the Future

    1-Apr-21

    2022

    2022-May

    1-May-22

    1

    Future Year

    13

    13 Months in the Future

    1-Apr-21

    2022

    2022-Jun

    1-Jun-22

    1

    Future Year

    14

    14 Months in the Future

    1-Apr-21

    2022

    2022-Jul

    1-Jul-22

    1

    Future Year

    15

    15 Months in the Future

    1-Apr-21

    2022

    2022-Aug

    1-Aug-22

    1

    Future Year

    16

    16 Months in the Future

    1-Apr-21

    2022

    2022-Sep

    1-Sep-22

    1

    Future Year

    17

    17 Months in the Future

    1-Apr-21

    2022

    2022-Oct

    1-Oct-22

    1

    Future Year

    18

    18 Months in the Future

    1-Apr-21

    2022

    2022-Nov

    1-Nov-22

    1

    Future Year

    19

    19 Months in the Future

    1-Apr-21

    2022

    2022-Dec

    1-Dec-22

    1

    Future Year

    20

    20 Months in the Future

    1-Apr-21

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     






  • 5.  RE: developerworks Cognos articles

    Posted Tue April 13, 2021 08:59 AM
    Hi Leonardo

    You should be able to find the information on one of these sites. 

    https://developer.ibm.com
    http://www.redbooks.ibm.com/Redbooks.nsf/domains/analytics

    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 6.  RE: developerworks Cognos articles

    Posted Tue April 13, 2021 09:53 AM
    Thanks Trevor, unfortunately i haven't found any ot fhose old pdf articles inside these two sites.


    IBM,please make all those pdf available again, they were very helpful!

    ------------------------------
    Magnum BI
    ------------------------------



  • 7.  RE: developerworks Cognos articles

    Posted 30 days ago
    Leonardo,

    I have a couple older documents saved. One created by Paul Prieto and one documenting an enhancement to his approach that was proposed for another customer that needed to be able to perform relative analysis based on a selected time period. I should ask though if you have looked at the relative time feature of data modules which have improved significantly. There are still some modeling scenarios that require FM such as user lookup style data security.

    ------------------------------
    Robert Hofstetter
    ------------------------------

    Attachment(s)



  • 8.  RE: developerworks Cognos articles

    Posted 29 days ago
    Thank you community,
    i have found the answers to my case.

    to answer to Mr  Hofstetter:
    I have tried to use data module and relative filters but the functionality of the relative time in a module is calculated based on the _as_of_date value, which uses the current date as its reference point. (i know is possible to change it but i don't have rights to access to manage area and customization)...

    My wish is I would like to select with a prompt my period base from which make all the relative calculation or filtering.
    Is it possible to substitute the _as_of_date expression with a prompt macro?
    I have tried to modify and substitute in a filter for YTD the _as_of_date expression this but gives me error.

    // This is a template expression that is used by the column property 'Lookup reference'.
    // To pass validation, the line below must remain as a comment. Do not remove the forward slashes.
    // validate: 1 = 1
    #$_this.parent.idForExpression# >=
    #queryValue($_this.parent.split.ref + '.dYear',
    $_this.parent.split.ref + '.TheDate = ' + prompt ('pDate','date')#
    AND
    #$_this.parent.idForExpression# <= # prompt ('pDate','date') #


    anyway
    Thanks !

    ------------------------------
    Magnum BI
    ------------------------------



  • 9.  RE: developerworks Cognos articles

    Posted 30 days ago

    If you're looking for a developerWorks forum - Don't panic!

    You are in the right place. You are here because specific IBM developerWorks forums, blogs and other Connections content have been decommissioned. This page will help you find the content you are looking for, get answers to your questions, and find a new community to call home.

    https://community.ibm.com/community/user/legacy?lang=en
    ----------------------------------------------------------------------

    I found this when selecting one of my old DW links.



    ------------------------------
    TREVOR COMEAU
    ------------------------------



  • 10.  RE: developerworks Cognos articles

    Posted 29 days ago

    As a general point, a lot of the DeveloperWorks articles have been moved to the IBM Documentation site as well as (not surprisingly) documentation

    https://www.ibm.com/docs/en



    ------------------------------
    MATTHEW ROBINSON
    ------------------------------