Recent content by nchapman

If i have object A within my Designer Application system, and I want to create a workarea that only contains the latest version of object A, how do i code this in the workarea rule ? (Presumably I use include_object, but what is the the exact syntax for this, as i cannot seem to get it working...

Wondered if anyone out there has any views/opinions on Materialised Views. Anyone had any bad experiences with them ? Anyone got any advice, things to look out for ?

Does anyone know where I can get information (white papers etc) giving crictical independent appraisals of Data Mining Software tools. I am putting together a paper for my company, in which I would like to put forward some suggestions on what we should use. For info. We are using an Oracle 8i...

Can you retrieve a file back from where you publish your site to ? (I am thinking of access database files, which may change constantly on the server)

I am trying to create a website whereby users can only access it, if they create a user, and then login. What is the best way to approach this with Frontpage (nb. i am using FP2000). When the users have logged in, i will want data (which is to be got from an Access database), restricted to...

Hi, am not a SAS expert, but have been given the unenviable task of working out why our business users cannot connect to our oracle database when running SAS via unix (not via the PC). We receive this error..... ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. The SASORA code...

I have a query which has a lag statement nested within a CASE statement. Please see the output from sql below. Could anyone tell me why in order to get rid of the "ORA-00932: inconsistent datatypes" oracle error I have to place either a "to_date(....'dd-mon-rrrr') around the...

We will be undertaking an evaluation of the above software. Has anyone any views/opinions on it? Any good points/bad points ?

Am working on a Banking Transactional Data Mart. We have come across a potential issue with our Data Marts, and would like opinions on this. Within my transactional mart, we have a instances where some of the facts will have an associated record in one of the dimensions, but other facts will...

Krishnaa279 and JGirl, thanks for replies. JGirl :- With respect to joint balances. For our business, we may want to find out who in particular made a Credit Card transaction, ie. was it the primary account holder or secondary. Both people on the account will have the authority to operate. We...

Am desiging a Banking Data Mart. More specifically one which analyses transactional data, across all products. (eg, Credit card, Savings account and Deposit account transactions). Ideally would like peoples thoughts on how best to design this. Bearing in mind I have such issues as.... How...

Where is this "Global Shared Workarea", within the RON ? Are you talking from a "administrator" viewpoint ? I cannot see other application systems, and can only enter my own one, which is where I am doing this work.

I have been looking through the online help, without much success. I am not sure if I am understanding what you are saying. Is the following the same as your solution ? (I am not sure what you mean when you say, "select your application system node") I have design editor open, and...

Apologies, but how do i change this ? Where do I go to change it in Designer ?

Hi, I am currently reverse engineering our schema into Designer 6 (Version 6.0.3.9.0). I am looking at reverse engineering the PL/SQL packages/procedures/functions. I am using Design Editor to do this. Now these procedures etc were reverse engineered a while ago. They have now changed and I...