Although there is slowness in loading the templates, its not seven minutes, its takes about 15- 20 seconds for the template to come up. There is a separate admin team which takes care of this and I believe this patch is applied. Two things, 1. We noticed that when a report returning more than 20k rows is run by multiple…

Thanks for the response. I have changed the parameters. 500 records in OBIEE dashboard takes less than a minute 5k and 12k records in obiee dashboard and in BI Publisher - 3 minutes and 7 minutes I have changed the parameters u have specified. i'll keep you posted. thanks again.

Hey sherry, thanks for responding. The query brings when run for the same dates, comes back in 3 seconds. I am under the impression that, it kind of paginates and brings only 500 records at a time(please correct me if I am wrong) as it says records 1-500 at the bottom. To see the exact time, i export the data to a file…

Thanks Brajesh, I will try this and get back to you. Appreciate your response.

you can create two datasets and link them. This will depend on your requirement. or write a SQL with DB links to the other DB. Regards K

Hey Brajesh, thanks for the response. can you please elaborate on the ' 4. In the before report trigger execute the sql using DBLINK and populate one global temporary table 5. Create Data set for that global temporary table where you can pick the records. ' I did not completely understand this. Regards

Hey brajesh, Appreciate your quick reply. Q1. yes we have different DBs where the same tables exist. we have 16 distributors whose data centers reside at different locations. Q2. yes we have access to all DBs and if we dont, we can get the access Q3. We can have DB links. i was not sure if we can have a drop down of DB…

Thanks 2807661, let me try this.

Thanks Thomas, let me try this.

thanks so much Ahmed for your reply. User has ad hoc access. they want to create their own reports. so in answers when they use this field they do not want to see a calendar because the field only contains 2 dates per month. beginning and end. they are comfortable with discoverer doing this for them. They want the same in…

Hey Sherry, Appreciate your taking time out. i used an evaluate on the date field to convert it to char in the RPD and i brought the format to - DD-MON-YYYY. when i use it as descriptor it shows up as the above. not sure why. then i try filtering it, it throws an error. problem is they also want to do a greater than or…

Hey Sherry, thanks for the response, I tried using a date field as the descriptor and since I use this as the descriptor following happens filter is still a calendar. not able to work it out into a dropdown. Can someone help. confirmation of the possibility ? regards Kriparam

thanks, i am new to BIP. just learnng

thanks Gianni. appreciate the quick response. I was apprehensive about the approach. thanks for clearing it for me thanks Christian.

Hey Gianni, My Dashboard concept is good. i will definitely suggest this. lets see what turns up. thanks for the reply

Hey Christian, thanks for the answer. just to clearly understand. lets say I have 50 reports and each user has access to about 2 reports. Ill have to create approximately 25 roles for the report split is it ? any other way to simplify this ? please let me know. thanks