LOV - Save (like Variant)

building reports webintelligence
1

Hi,

We are using BO XI 3.1 and SAP BI 7.0 as data source.

Can we store or save LOV as a user list so that the same can work in all other reports? To make it very clear:

Let’s take a dimension Brand… I would like to create 3 below user list based on “Brand” dimension:

User List 1
AA1
AA2
BB1
BB2
BB3

User List 2
CC0
CC1

User List 3
DD1
DD2

My goal is to save this user list (globally) so that if I can use this user list for several webi reports. Is this possible in BO Web I? This way the user can create or modify the user list and then run all the web i reports based on user list.

Thanks
Shabo

shankarbo (BOB member since 2005-11-14)

2

There’s no functionality in BusinessObjects to do this. However, where there’s a will, there’s usually a way. 8)

You can create a database table for each list, and then create a web form that allows users to update the contents of the tables. Then, in the report, create a subquery against the required table.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

Thanks Michael Welter.

I understand this method. But this makes user to work on 2 application (1. Web Form and 2. BO WebI).

First the user need to update the list by web form and then they need to run the report.

Also our BO XI 3.1 implementation is on top of SAP BW query; where we donot have subquery option in WebI Report.

Thanks
Shabo

shankarbo (BOB member since 2005-11-14)

4

We had a request like this on a recent project… the user wanted to be able to save / update a report “profile” that would contain things like their most frequently selected report parameters and so on. It’s an awesome idea, however it’s not really something we have available today without external coding.

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Yes Dave. Have you seen this done in BO with external coding? If yes, still I have doubt we can achieve in one application (within BO itself); without going for any web form or something else apart from BO Web I.

I have seen other reporting vendors have this option; but not in BO.

Thanks
Shabo

shankarbo (BOB member since 2005-11-14)

6

Yes, of course you would have to include some sort of input for the user in order to capture their profile data. When and where that is done becomes part of the system design.

Dave Rathbun :us: (BOB member since 2002-06-06)