Skip to main content

Hi,

is there any way to achieve this in Business Reporter?

SELECT MAX(result_seq_no)

 

We run a job several times each month, generating values for our projects. Each time, the results are logged it creates a new result_seq_no., I only want to fetch the highest (newest) sequence for my projects into my Business Reporter report.

 

Eks data in IFS Cloud:

Project result_seq_no Values
A 1 1
A 2 2
B 3 1
A 4 5
B 5 3

 

When fetching to Business Reporter, I want this:

Project result_seq_no Values
A 4 5
B 5 3

 

Is this possible, or do I need to set this in the Information Source?

​@oyandresen  There are advanced BR Parameter Functions that you may be able to use (Solution Mgr/Reporting and Anlaysis/Business Reporter/BR Parameter Functions).  These can also be extended if you need to create your own.  You’d then use the parameter in your workbook design (Design Mode/Report Book/Parameters/Function Parameters), to identify the records with sequences equal to the max sequence per project.

BUT, a lot really depends on what your data looks like in your Information Source.  Each record would need to be marked with the sequence to correctly identify and aggregate the data.  You may get unexpected results.

You may find it easier to create your own Quick Information Source based on a view that pulls the latest sequence.  

Reply


Terms & ConditionsCookie settings