- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Last 3 months data dynamically
We have Date_1 column with timestamp data type (9/30/2010 12:00:00 AM), we converted to month year format as Date_2 (SEP 2010) and using converted format Date_2 in the report and graph.
Also we are using Date_2 as dashboard prompt requirement is, in the report and graph when we open by default it as to show last 3 months data and it as to change dynamically every month.
As of we are hardcoding using presentation variables every month can anyone suggest how we can achieve this dynamically.
Version we are using: OBIEE 126.96.36.199.0