on 09-28-2017 7:32 PM
Hi,
I have bunch of reports coming from a universe(all objects comes from various views). We are on BO 4.2 SP4 and database is sqlserver 2016. ODBC connection created with SQL Server Native Client 11(compatible version)
When I refresh these reports they just keep on running and never pop up Prompt box. I did execute the reports queries in Database and they seem to bring data in few sec's. I tried to parse the objects used in these reports in Unvierse - they keep on running and throw a timeout error. I did make changes to bunch of files with parameter timeout as NO - still doesn't work.
Same reports in our current production environment on Oracle DB works absolutely fine.
Need suggestions to troubleshoot the issue. Please Advise.
Does the LOV of your dimension uses underlying fact table rather than dimension table? If so make sure it uses the dimension table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.