Search results for query: *

Hello, is it possible to insert images in a report (using some VBA or ..) ? Let's imagine I have to create many cards every end of year .. In my database, I got all the needed informations: Name, Adress, Type of card, ... and the path to the picture of the card owner. If I can create a report...

Hi Folks ! I have a very huge problem of performance with the following query (containing a subquery). The table TITLE_RANGES is not very big (~ 50 rows) and my query runs for 10 minutes. Whithout the subquery an analog subquery turns less than 1 second. Any help will be greatly appreciated...

Hello, does someone know how / or if exists a possibility to forbid to make certain combinations ...* for exemple, during utilisation in Reporter, after selecting an object, it will be impossible to select another one which is incompatible. Any idea ? help hotly welcome, Benouche. [3eyes]

Hello, I have built a report with graphs (with line curves). Unfortunately, I am unable to display the zero values (i.e the curve stops when there is no value and goes on when some values are there). I've been trying to modify data format to put a zero when value in undefined .. but this seems...

Hello, is it possible to insert a SELECTion into 2 tables ? thanks, Benouche

Hello, I'm under Oracle 8i. I've created a database, then a user, but I remain unable to create the corresponding schema. I thought the creation of schema was automatic ... I tried to create one directly, or by modifying the user profile but ... no way. What can I do ???

Hello, a little question on the Where Clause. Is there performance difference between the 2 following: WHERE test1 AND test2 (solution 1) WHERE test2 AND test1 (solution 2) As test2 require many operations while test1 few, is (solution 1) best or simply equal ?

Hello, The drive of my server (Oracle 8i on Windows) crashed. some databases were there. Fortunatly, I have been able to do a backup of the disc. How to restore my database on the new drive ? Thanks in advance, Benouche

Hello, The drive of my server (Oracle 8i on Windows) crashed. some databases were there. Fortunatly, I have been able to do a backup of the disc. How to restaure my database on the new drive ? Thanks in advance, Benouche

Is it possible to create interactive Web pages using VBA ?? Let's say the first task is to create a report with a button allowing to refresh it. Any exemple (button, refreshing) is hotly welcome !!! Thanks, Benoit

My server hosting the BO database crashed (the drive crashed !)... I have no backup ! The referential is present on my local machine. All the universes/reports are available locally. What did I really lost (BO DB ...) ? How to repair reconstruct ??? Thanks for helping, Benouche :o)

which one give the best performance ?? thanks in advance, Benouche

Hello, Is there any way to get the current date (in date format if possible ...) in a sql script. Could come from any sure place (DB, Server ...) I need this for filtering datas ! Thanks a lot, Benouche [pipe]

Hello, Is it possible to call Dos command (import ...) from a sql script ??? If yes, how to do it ? More generally, is it better to do a Windows scheduled task which call sqlplus or to schedule a job in Oracle (which call Dos command -> like import). Thanks in advance, Benouche.

I have a problem accessing to a remote db thru a database link (the 2 dbs are on different servers). The same user/pwd is defined for both db and if I simply run CONNECT user/pwd@orcl, it works ! my sql is the following : CREATE DATABASE LINK dblink USING 'orcl'; SELECT * FROM MAURIENNE@orcl...

Does anyone know the price of the license for BO's ETL tool 'Data Integrator' (formerly owned by Acta) ???

Hello, I need to extract and aggregate datas from an Oracle db to another Oracle db (let's say it's an ETL task). Looking for an easy an quick solution, I thought of extracting and transforming datas periodically using BO. I can export this to a text file and then load those text files to the...

Hello, i need to extract (doing some aggregation) a table from an Oracle database to load it to another Oracle db. How can I do it ? Any easy/quick solution hotly welcome !!! Benouche

Hi ! Anyone knows how to perform intersection between 2 Queries (on 2 different universes) ??? I'm looking desesperatly for a solution: it could be done on DP's or Report level. Thanks in advance, Benouche

Hi! I need to export a report to a text file and then to import again in BO. While doing this operation, all the dimensions (in exclusion to date format) are converted to numbers and indicators (also the strings...). This creates the agregation of the datas. Does somebody knows any way to...