Business objects help

Hello Laure,

Sorry for my late reply but I was on vacation.
Indeed, you cannot apply a filter on the max formula as it is calculated locally.
However, if the goal is to obtain:

- a table listing each address with its maximum date, you can declare your formula as a variable by clicking on the formula bar on the define as variable button and then remove your date column from the table.
Thus, you will get the maximum date for each address.
- a table listing multiple instances of the address with the different dates with an indication on each line of the maximum date by address, you can create a variable calculating the maximum date by address
=Max.(<date>) In (<address>)

so on each line the maximum date will be displayed

- otherwise you can export your data to Excel (select the block then edit copy all to BO then paste into Excel) and re-import it into BO with the maximum date declared as a dimension

There you go, I hope I helped you a bit

Best regards

Salima

Hello

You create a variable Dimensions that will identify your problem, either "=If isnull(your row) then "NOK" Else "OK"", don't forget to name it.
You go back to your report, right-click on the table border, format a filter by keeping the "OK" option from your filter.
From then on, each time you refresh your report, the empty boxes will no longer appear.

You need to insert a filter in the filter format and indicate that values = 0 should be hidden.

MENU FORMAT - FILTER
position yourself in the table that needs to be filtered
click on add
select the object that should be filtered
select the filter
click on define
indicate the formula
good luck

You can also try an alert, it's better than the filter because if your request returns no empty data you won't be able to put it in the filter.

See the forum here: Programming

An alert is not bad: when the value = 0, set the text color to match the background color of the cell, for example.
However, the affected row will still be there. If you want to completely remove it, you need to filter.

Hello,

I have a problem with the BO filters (version 5.0): for some variables, I don't know why but it is impossible to set a filter. Do you know how I can work around this issue?

Thank you

Laure

Hello,

Is it a block filter, a global filter, a condition, a complex filter, a ranking?
Is the variable of dimension type, indicator, information?
Does it come from the universe or is it a local variable (renamed formula), a personal object?
Detail the issue please and we will be happy to help you.

Best regards

Hello,

It would be great if you could help me...
In an Excel table, I have the equivalent of an address and a date. But I can have multiple dates for the same address.

So I have pulled this data, the pulled date being by default a dimension. Then, I created a variable max(date) that returns the last date for each address which is an indicator.
On this variable, I can't seem to put a filter on the block: I'm used to right-clicking on the column (or on the block), but in this case, it doesn't offer me the option to filter by this indicator.

Thank you very much for your help,
Best regards

Laure

Hello,

I need help with BO, let me explain: when I import data from BO into EXCEL, some columns are not numerical, so I have to re-enter this data in order to work with it.

In EXCEL: nothing works, I've tried a bunch of manipulations in vain.

Thank you for your help.

Have a good day.

Hello,
I have only one report in Web Intelligence (Business Objects XIR2) and I have three users.
I would like to grant view rights for each user, but the data is confidential, which is why I want each user to see only their own data.
So I have three companies A, B, C, each with a revenue,
in the Public folders I have a report that edits revenue by company,
my boss is asking me that company A should see only its revenue.
Thank you for your help.

Hello,

I would like to create a query that would allow me to list certain information for the current month.

I drag & drop the date field to the filters, but I can only "specify a constant, choose from a list, or open a prompt...". Is there a way to variable the date, like getcurrentmonth?

The goal is to be able to schedule a document that will be published each month (for the data of the current month) without any manual action?

Thank you for your help.

Best regards.