cancel
Showing results for 
Search instead for 
Did you mean: 

Forumla Variable with Exception Aggregation

former_member196080
Participant
0 Kudos

  Hello,

I've CKF in BEx, in this CKf there is replacement path Formula variable calculating number of documents.

Formula variable is replacing the value of Document number infoobject.

So definition of CKF is -> Replacement path Formula variable *1

Ckf is restricted to summation with  Exception aggregation on Document number.

This implementation is working fine but issue is its taking lot of time in query ,like while checking RSRT olap :data transfer(Event ID) is taking lot of time,majority of the query execution time and counter is going somewhere around 100K.

Do you know is there a way we can implement this count in transformation?

Thanks in Advance!

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Doing SUM in transformation takes a long time as you need to read all the content in target.

So it is better to fine tune the query.

1) Is query running long time for small selections ?

2) Trace the query in RSRT and check where it is taking long time like Data base level , Application level

Thanks

Jagan