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
------------------------------
Original Message:
Sent: Wed April 14, 2021 12:57 PM
From: Robert Hofstetter
Subject: developerworks Cognos articles
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
Original Message:
Sent: Mon April 12, 2021 06:23 AM
From: Magnum BI
Subject: developerworks Cognos articles
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
------------------------------
#CognosAnalyticswithWatson