Error : [2016-04-13T03:39:29.000-07:00] [OracleBIServerComponent] [TRACE:7] [USER-34] [] [ecid: 08b36aff96406675:75e2d056:1538086e548:-8000-000000000024923f,0:1:9:5] [tid: 55fe0940] [requestid: 396d001c] [sessionid: 396d0000] [username: weblogic] -------------------- Query Status: [nQSError: 42015] Cannot function ship the…

Hi Christian thank you for prompt response, This is my Evaluate expression formula Evaluate( NVL(%1,%2),Evaluate( DB function,) , D904.c13) and BI server log says [2016-04-12T22:55:28.000-07:00] [OracleBIServerComponent] [TRACE:7] [USER-34] [] [ecid: 08b36aff96406675:75e2d056:1538086e548:-8000-0000000000243fc5,0:1:9:5]…

Hi , Thank you for your response . Here my doubt is why i need to have the DB function in two databases ?? DB function exist at one data base using this database table i derived the my Evaluate expression and my evaluate function is valid,which is working fine. I just want one column from Data base B and another column…

But same Evaluate function Logical column been used for some other reports and those are working fine. When i use the Evaluate logical column for one report which is basically using two tables between two oracle databases that report causing the issue as Message returned from OBIS. [nQSError: 43119] Query Failed:…

Thank you for your suggestions ... Still am having some doubts .. if i have a automate cache script which is CALL SAPURGEALLCACHE() . If i schedule this batch script file will it be automatically clear Close All Cursors in BI presentation server ?? Once this CALL SAPURGEALLCACHE() procedure schedule automatically will it…

Am also having same requirement ...let me know how you fixed this issue .

thank you so much for your help .its helpful

If i disable other LTS then report gives error page .

Thank you for the response . In the Content tab i set Detail level for all the three tables .

Hi Kamna and Gianni. Here is my requirement ..actually i have one logical column been used in the Report , this logical column sources from multiple table physical columns . In the BI server query i want the right table to be used for that what i did, i kept priority as 0 only for one table for remaining table i made it 1…

Thank you i tried and it worked ....i edited the dashboard and report condition i mentioned as rowcount(columnname)>0 or ROWCOUNT('Batch Control_Int_Period') ==0 Thank you so much for your help ..

Thank you will try .....can you elaborate Pls

Still i want to clarify that is there any other option that we can control BI server query to apply right fact table other than Priority . Please clarify . Thank you for your prompt response its really helpful to me .

Thank you for the response . still am not clear . here is i want , required user input mean that you have to select or provide some input to Prompt then this input value been prompted in the Results. this is what happen if i understand correctly . Even though user doesn't provide the any prompt value or input values, any…

Thanks you So much for quick response . What ever you suggested i followed , even though my desired fact table is not applied int he BI server query .

Awesome ... One final clarification . I already installed Admin client tool in my local system , it has MigrateEUL.exe file but it doesn't have the MigrationConfig.Properties file .So can i copy MigrationConfig.Properties file from some machine where OBIEE(11.1.1.7.150120) server installed fully and then paste the…

Does it mean, we have to have same OBIEE(11.1.1.7.150120) installation in a Windows machine, then Migrate Discover to OBIEE RPD 11.1.1.7.150120, Once Discover(EUL) been migrated to OBIEE RPD then get the RPD file and deploy into the Linux server .Is this right approach to do migration. Appreciate your help.

Thank you so much Christian for prompt response... still am having some doubts Actually i want to Migrate Oracle Discover (test.eex) meta data to OBIEE(11.1.1.7.150120) installed on Linux box , as per your above answer will it not possible to Migrate Discover to OBIEE Linux Server ?? Could you please clarify. Suppose if i…