Loads All Project Activities - BR Report | IFS Community

Hi,

I have created BR report with 2 parameter

Project
Activity

I used 3 data sources and used ‘custom dimension connection and custom dimension LOV’ windows for connect activity dimension to the project employee allocation source and get LOV for activity. But when running report showing all activities in database instead of selected project.

Appreciate your feedback regarding this issue.

Thanks,

Deepal.

Page 1 / 1

Please check whether the project code is added as the parent item in the dim_activity.

Example:

Best Regards,
Bhagya

Hi @Bhagya Wickramasinghe

Yes, This parent item already have.

Hi @TopDeepaW,

When you run the report from the IFS BR application side is the same observed?

Best Regards,
Bhagya

Hi @Bhagya Wickramasinghe ,

In the BR client it works fine.

Regards,

Deepal

Hi @TopDeepaW,

Hope you have followed the below documentation. If not please refer these documentations to have a better understanding of the custom dimension LOV.

Overview

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/030_Custom_Dim_Lov/005_cust_dim_lov_ovw.htm

Examples

https://docs.ifs.com/techdocs/foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/030_Custom_Dim_Lov/020_Lov_examples.htm

Best Regards,

Thiwanka