If yes then I am not sure about the location because there is no folder inside new domain(Oracle_home1).

Hi, It was working perfectly before upgrade but triggering error now. I am assuming that we need to move ODBC.ini in new oracle home ( Oracle_home1). Thanks

After moving the driver in new oracle_home1 above error has vanished and now poping up new error as below. means OBIEE is net able to find correct odbc entry.(Not sure in which location in need to move odbc.ini file ) Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes:…

Thank you very much for your reply. I have copied it in new home (Oracle_home1), but still triggering error. Do you need to copy it at any specific location ? Thanks

Hi, Thanks for comment. I have implemented it successfully. After upgrade, I have observed error in few dashboards as below ( Do we need to move odbc.ini in new oracle home1 ? ) Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A…

What if we install the fresh 12.2.1.2 ? Will it come with installation or need to configure manually ? ..... Will follows the steps which you mentioned.

Appreciate it. Will check and let you know. Thank you very much.

Hi @Christian Berg Thanks for reply. 2. Reason: we had migrated from 11g to 12.2.1.0 six month back in parallel instance(Dev), and now we are upgrading from 12.2.1.0 to 12.2.1,2 3.Thanks for this option. Will search document to config it manually. It would be helpful if you can share any reference document. Thanks

1877648 Seems you dont have excel driver. Please open in other server where excel is installed. Thanks

Hi, We have done something similar. (m and k scale based on prompt) CASE When '@{var}{m}'='m' THEN "Fact"."@Fact"."@{var}{col}"/1000000 when '@{var}={m}'='k' THEN "Fact"."@{var}{col}"/1000 END Thanks

The document is cached when you use the app for the first time. This is when the 'Caching Duration' starts. For example, if you execute the mobile app for the first time at 4 PM with a 'Caching Duration' limit of 12 hrs, the document will be placed in the cache at 4 PM and remains there till 4 AM , so now we reduced time…

Thanks Gianni for reply, at least now I have roadmap to put effort on one direction. Will try to achieve through plugin and update one it will be completed.( will find alternate solution also). Thanks

Thanks Christian for reply. I am using data model for the Mobile App where case serve my purpose when I use oracle DB as source in rpd but not in essbase source.(User does not have provision to play with date. so next year column should rename or pick newly created column). I have implemented in OBIEE report however little…

Thanks Christian for reply. My requirement is something like below. 1) I need to display data from column 'DX 16FX' in year 2017. 2) In 2018 I need to display data from column 'DX 17FX' which will be crated and populated in end of year. 3) So if I will use case then it will trigger error like no column found. 4) I have…

https://server.com:port/mobile/viewer.jsp?_xma=/Apps+Library/FolderName/Application.xma?NQuser does not work which is logically work because same working in BIP report. Working solution :- https://server.com:port/mobile/viewer.jsp?_xma=/Apps+Library/FolderName/Application.xma?id=username?passwd:password which work in both…

Hi, The BI-MAD itself rotate it base on space available , and no option to play with x-axis label. Just to get it aligned in single line reduce the font size on x-axis and it will automatically fit base on width and height of frame. Bug reported by oracle team in 11.1.1.7.x. Thanks

Installation:- VD :-Easy Installation VA :-bit complex ( Require Installation and configuration) Connectivity (Data source) VD :- Excel , Saas , OBIEE , OBIEE report ( No Subject area ) VA :- No Cloud , only local DB (Cube and Relational DB ) OBIEE Logical layer : VD :- Logical query using Datamodel(Pre built analyse only…

Gianni option is perfect. Just for knowledge sharing . if you would like to achieve through xml Add the following tags and attributes to your Graph.xml <Y1Axis> <ViewFormat scaleFactorUsed="true" scaleFactor="SCALEFACTOR_NONE" /> </Y1Axis>

Hi, Are you referring "last modified date for user build query" physical query which hit DB or Direct database request query ?

Hi, If it was working till three days before then check with your admin, seems someone mess with config file. or trying to open in other Brower and check.