Automated Filtering

BO 4.1
Teradata

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


Listserv Archives (BOB member since 2002-06-25)

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


Listserv Archives (BOB member since 2002-06-25)

Shawn,

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


Listserv Archives (BOB member since 2002-06-25)