Filters

building reports desktopintelligence
1

Can somebody explain me how filters work on BO ?

I have & document with

Section
Element 1 Sum(Value) of element 2
Element 2 Value

when i use a filter it works on Element 2 level. is it possible to make it works on Element 1 ?
When i Try BO says to me that it can’t apply a filter on complex values

Thank by advance

Philippe Vivier (Groupe SEB)

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

2

BOUNDARY=“Boundary_(ID_3NY/YOpJdQw+ksB36MJCzQ)”

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

–Boundary_(ID_3NY/YOpJdQw+ksB36MJCzQ)

Christophe wrote:=20

I have =E0 document with=20
Section=20
=A0=A0=A0 Element =
1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Sum(Value) of = element 2=20
=A0=A0=A0=A0=A0=A0=A0 Element =
2=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Value=20
when i use a filter it works on Element 2 level. is it possible to =
make

it works on Element 1 ?=20

I got so disgusted trying that I created a view to handle the calculations!!=20

–Boundary_(ID_3NY/YOpJdQw+ksB36MJCzQ)

Re: Filters

Christophe wrote:
&I have =E0 document = with
&Section
&=A0=A0=A0 Element = 1=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Sum(Value) of = element 2
&=A0=A0=A0=A0=A0=A0=A0 Element = 2=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Value
&when i use a filter it works on = Element 2 level. is it possible to make =
&it works on Element 1 = ?

I got so disgusted trying that I = created a view to handle the calculations!! =


–Boundary_(ID_3NY/YOpJdQw+ksB36MJCzQ)–

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

3

Listers,

If anyone can help me with this, I’d appreciate it. This question seems pretty elementary but I just can’t think of the answer right now. I’ve got a report that has several tabs in it, each tab consisting of different sale accounts with their own data. I’ve got an Excel sheet that has Sale Acct # and then the actual name of the sales account. I’m linking on Sales Acct and setting my name as a detail so that it can be brought in. My question…when I filter each tab (for a specific sale acct) I would like to have the respective sale acct name appear in the header, how do I do this?

Thanks,
Christy
_________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com

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

4

You asked:
If anyone can help me with this, I’d appreciate it. This question seems pretty elementary but I just can’t think of the answer right now. I’ve got a report that has several tabs in it, each tab consisting of different sale accounts with their own data. I’ve got an Excel sheet that has Sale Acct # and then the actual name of the sales account. I’m linking on Sales Acct and setting my name as a detail so that it can be brought in. My question…when I filter each tab (for a specific sale acct) I would like to
have the respective sale acct name appear in the header, how do I do this?

One solution:
Set as a drill filter. Then, add the cell in the header including the funtion =DrillFilters().

If your users are going to view this report in Business Objects and not just on paper, then you probably don’t need a separate sheet for each account. Your users can click on the drill filter drop down box to select their accounts. However, if the user takes the report out of drill mode, then the report will break back into sections displaying all accounts.

CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

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