Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
weekly data report

Hi all,
I have the following requirement.
I have two filter parameters 1. year and 2. month.
If he selects month in the filter, report should display weekly data (based on month).
Note : It's cloud instance. I dont have access to rpd.
The report should display is in the following way.
Name of Transporter | Fiscal Week 1 | Fiscal Week 2 | …………. | MTD |
Truck Fulfilment | Truck Fulfilment | Truck Fulfilment | Truck Fulfilment | |
Transporter A | '=B/E= accepted shipments/ total # of shipments | '=B/E= accepted shipments/ total # of shipments | '=B/E= accepted shipments/ total # of shipments | Sum = w1+w2+.. |
Transporter B | ||||
Transporter C |
When the user sees the truck fulfillment in Fiscal Week, they should be able to click on it to drill down to a day-wise view of the same.
How to achieve the weekly data based on month filter (it''s 445 calender)
If he select Jan month first 4 weeks should display and vice versa.
Regards,
Ram
Answers
-
Not quite clear on your requirement. Correct me if I'm wrong. Do you require to display data in a weekly format if Month is selected? What should happen if Year is selected without a Month value?
0 -
Hi,
I have requirement like this...
I have dashboard prompt with year (defaulted current year) and month (defaulted current month) as filters.
I have two reports.
1. yearly data (based on year filter).
2. weekly data (based on month filter) - report shown as above - how to achieve this?
Please let me know any further clarifications on requirement.
Regards,
Shubham
0 -
so what are the conditions for displaying the yearly or monthly reports?
All you need is to put both reports on a dashboard in different sections and then you apply a condition on each section. The condition will determine whether or not the section is displayed.
To achieve this you could have a third dashboard prompt, maybe "Report Type" ( for example, which has 2 values:
Yearly
Monthly
The new Prompt should populate a variable and you then pass this variable to the sections described above.
0 -
Hi,
My requirement is like this,
I have dashboard prompt with year and month columns.
I have two reports one is yearly report and another is month report. Both reports should be displayed.
I am clear on yearly report ..here i have year column in the report and made this column as Is Prompted so my report will filter based year column in the dashboard prompt.
I am not clear on the second report which is filter based on month you select (JAN, Feb,Mar etc) in the dashboard prompt.
My report does not contain month column. Report is having week column. Based on month you select, my report should be displayed all the weeks in that month. How to achieve this? I have given the week report in my first thread. Please see the report once.
Regards,
Ram
0 -
just add an is Prompted Month filter to this report and it should restrict the report the the prompted Month from Dashboard Prompt. It doesn't have to be a display column.
0