| OBIEE report filter and delivery [message #472769] |
Mon, 23 August 2010 16:23  |
shivjoshi9928gmailcom
Messages: 1
Registered: August 2010
|
Junior Member |
|
|
Hi All,
One of my reports (with 20 cols) consists of multiple rows with repeated customer names (about 100 distinct customer names and approx total 5000 rows). We wanted to automatically filter out the report on customer names and send the filtered reports to the respective customers. So these 100 customers will receive their own 50 rows. We were wondering how we should go about doing this. We thought of maybe using a) iBots or b) GO URL with dummy dashboard. I was wondering if anyone has experience tackling this issue and what will be the high level design steps that will be required.
Thanks.
~Shiv
|
|
|
|
| Re: OBIEE report filter and delivery [message #472876 is a reply to message #472769] |
Tue, 24 August 2010 09:47  |
heedtheball
Messages: 6
Registered: August 2010
|
Junior Member |
|
|
|
Guys, I would go with iBots; you can setup a request and have it scheduled to be emailed at regular interviews and choose the level of data to send the recipient - possibly different for each recipient. No more administration / maintenance beyond that. Using the GoURL is going to be a bit of a chew on ...
|
|
|
|
| Re: OBIEE report filter and delivery [message #481428 is a reply to message #472876] |
Wed, 03 November 2010 08:27 |
vdoru
Messages: 2
Registered: March 2008
|
Junior Member |
|
|
|
What you need is called report bursting or report file breaking. DocumentBurster( www.pdfburst.com ) is a good application which can burst and split the reports the way you are describing here. If you are interested, you can find here the documentation on how to break the reports using DocumentBurster( www.pdfburst.com/docs.html ).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
