Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] iWay DM Aggregations
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] iWay DM Aggregations
 Login/Join
 
Member
posted
I am looking for some tips and tricks to make our aggregation flows run quicker. The target table is an aggregation of our products from the invoice level by product.

one strategy we had was trying to use cache:
ENGINE INT CACHE SET ON
ENGINE INT CACHE STAT

We have placed this before our aggregation but when the flow runs, the log shows this:
DEP_4: procedure cache_on started.
: no CACHE entries
DEP_4 cache_on Return Code = 0

This of course is just one of the strategies. We understand that this is a huge aggregation. We are working on the aggregation process on our sql server but we are looking for any advice to make aggregations quicker

This message has been edited. Last edited by: Tamra,


WebFOCUS 8
Windows, All Outputs
 
Posts: 18 | Registered: November 13, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
The CACHE setting does speed up certain processing but it's primarily for use with DB_LOOKUP. Otherwise it won't help.

Assuming your source is in a relational database and that by aggregation you mean use of GROUP BY ensure that the query is passed through to the RDBMS.
 
Posts: 373 | Location: New York City | Registered: May 03, 2007Reply With QuoteReport This Post
Member
posted Hide Post
Thanks Cliff.

Yes, you assumed correctly that our source is a relational database and the aggregation is built from group by.


WebFOCUS 8
Windows, All Outputs
 
Posts: 18 | Registered: November 13, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] iWay DM Aggregations

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.