tihaser.blogg.se

1. #BI PUBLISHER ADD IN NOT SHOWING IN WORD FULL#
2. #BI PUBLISHER ADD IN NOT SHOWING IN WORD CODE#
3. #BI PUBLISHER ADD IN NOT SHOWING IN WORD PASSWORD#
4. #BI PUBLISHER ADD IN NOT SHOWING IN WORD PLUS#
5. #BI PUBLISHER ADD IN NOT SHOWING IN WORD DOWNLOAD#

If the users time zone could be queried out of the BI Publisher, it could be used in the Region portion and dynamically adjust the time zone. Oracle has published a list of configured regions that can be used in the Time Zone ID portion of the XLST. One challenge I cannot resolve is dynamically returning the users time zone in BI Publisher. In the BI Publisher properties window, this would look like the following: To convert a date or date / time, the following XLST tag in the BI Publisher properties window:įor instance, to convert the date to the format MM/DD/YYYY and convert the time zone to Pacific Time, use the following XLST: Instead, use the built in capability of XLST in the RTF template to provide date or date / time format masking capability.

#BI PUBLISHER ADD IN NOT SHOWING IN WORD CODE#

Add one blank column to the report and hard code value ‘2’ for sorting purpose and edit column formula of reporting state as follows Ĭase when CUSTOMER.While it’s tempting to convert date and date time strings to characters in the data model SQL, I strongly discourage this practice. I will use this dummy column for sorting purpose laterģ) Now select combined with similar request option, create the request like as earlier mentioned and apply filter on state, Using Advanced -> "filter based on result of another request" and point to the first request (item 1) using the Browse. Add one dummy column to the report and hard code value ‘1’. Save the request under shared folders in some name.Ģ) Create another request with necessary columns needed and apply filter on "Orders count" such that it will display only the Top 5 states. Apply filter on "Orders count" where rank(orders) is greater than 5. Though there are several ways of doing this, but I did using combined with similar request.ġ) Create a request which is having states and orders count.

#BI PUBLISHER ADD IN NOT SHOWING IN WORD PLUS#

This report should show only Top 5 states plus one record for all orders from rest of states. I had a requirement to display the number of orders each state is making in a specific time period. Note, the process the moving the BICS to on-premise database is just the same. Note : If you ignore the remap_schema then the name of the schema in DBaaS will be just the one in BICS (This may not be appropriate)ġ5) Login and verify the DB objects created in DBaaS database via SQL Developer or any similar tool. Impdp sys/ SCHEMAS=BICS_SCHEMA remap_schema=BICS_SCHEMA:DBaaS_Schema remap_tablespace=BICS_TABLESPACE:DBaaS_TABLESPACE directory=datapump dumpfile=.dmp GRANT READ, WRITE ON DIRECTORY BICS_TO_DBAAS to sys ġ4) From the command prompt run the impdp A normal user with which we login the Cloud console -> SQL workshop is not sufficient)ĬREATE OR REPLACE DIRECTORY BICS_TO_DBAAS as '/u01/app/oracle/admin/ORCL/dpdump/' You need to know the SYS or SYSTEM password. dmp transferred from the local to this directory.Ĭonnect to PDB (PDBORCL in my case) via SQLPLUS as SYSDBA.

'/u01/app/oracle/oradata/ORCL/test_ts.dbf' SIZE 1240000 AUTOEXTEND ON NEXT 1ĮXTENT MANAGEMENT LOCAL AUTOALLOCATE - Do not copy/paste as isġ1) Create a directory called dpdump under '/u01/app/oracle/admin/ORCL or any other directory of your convenience.ġ3) Move the. Schema creation is not required as it will be a part of import.

Putty (same ssh keys mentioned in point 7 is required here).ġ0) Create a table space in DBaaS to import the BICS objects. This shouldn't be a problem as the data pump utility allows us to remap them as a part of import.ĩ) Login to the DBaaS host via.

#BI PUBLISHER ADD IN NOT SHOWING IN WORD PASSWORD#

This may require the ssh keys for password less authenticationĨ) One important point to note here is the Tablespace and Schema of BICS database will be something different from what the tablespace and schema what we wanted to have in DBaaS.

dmp files more than 10 days on the SFTP server although it is not appearing in the export listħ) Once the file is on local, transfer the export dump to DBaaS host via WinSCP or any similar tool.

#BI PUBLISHER ADD IN NOT SHOWING IN WORD DOWNLOAD#

You will also notice a warning saying "Export files are available for 2 days and downloadable from your secure FTP download area in the outgoing directory." But as of today, I can see the.BICS will automatically specify a name for the dump and we cannot change it during the export.

#BI PUBLISHER ADD IN NOT SHOWING IN WORD FULL#