12 réponses
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
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 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
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.
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.
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
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
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
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.
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 Katia,
I imagine the answer is coming too late, but just in case: you select the problematic column BO, right-click, then choose "Format Cells" and in the numbers, you take the one without thousands separator.
The trick in Excel this time: within the cell, you select the space, then press Ctrl+C (that will copy it); next, your goal is to replace all those spaces with nothing, so use the keyboard shortcut Ctrl + F, then paste your space (Ctrl+V), and click "Replace All."
Let me know if this was useful
Good luck
Best regards
Laure
I imagine the answer is coming too late, but just in case: you select the problematic column BO, right-click, then choose "Format Cells" and in the numbers, you take the one without thousands separator.
The trick in Excel this time: within the cell, you select the space, then press Ctrl+C (that will copy it); next, your goal is to replace all those spaces with nothing, so use the keyboard shortcut Ctrl + F, then paste your space (Ctrl+V), and click "Replace All."
Let me know if this was useful
Good luck
Best regards
Laure
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.
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 Lotfi,
I would be happy to help you if you could give a bit more detail.
When you talk about scheduled requests, do you mean document scheduling so that it refreshes automatically or something else?
When you say it doesn't work, do you get an error message, does nothing happen, or something else?
Please elaborate on your problem so that the forum can assist you.
See you very soon.
I would be happy to help you if you could give a bit more detail.
When you talk about scheduled requests, do you mean document scheduling so that it refreshes automatically or something else?
When you say it doesn't work, do you get an error message, does nothing happen, or something else?
Please elaborate on your problem so that the forum can assist you.
See you very soon.
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.
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.
Hello,
The best thing is to create an object:
- if you always want to apply it to the same column ==> of type condition (yellow funnel) in the universe of the month-year type of the system date under Oracle it gives ( ( DM_TEMPS_D.ANMOIS )=to_char(sysdate, 'YYYYMM') ).
DM_TEMPS_D.ANMOIS = name of the column to test. Be careful with the format
- If this condition should be usable with different columns then it is preferable to create a dimension type object in the universe under Oracle it gives to_char(sysdate, 'YYYYMM'). This way users can set conditions like date object equal to the current month.
- if it is impossible to modify the universe, you can customize the SQL by adding a where clause like WHERE ( ( DM_TEMPS_D.ANMOIS )=to_char(sysdate, 'YYYYMM') ).
DM_TEMPS_D.ANMOIS = name of the column to test. Be careful with the format.
To customize the SQL you need to click in the query editor on the SQL button and enable the option to use custom SQL.
I hope this can help you.
Good luck
SALY31
The best thing is to create an object:
- if you always want to apply it to the same column ==> of type condition (yellow funnel) in the universe of the month-year type of the system date under Oracle it gives ( ( DM_TEMPS_D.ANMOIS )=to_char(sysdate, 'YYYYMM') ).
DM_TEMPS_D.ANMOIS = name of the column to test. Be careful with the format
- If this condition should be usable with different columns then it is preferable to create a dimension type object in the universe under Oracle it gives to_char(sysdate, 'YYYYMM'). This way users can set conditions like date object equal to the current month.
- if it is impossible to modify the universe, you can customize the SQL by adding a where clause like WHERE ( ( DM_TEMPS_D.ANMOIS )=to_char(sysdate, 'YYYYMM') ).
DM_TEMPS_D.ANMOIS = name of the column to test. Be careful with the format.
To customize the SQL you need to click in the query editor on the SQL button and enable the option to use custom SQL.
I hope this can help you.
Good luck
SALY31