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.
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.
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 ?
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.
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.”
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.
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.