Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Variable Date Value in Scheduled Analysis Report
Hello,
I'm attempting to create a scheduled report for a preexisting analysis.
The report would run indefinitely and deliver to my email on a daily basis.
I'm trying to figure out how configure a variable within that report so that it runs for the correct period number (1-12) depending on the date the analysis/report is run.
Any advice for determining how to set that up would be greatly appreciated.
Thank you
Answers
-
By 1-12, do you mean month numbers?
0 -
Yes, they represent fiscal months specifically in my case, not necessarily calendar months. There is some overlap since each segment of 7 days Sun-Sat is always within one fiscal period.
0 -
If you have a date dimension then you could add the fiscal month period as an attribute to the date dimension and then you can very easily derive the period each date belongs to.
0 -
If you want to run the report on the basis of Current Month only, then you can use the DATE Functions present in OBIEE Answers section:
0 -
Thank you for your responses. I'm afraid I wasn't specific enough in my initial post.
What I'm looking for is a way to automate the report so that it runs daily and always selects data from the current period, based on whichever period that day is in. I'd rather have the report know which period to pull data for than needing to manually change the period manually each time the period changes.
0 -
I would say both replies you had before were pointing there.
The problem is in the meaning of things:
JosephX wrote:it runs daily and always selects data from the current period, based on whichever period that day is in
There isn't something called "current period" having a universal meaning.
"Current period" generally has a business meaning which change from company to company, from project to project.
You need to able to clearly define what current period means first, based on that written meaning of "current period" you can easily translate into a logical condition producing it. The final technical solution can be different based on the meaning of current period.
So, is "current period" strictly related to the real current date/time? In that case, as SonPath99 said, you can use OBIEE embedded functions to build that value and replace your hardcoded filter.
If it has a different logical meaning you can do as Joel said: add a column on your time dimension with the value of "current period" for every day, and in your analysis use that relation to go from the current real date/time to the "current period" value you are after.
But everything depends on the meaning of "current period".
0
