Greetings! I have a dilemma that I know the “manually intensive” way of doing it but am looking for an “automated” way.
Let’s say I’ve got 10,000 rows in my cube and it’s split up by a Salesperson code (100 rows per salesperson). I’m going to create a report tab per Salesperson so I’ll create the first report and get it all formatted the way I want it, put a filter on it for Salesperson code = “001” and I’m done. I then duplicate the report 100 times resetting the filter for each tab for the new salesperson code… it now has become ugly and very manual intensive.
Is there a script out there somewhere that can automate this task? Would the “AddComplexFilter” function be it? If so, how can I have it loop through the salesperson codes? Also (for bonus points), is there an automated way to set the name of the report tab equal to the filter? (i.e. report tab #1 has a filter of salesperson = “001”, I then want the tab to say “001”)
Thanks!
Shawn Leven
Southwestern Bell
Information Services SL7699@SBC.COM
You Wrote:
Let’s say I’ve got 10,000 rows in my cube and it’s split up by a Salesperson
code (100 rows per salesperson). I’m going to create a report tab per
Salesperson so I’ll create the first report and get it all formatted the way
I want it, put a filter on it for Salesperson code = “001” and I’m done. I
then duplicate the report 100 times resetting the filter for each tab for
the new salesperson code… it now has become ugly and very manual intensive.
Unfortunately, we have had the same problem here and after getting very tired of looking for an automatic way we decided to get BO Reader licenses for all of our sales people and then put prompts in. This was the solution for us not sure what your purpose is but as of yet we were not able to find any other alternative. Good Luck! And if you do find a solution please share!
Michele Robertson
Southern California Edison
Analyst
Phone: 909-394-8573
You should be able to do this. Most of the code is pseudo-code.
Read the salesperson column, and for every distinct value (you may need to have an extra DP to bring back these distinct values) : Start loop
'create a new report tab
set MyReport = ActiveReport
MyReport.Duplicate
MyReport.Name = salesperson
Apply a template
Set a complex filter
End loop
Andrew J. Erthal
Orion Project Manager
Business Objects University
Chicago Office (847) 391-9898
St. Louis Office (314) 209-1994
St. Louis Fax (314) 209-7926