11 Replies Latest reply: Jun 15, 2010 10:00 AM by Thom Mumaw RSS

    Loop and Distribute

    Thom Mumaw

      Good morning everyone. We just upgraded to 9.0 SR4 and Iam trying to do a loop and distribute on one of our documents. On the reduce tab I have selected values 133131 and 135231. I am controling everything through Active Directory, so I have these groups setup 133131 and 135231 setup in AD. On my distribute tab I have selected from AD 133131 and 135231. What is happening is one document is getting published called 133131 and it also contains 135231. How can I create 2 separate documents.....Thanks

      Thom

        • Loop and Distribute
          Fernando Toledo

          I think Publisher generates one file for each USER. If this user can see two groups, then the file will keep them.

          Why are you trying to split the files?

            • Loop and Distribute
              Thom Mumaw

              The user can not see both groups. I am spliting the files because one user is only allowed to see 133131 and the other is only allowed to see 135231.

                • Loop and Distribute
                  Fernando Toledo

                  Hi Thom,

                  Then you should create a file reduction in the QVW.

                  You can make it by creating an association between User and Group in the script´s "Section Access" statement. There you can load NTNAME + GROUP from AD.

                  Hope it helps!

                  Fernando

                    • Loop and Distribute
                      Thom Mumaw

                      I did not have to do this in 8.5. I should just be able to tell it to do a loop and distribute on a field and it will create individual documents based on the field (which it's not doing it's combinding all documents into one). I let AD control who sees what. I think there maybe a small bug in 9.0 SR 4.

                      Thanks
                      Thom

                        • Loop and Distribute
                          Jerry Somsen

                          Thom,

                          I have found this to be a problem with QV9.0 also. We use to be able to limit groups in the loop and reduce portion of publisher. I could only work around this by creating seperate reduction tasks. I know not the answer you wanted but I think this needs to be pushed back to QV as a issue in the new version.

                          Let us know if you find anyother solutions.

                          JS

                  • Loop and Distribute
                    Tony Nash

                    Thom,

                    I think you want to use the Loop and Reduce rather than selecting values in the Simple Reduce section. If you select the Field that contains the Groups in the Loop and Reduce dropdown Publisher will create a document for each group within that field with only that groups associations whereas selecting fields in the Simple Reduce section will create a document with data for the values selected hence getting data for both groups.

                    Tony

                      • Loop and Distribute
                        Jerry Somsen

                        Tony,

                        I believe he is using loop and reduce, but the choice to limit his loop and reduce to only certain values in the "reduction" field seems to have been eliminated in QV 9.0. It was a nice functionality that I am hoping we can get back.

                        Thom, Can you confirm that you are trying to loop and reduce only on certain values in a reduction field?

                        JS

                          • Loop and Distribute
                            Thom Mumaw

                            JS you are correct. I had to change my loop and distribute from a simple to a complete loop and distribute. In the simple loop and distribute where I specified the profit centers I wanted to reduce on seems to no longer work in 9.0 SR4. I had to select loop and distribute on a field called profit center and now it's generating QVW's for every profit center in my model. Runs way too long considering all I want to do a loop and distribute on is 2 profit centers, not 150.

                            Thom

                              • Loop and Distribute
                                Jerry Somsen

                                Thom,

                                A couple of suggestions: You could create two seperate simple reductions and trigger one off the other, or you could add a new "reduction" field in your qvw that links only to the two values in which you want to reduce on. Either one might be better than producing 150 to get 2.

                                Here's hoping the QV adds this functionality back in.

                                Good luck!

                                JS