Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How can i display the value of "Current Month" in a report
Hi everyone ,
IF i want to display the measure of the current Month and the current month in a report , without updating it every month ? what is the easiest way to do it ??
Thank youu !
Answers
-
rpd variable
or
MONTH(CURRENT_DATE)
MONTHNAME(CURRENT_DATE)
0 -
*if* that variable exists...
0 -
*if* everything exists!
0 -
"if" the model has a time dimension...
0 -
select sysdate from dual;
0 -
i have a time dimension , in cognos i used to do smthg like :
IF [Dimension ... ].[..]..[Month]= Current month , then ("Total of my measure") else 0
i dont wanna just display the "Month" But the measure of the month , if we are in february " I should display the february results " , in march ... and so on .
0 -
okey , and if i want to filter on the measure of the month ?
0 -
Use CURRENT_DATE and all the existing OBIEE functions on dates to generate the required filter based on your data (depends how you need the filter to look like, if "Feb 2017" or "201702" or 2017-02-28 as a date etc.).
A filter in an analysis is not just a static value, you can add functions etc.
0 -
You can use the filter in the filter section preferably I think. Not in the column formula if I understand your question correctly
0
