Search results for query: *

Mufasa/Dave Thank you very much for your help. The final query are as follow: (SELECT view1.account_number, 'ADDRESS' column_name, 'SIEBEL_VALUE' siebel_dia_flg, NVL (view1.ADDRESS, 'Null') column_value FROM siebel.fms_validation_view view1, siebel.cx_cc_parse_dia table1 WHERE...

Mufasa/Dave, You are absolutely correct in your assumption. Essentially I'm trying to compare the data between the two tables. If the data are: SIEBEL.FMS_VALIDATION_VIEW Table ACCOUNT_NUMBER ADDRESS 8255110110001478 123 MAIN ST 8255110110001478 PO BOX 1 8255110110001478 567...

Hi All, I wrote a script that would evaluate a particular data field from a view to that of another table. The script is as follow: SELECT DISTINCT SIEBEL.FMS_VALIDATION_VIEW.ACCOUNT_NUMBER, 'ADDRESS', -- FMS VALIDATION VIEW VALUE CASE WHEN NVL(SIEBEL.FMS_VALIDATION_VIEW.ADDRESS, 'Null') NOT...

Hi All, I wrote a script that would evaluate the a particular data field from a view to that of another table. The script is as follow: SELECT DISTINCT SIEBEL.FMS_VALIDATION_VIEW.ACCOUNT_NUMBER, 'ADDRESS', -- FMS VALIDATION VIEW VALUE CASE WHEN NVL(SIEBEL.FMS_VALIDATION_VIEW.ADDRESS, 'Null')...

Java, Is your "days worked" a calculated field? What are the tables you're using from the Genesys Datamart? If you can provides some additional information I'll try to help anyway I can. Kublait

I've encountered this error in the 6.x versions of Brio. When I encountered it in the past it usally means that there's a problem with the query that I created. The application will allows you to save the query but will produce this message when you try to run the query. What I'd done to pin...

I think the system is interpeting your formula as (bien/budget)<0. If the value of budget is a zero then the results is an error rather than zero. Try your evaluation only on the budget value rather than the bien/budget value. Such as if (budget<0){0} else (bien/budget) Hope that helps

mstepPCI, I'm not familiar with Redbrick. However, this SQL scripts: (datepart(wk, dateadd(dd,-1, TABLE_NAME.COLUMN_NAME)) = datepart(wk,dateadd(dd,-1, getdate())) - 1) Hope this helps.

What type of database are you using? the SQL syntax between Oracle and MS SQL are slightly different.

Have you try using the Custom SQL as your variable limits? You can set the SQL statement to something like: to_char(sysdate)-8 So when you schedule it to run on any given day it will only extract the data from 8 days ago. Hope that helps.

Hi Alastair, I've heard of Nortel's Symposium but have never had the opportunity to work with it so I can't really give you an answer. As to your second questions, yes you can use Crystal reports on the Genesys platform. Here are somethings to consider. Genesys and Brio are partnered so...

I open the form with the PDF reader, but it doesn't allows me to fill out any of the fields. I guess the author didn't added the necessary funtionality. I guess I'll have to print it out and then fill it in by hand. Thanks for your help.

Thanks ArtieChoke that help.

Hi all, My experience with PDF file have been mainly using the "Reader" to view previously created file. Lately I've encountered PDF files (OK, they're employment application forms)that requires me to print it out, fill in the necessary field and then mail or fax it in. I prefer to type in the...

Moepower, We ran into similar problem. This is caused by the application of the Microsoft KB824141 update to the Windows 2000 system. To our knowledge Brio currently do not have a patch for the problem. Upgrading to Brio version 6.6.4.40 or uninstalling the update patch will solve the...

andornot01, We run the Fact and SCD concurrently. I don't think there are any particular other than it was originally set up that way and we just left it.

andornot01, You're right. We're currently using PowerMart 6.1. Does the 5.1 version have "Workflow Manager" ? The Workflow Manager is where I added the Command Task. To answer your other question. SCD is Slowly Changing Dimension. I've actually configure it to run the same time as the...

We have Informatica installed on a box call DEV-1 with only one repository(Repository-1). This is our development environment. We have installed Informatica on another box call TEST-1 with a blank repository also call Repository-1. We use the repository backup "REP" file from DEV-1 and restore...

Let say you have 4 work flows. Starting with "Extract", then "Dimension Load", then "Facts Load", then ending with "SCD Load". The last step in the "Extract" workflow is a Command Task that calls a batch file that executes the "Dimension Load" workflow. Then the last step on the "Dimension...

Petman, I have yet to find a quick way to do this. What I've done in the past is to access the repository database. Determines which tables the metadata for the scheduled jobs are stored and then duplicate the necessary line items in the tables. You might have to involve your DBA with some of...