As I went through the OBIEE tutorial there were various things I wanted to implement which I couldn't figure out from the processes explained in the tutorial so I did some self-research and found something interesting using which I could do Ad Hoc reporting!!!
There is an option of setting up a prompt in the dashboard. How the process work is that you predetermine the column or columns over which you expect the user of the dashboard would want to use his discretion. You can select the possible values of those columns he can choose and then after selecting multiple columns and multiple values in each column you can add this prompt to your dashboard.
The benefit comes when the user wants to select some or all columns to view the data of or plot in the graph. This benefit allows the user to compare a set of value against the other set of value. And use the selected view to extract business information.
The universal benefit of this approach will help a single dashboard answer company wide queries. The same dashboard can be sent to all managers whether in the same department or different, they can choose to see the various products of their department and also compare their department's performance against some other department.
The one stop ad hoc reports are the real benefit the OBIEE provides, ANd I am glad I used them to the best in my homework 5
About Me
- AYUSH SAXENA
- a franciscan now a bitsian.loved my school days,have an endless list of frnds,love to meet good hearted interesting people,,love to go on adventures,play pranks on frnds,love speed biking,cs,soccer,gen timepass wd frnds chatting abt the days of joys passed.i dont like to add unknown people to my profile.a hardcore pessimist,an atheist,love my family.hate pretence and immaturity.too possesive for the things i love,will go to any extent to get my job done,i love all my friends and will do anything for them.