Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 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
Saved Personal Filters
Summary
Can our users save their reporting preferences?
Content
Hi all - I have users that will export their report, slice it a variety of ways, and then send off to their customers for further use. Is there a way that they can save a customized set of filters? Effectively then, they would run the master report, apply filter 1, export report 1, apply filter 2, export report 2, etc.
I know this is possible to do with Excel macros. However, I am hoping to find a way to make it a little more efficient for them.
This option would be needed for both OTBI and BIP reports.
Thank you!
Answers
-
Hi Prudence,
You mentioned that the filters are to be applied post export (that is outside the application) in this case you would need to devise some way in excel only.
One may create multiple filters and then create different dashboards/ bi-reports though (but would still take some effort and wont be as simple as you want it to be).
Experts might suggest better solution.
Good to have an opinion of product development team too.
Kind Regards
Ashish
0 -
In case of BIP report, Bursting can be used to filter data and export to different files. The query will be run once, data will be fetched once as well, but will be exported into different files post filtering.
For OTBI, again multiple views, with different filter criteria applied, can be created out of a single big initial analysis. These views can be placed on multiple pages of a dashboard and can be scheduled to deliver via agents.
0 -
Thanks Ashish - I'll keep thinking!
0 -
Shakher - thank you! Is there a way to read more about Bursting? I have heard people mention this before, but in reading the documentation it's a little more technical, so wasn't sure if there was a Bursting for Dummies?
0 -
BI Publisher Bursting feels tricky in the starting. Following are some useful resources:
https://www.youtube.com/watch?v=dvSrZBuhAZ4
https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T555155.htm
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi//bip/advancedbip/advancedbip.htm#t6
https://docs.oracle.com/cd/E29542_01/bi.1111/e22258/add_burst_def.htm#BIPDM352Since you need to send files to customers, I believe you need to concentrate on using EMAIL delivery channel.
0 -
Thank you Shakher - I appreciate the information and will read through all of these.
0