HI Moving the repository created in Oracle DB should be a straight forward exercise. Use the Oracle import/export utility to move the repository table/data to the new database.
after the data has been moved run supervisor module. Click in the admin button and choose recover bomain option. In...
you could create objects in designer with the @promt clause.
for example
<start date> with defintion
@prompt('!Enter Start Date','D',,,)
and then reuse the object in your where clause where ever u want.
Since you have a field which indicates which row is the duplicate. (Y/N field). create alert with condition <indicator> = 'N'. apply this alert to all columns you want to highlight.
Delta refresh is also called as incremental refresh. In the method of refresh only the data created or modified after the last refresh is delivered to the DW loading program.
Performance is the only benefit of the delta refresh.
however it need support from the source to implement delta...
check for the installation folder
Program Files\Business Objects\BusinessObjects 5.0
all exe files are under this folder.
you can manually create the link in start menu by creating link and copying to the correct folder under Documents and Settings.
Have you mentioned max in the sql definition of the measure object.
And where are u applying the filter in the DP or BO (BO u you cannot apply filter of summary varaibles created in BO.
First please mention what is the logic based of which you decide which of the 3 fields should be used to join to table b. And is only one of the three b tables is used in any sql generated in that case you can eliminate the aliases else you have to stay with ur current design
Assuming this is...
You could use one of the ETL tool like informatica, data junction. I am sure there is a ODBC driver for Lotus Notes. In the case you can write you own VB routine to transfer data.
else is there any administration tool in Lotus to convert the database into text file. then u can use sql loader to...
The objects like prompt and variables are resolved to the equivlent sql form before submitting it to the back end database. so you should be able to parse object in designer. in the case of date the fucntion you use should take constants as date
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.