1. Daniel Ferreira
  2. PowerBuilder
  3. Wednesday, 12 April 2017 13:40 PM UTC

Hi guys,

I've created a sales nested report to be used in multiple DWs. It's a nested with grand totals, This nested has a "sub" nested that shows payments forms (so it's a nested inside a nested).

So far so good. The thing now is that the main DWs that use this nested (regular DWs with the nested dw on the summary band) will have additional functionallity (filter options to be precise).

My questions are: which option do you suggest, and how to code it?
Option 1: My first choice: dinamically alter the nested, adding a "where clause" to re-retrieve the nested data;
Option 2: Filter the nested dw (that will be a bit more complex, because the nested doesn't have the columns to filter, so I'll have o change the nested to bring all data and use computes)
Option 3: something I haven't thought of;

And how would I go around coding it? GetChild won't do, they are not composite. How I'd get around re-retrieving or filtering the nested and sub-nested?

 

Thanks a lot.

Daniel

 

Daniel Ferreira Accepted Answer Pending Moderation
  1. Wednesday, 12 April 2017 14:12 PM UTC
  2. PowerBuilder
  3. # 1

Thanks Chris,

Although the use of retrieval arguments may sound interesting, I'm affraid there will be too many of those, with weird combinations. But the ideia is indeed simpler.

I'll try to change the prossessing to 5 and see how it goes.

Thanks!

Comment
There are no comments made yet.
Chris Pollach Accepted Answer Pending Moderation
  1. Wednesday, 12 April 2017 13:55 PM UTC
  2. PowerBuilder
  3. # 2

Hi Daniel;

  My first inclination would be to try & use various retrieval arguments in the nested DW objects. The other aspect might also be to convert these to Composite type DW's where a GetChild() method could be used. Remember, Composite DW's can have retrieval arguments.

HTH

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.