Hi to all,
1- I’m not quite familiar with SAP Business Objecs Enterprise XI - Web Intelligence document
2- There is an existing DOCUMENT that contains 5 REPORTS (5 TABS i believe it’s also called)
3- I need to be able to use the SAME report on different BLOCKS or PieCharts of every REPORT (tab). Because otherwise i need to go in every tab of the document and change the REPORT FILTER which is redundant.
Is that possible and how ?
NicolaTesla (BOB member since 2007-02-15)
you mean a filter that the user selects in the report to be applied on multiple reports? doesn’t work that way. you could put a prompt on the query which would apply to the entire document. or if it’s a regular filter you could put that filter on the block in each report (tab). if it’s a drill filter though, no way to do what you want that i know of.
erik.stenson 
(BOB member since 2012-07-30)
In fact what we want to do is this`:
Apply the same FILTER that is changed every 4 weeks manually whenever there are new “Ressource Managers” that comes in or out of the company but we have 5 reports (tab) in our Docuement.
So we need to manually go and change on each report (tab) and on each block that FILTER.
Can we create a REPORT FILTER OBJECT and that way whenever we create a PieChart object or crossTab simply point those pbjects to that specific report filter ?
NicolaTesla (BOB member since 2007-02-15)
you could manually update the report every time. or if you do it on the query level then you could set up a predefined condition on the universe and just update the predefined condition in the universe each time.
erik.stenson (BOB member since 2012-07-30)
That’s exactly what i mean: as of now i have to manually change the report (tab) filter but on EVERY one of the reports (tab). I would prefer diong the change once (bvecause we are delaing with the same filter).
Please see attached file of the structure of my webi document in order to have a better idea of what we presently have. The FILTER applied on the block we see is repeated (exactly the same) on other BLOCKS of all the other REPORTS (tabs).
I think that what you are saying here is better: “set up a predefined condition on the universe and just update the predefined condition in the universe each time.”
But seems harder to do ?
FILTERS ON BLOCK 1.doc (59.0 KB)
NicolaTesla (BOB member since 2007-02-15)
well if it’s ok to have the filter at the query level then it would work and wouldn’t be harder, assuming that you have access to the universe and can get universe changes done in a timely manner… guess it depends on the process you’re working with to put changes in. from a technical standpoint, however, it’s easier to just do it in the universe.
erik.stenson (BOB member since 2012-07-30)
Before going further with our UNIVERSE changes, can you please takle a look at the print screen of the attached file i just posted before this post ?
Thanks !
NicolaTesla (BOB member since 2007-02-15)
sure so you’re just filtering certain resource managers. as long as you don’t need to show data for those not in the list in the document using that query that we would propose fiiltering then you would be ok just filtering on the query level. you could hardcode it into the query and then edit the query each time you need to change the list, or create a predefined condition in the universe and use that in the query and update the universe object each time you need to change the list. another option would be to put your list into a table and then have a subquery in your report query that says inlist and refers to the column from the table containing the list then you could manage your list changes on the database side.
erik.stenson (BOB member since 2012-07-30)
Create a Variable, that has an in list (A;B;C;D) = 1
Then put that Variable in the Report Filter for all Reports and Select 1
Every Time you change the Name in the Variable (A;B;C;E), it should ripple through
Steve
jasper7 
(BOB member since 2007-09-26)
Have you considered using an Input Control?
There is a method discussed here which will fulfill your request: Webi 3.1 Input Controls on Different Tabs
From my testing, this won’t work with XI R3.1 SP3 (12.3.0.601).
YMMV.
HTH
NMG
mcnelson (BOB member since 2008-10-09)