There's lots of things you can do, but it depends on the data. Try
using one or more main datastores for retrieval, then you can hopefully
filter, and either copy or share data with a dw. For the dropdowns,
you can control retrieval by inserting a blank row. You can also use
the DDDW cache service, or the regular DW cache service (which was a
little buggy in 5.x). Like I said, it depends on the data, but
remember, you can copy rows of data between dw's and even "copy"
columns if you need to (using dot notation). Let me know if you need
additional help.
HTH,
Kevin Ridley
[EMAIL PROTECTED] or [EMAIL PROTECTED]
VP of Development
EMAC, LLC.
www.emac.com
--- Mike Swanson <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> We are converting an old cobol system to PB.
> Some of the reports we
> have to duplicate are pretty complex. I have 1
> report that basically
> prints out most of the data in the database.
>
> It has an outer datawindow that joins 5 tables
> (2 are outer joins).
> Than within it it has 4 nested datawindows.
> And in one of the 4
> nested datawindows there are 10 nested
> datawindows. Right now when we
> preview this dw in the dw painter it runs for a
> period of time then
> fails and kicks me out of PB. Throughout the
> dws there are many dddws
> decoding data.
>
> We thought about flattening the data somehow
> with a stored proc but
> because of the complexity of the data we are
> reporting on (many
> multiple 1 to many relationships) this would be
> quite difficult.
>
> The nested dws seem to be the performance
> problems. They are
> re-retrieved for each dtl row in the outer dw.
> I believe any dddws on
> the nested dws are also retrieved again.
>
> Does anyone have any thoughts on how to tackle
> this problem? Any help
> on this would be much appreciated!
>
> We are using PB 6.5, PFC, and SQL anywhere 5.4.
> Base work stations
> have 128 megs and are 233 mghtz or better.
>
> Michael Swanson
> Deloitte Consulting / DRT systems
> [EMAIL PROTECTED]
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH
> LIST SERVE COMMANDS, ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING
> MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
