Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI 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
