Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display only the latest entry?
- Thread starter mortac8
- Start date
Hi mortac8,
If you have a look to the BusinessObjects support website, you will find a solution for you.
The article number 726 explain what to do:
How can you display only the lines belonging to the maximum date / week via the Query Panel ?
*****CONFIGURATION******
Any 4.x version
***********SYMPTOMS*******
You want to make a query fetching four objects (or more):
-two dimensions A and B (or more)
-a date D.(another dimension)
-a quantity Q. ( a measure), (or more)
You want to fetch the data for the last date entered for dimensions A and B.
**********RESOLUTION******
There are 3 solutions to this problem. This first is below and the other two are referenced in the MORE section below.
It is possible to fetch the lines giving the latest dates for each combination of A and B.
You must insert a calculation in the query panel.
1. Drag object D to the 'conditions' window of the Query Panel.
2. Choose operator 'equal to'
3. Select operand 'Calculation'
4. In the 'Select an Object' window of the wizard select object D
5. In 'select a function', select 'Maximum'.
6. In 'define the level of calculation', select 'by one or more objects' and select objects A and B.
7. In 'synchronize your calculation', select 'for each value of one or more objects' and select objects A and B.
8. In 'Select the number of values to compare', select 'All Values'.
9. Click Finish.
I tried myself and it's working fine
Hope it will help you
GKar
If you have a look to the BusinessObjects support website, you will find a solution for you.
The article number 726 explain what to do:
How can you display only the lines belonging to the maximum date / week via the Query Panel ?
*****CONFIGURATION******
Any 4.x version
***********SYMPTOMS*******
You want to make a query fetching four objects (or more):
-two dimensions A and B (or more)
-a date D.(another dimension)
-a quantity Q. ( a measure), (or more)
You want to fetch the data for the last date entered for dimensions A and B.
**********RESOLUTION******
There are 3 solutions to this problem. This first is below and the other two are referenced in the MORE section below.
It is possible to fetch the lines giving the latest dates for each combination of A and B.
You must insert a calculation in the query panel.
1. Drag object D to the 'conditions' window of the Query Panel.
2. Choose operator 'equal to'
3. Select operand 'Calculation'
4. In the 'Select an Object' window of the wizard select object D
5. In 'select a function', select 'Maximum'.
6. In 'define the level of calculation', select 'by one or more objects' and select objects A and B.
7. In 'synchronize your calculation', select 'for each value of one or more objects' and select objects A and B.
8. In 'Select the number of values to compare', select 'All Values'.
9. Click Finish.
I tried myself and it's working fine
Hope it will help you
GKar
- Status
Similar threads
- Locked
- Question