Recent content by MrGinge

Thanks Tom & Tamhas. The requirement is to build a reporting database based on a star schema methodology, containing data from multiple sources (mainly progress databases), which will be accessed by end users purely via an SQL-based reporting tool and will support around 300 concurrent users...

Yes there's a lot more detail that we are also considering, much of which is why we started with a perception that progress would be the most suitable platform for us to sit this database on. Ultimately though, the deal breaker will be how does this thing perform from a user perspective. If it...

There are also advantages to simplifying data structures, consolidating data from multiple sources, providing conformed dimensions, pre-aggregation ...etc Which bits are more important depends as much on individual business process as it does on IT Strategy. Your example may be a solution for a...

Thanks chaps. really struggling to find any examples or evidence that anyone has tried to do this before - which in itself tells me that is probably not the most sensible idea.

Hi, So i have two databases - one in openedge 10.2b on aix, one in SQLserver 2008 R2 Both databases contain the same data and have the same table structures. The SQL database has no indexes. The progress database does. Performance on the progress database via odbc is somewhat lacking and...

Hi, does anyone have any experience of building / implementing a data warehouse (star schema not 3nf) on an openedge platform? All reporting output would be generated via a reporting tool e.g crystal, cognos ...etc Just looking for any pointers / pros & cons etc Thanks, MrG

I'm working on an application which uses the standard OCX tabstrip (OE10.1). Unfortunatly (for me) we have certain fields with on leave of... validation. If the user inputs duff data but leaves the field by clicking the tabstrip, then the validation error fires but the tabstrip still changes the...

Anyone out there using MSRS directly on progress dbs? I'm trying to get a handle on how easy/difficult it is to get working properly. We have some limited use of it at the moment, with any reports designed through visual studio. No one is currently using the report builder utility, because...

trying to get into GUI and have a (hopefully basic) issue that i can't get my head round. the application i'm using is written and supplied by a third party but we have the ability to bolt new devs onto it. however, we supposedly cannot run any new persistent procedures which gives me a bit of...

oh well, somehow im not surprised about this.... thanks anyway

I've got a selection list in CHUI but i don't want to display the box around it. I can do this in a browse with the NO-BOX option. Is there a nice easy equivalent for a selection list?

I’m looking at a piece of development where I want to organise and display my data in a hierarchical way. Essentially I want the users to be able to create and modify a kind of file system and then assign other records into these specific locations. My initial idea is to simply store my...

Oh yes, didn't think about that one! Just out of interest if anyone has any examples of how to change it direct on the widget it may be handy. Thanks, andrew

Here's a quick one (hopefully)- Is there any way i can reposition the title of a frame within CHUI? Rather than have it appear centered I want it left justified. thanks, andrew

assuming saturday and sunday are non-working, try this to get the number of working days. assign tdays = today - start-date do i = 0 to tdays: if weekday(start-date + i) > 2 then wdays = wdays + 1. end.