Query structure limited to 999 elements

[jan_vereecken]

We have a situation where we are exceeding the allowed number of elements in our query (BW 3.5). The major problem is the way the query counts the elements.

Imagine we have CKF1, having 10 elements, and we have CKF2, having 5 elements. If we use these in our query, we would have 15 elements. That’s logical. If we would then apply another CKF3, being the sum of CKF1 and CKF2, then we will add again 15 elements to our query, totalling 30 elements. So for every reused CKF in another one, he recounts all the elements from the used Key Figures.

Within a cost breakdown report, we easily reach 999+ elements if BW calculates this way.

Question is, do you have a solution for this, and how does BW 7.0 behave in this situation?

Kind regards,

Vereecken , Jan

+32 477 418 928

[jan_vereecken]

Clear answer

[Former Member]

I am working in 2004s and the structures are still limited on 999. HOwever I did a test where we have a 2 different CKF which sums 3 different RKF. I created CKF1 that sums those two CKF. I then created CKF2 which sums CKF1 and another CKF. WHen I go into the back end it only added 2 to the number of KF in the structure. So to answer your question.

in 2004s yes there is a restriction on 999

As for the double counting I did not get that issue

[jan_vereecken]

We are considering that solution only if the same limitations are still valid in BI 7.0.

[Former Member]

The limit is still 999 elements per structure.

You can check this in RSRT -> Technical information -> Statistics

There you find a max value.

[Former Member]

Have you thought of maybe creating an extra datamart layer that would contain a good proportin of these key figures pre-calculated? Or maybe just integrating a few in the existing cube/ODS? Finally, maybe virtual key figures could also help you there...