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
Oracle BI Delivers - Issue
Hi Folks
This query is regarding BI Delivers / iBots / Agents.
I would like to know if there's any way whether OBIEE will recognize on individual record basis. I have a requirement as below with Mgrs, Reportees and their sales figures. This is single report but Managers want to see their own data by scheduling this report
| Manager | Reportee | Sales Figure1 | Sales Figure 2 | Sales Figure3 |
|---|---|---|---|---|
| Manager1 | R1 | 50 | 100 | 150 |
| Manager1 | R2 | 20 | 40 | 60 |
| Manager1 | R3 | 30 | 60 | 90 |
| Manager2 | R4 | 40 | 80 | 120 |
| Manager2 | R5 | 40 | 70 | 30 |
| Manager2 | R6 | 10 | 20 | 20 |
| Manager3 | R7 | 50 | 50 | 50 |
| Manager3 | R8 | 70 | 80 | 60 |
| Manager4 | R9 | 30 | 30 | 20 |
| Manager5 | R10 | 10 | 40 | 40 |
Manager 4 --> has to get his records in excel (i.e.only 1 record)
Manager 1 --> has to get his records in excel (i.e. 3 records)
..
..
..
should be the same for remaining managers.
Will this be done through Oracle BI agents/delivers. I cant create individual reports of each manager and send it their email ID as there are 100's of managers. Any help will be great on this
Thanks
Answers
-
Is this what you are looking for =>
0 -
Hi Robert, Thanks for the link and your prompt reply.
I am checking the link and will post my queries. Expecting mostly it will fit
0