Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Carlos. Try this then. https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-014104F7-13F2-47B7-BD68-AB948132ABAB.htm#BIPAD390 Update*. Have a read at the Overview first. https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-350FFE8C-B3A4-4C21-BC0E-65C9E733CF58.htm#BIPAD4784 Let us know the results. Regards. Fernando
-
Hello Carlos. I'm assuming you are using BIP within OBIEE. Please have a read a link below and search for the Command Line Utility RUNCAT. https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-65D7594D-6F3D-4AD8-9002-F9A2C4503A03.htm#BIESG2905 Command Line Utility — You can invoke the command line utility on supported…
-
Hi Antoine. I would open an SR. They may have some additional information that we may be missing. One additional test. The report properties. How is the last property configured to you, the one at the bottom of the Formatting Tab. My reports where upgraded from 11g 1.1.5 all the way to 12c and some still hold the setting…
-
Hi Antoine. So many places to change the timezone and none is being fully respected by BIP. I know that if you change some of your properties you need to log off and log in again for them to take effect. Are we missing something!? Fernando
-
Hi Antoine. My default for Report Timezone is JVM. That is on the FO processing, not sure it will apply on this case. If you can test move your timezone one hour less and the results should display as expected. This will make a case to Oracle to see that some or the report properties are not been respected when you change…
-
Figure 2
-
Hi Antoine Not sure why you are getting that differently. I did some demo before replying and almost all dates worked for me. This is my example. (I'm in New Zealand timezone) Figure 1 shows the results of my report. Figure 2 shows the properties of my report. Just to check I am accessing the latest model and template I…
-
Hi Antoine. The "Date Format" is in the Data Model of your report. If you have access to it just click in the cog icon on the right of the attribute and then go to properties. More here. Setting Element Properties https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-6B54EDCE-5F3A-4A1E-89F0-99BAEA6FD43C.htm#BIPDM274…
-
Hi Xavier. Using your example. LOV that populates P2 should have the query containing the P1 parameter: Ex 1.: SELECT <cols> FROM <table> WHERE <attribute_filter> = :P1 You should then set the option REFRESH OTHER PARAMETERS ON CHANGE checked on the P1 parameter. You may need to work out a little the LOV query as you may…
-
Hi Antoine. Can you try the following (if you have access to do so)? 1. On the Data Model navigate to the properties of your date attribute and set the Date Format to "Date & Time" (Usually it defaults to timezone option). 2. In the Report Template try change the following for the date attribute: Data Formatting > Ignore…
-
Hi Antoine. Are you able to tell us what is the Timezone setting for your account on BI Publisher preferences? You may also find this useful. https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2565 Please read the first NOTE. Regards. Fernando
-
Hi Hendrik. Another update on my tests. I made a new template. This time I built an eText template in an RTF and enables outputs for text and csv. Exporting works fine using schedule to text. Once I change to CSV this is the result. The Data Model option "Enable export to CSV" is disable on both cases. Cheers. Fernando
-
Hi Hendrik. Thanks for that reply. Really just wonder if this is something they changed on purpose or a bug from 2013 which solution was not included in the latest version. Tried to find any way to configure this in many different parts of the product. No luck. Cheers. Fernando
-
Hi. It can connect to Database Cloud Service, yes. https://docs.oracle.com/en/cloud/paas/data-visualization-cloud/bidvc/creating-database-connections.html On premises databases have a look here. http://www.ateam-oracle.com/configuring-the-remote-data-connector-rdc-for-bi-cloud-service-bics/…
-
Hi. It is possible on the Narrate visualization. You can Show or Hide all filters used in a Canvas once you add it to the Narrative. Use the Narrate tab instead of the Visualization tab if you are using Data Visualization Desktop in a presentation or in a big screen. Cheers. Fernando
-
Hi. Risky option is to install the plugins on the other machine to see if the problem can be reproduced. If yes then I recommend opening an SR with Oracle. It may be even a language issue. Boa sorte tche. Cheers. Fernando
-
Hi. Did you experience similar issue on another machine? Did you try clean any remaining folder or install in another folder? Cheers. Fernando
-
Hello. Maybe you hit this issue. Oracle Support Document 2150224.1 (DVD: Data Visualization Desktop Fails To Start And Hangs With Blue Progress Bar) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2150224.1 https://support.oracle.com/epmos/faces/DocumentDisplay?id=2150224.1 Cheers. Fernando
-
Hi. Starting with the basics. Can you confirm you are running DVD4 at least on this kind of machine? System requirements: Operating System: Microsoft Windows x64 (64-bit) 7 SP1+, 8.1, or 10; Windows Server 2012 or 2012 R2; Mac OS Yosemite (10.10), El Capitan (10.11), Sierra (10.12) CPU: Intel(R) Core(TM)2 Duo CPU E8400 @…
-
Hi. In addition to Gianni's comments. If you want to share the project do it by exporting the project. Click in Share > File > Format Package (dva) It is more secure and you don't mess with the tool files. Cheers. Fernando