cancel
Showing results for 
Search instead for 
Did you mean: 

Differentiate between Simple, Medium and Complex Queries.

Former Member
0 Kudos

Hi Gurus,

I am a Tech. Architect on this new project. I would like to know how to differentiate between Simple, Medium and Complex Queries in BW because I need this info to work on the Estimates. Has this differentiation got anything to do with the Backend config also?

Thanks in Advance.

Chandu.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

You need to understand the requirements and consider the following before you classify........

1) Queries that are based on multiple key figures--which may result in cell definition.

2) Queries with complex calculations.

3) Queries that are based on Variable Exits

Regards

Srinivas Bandi

Raghav_S
Employee
Employee
0 Kudos

You Could check the RSRT - technical info of the query.

This provides quite a bit of information about the queries.

There is, according to me, no single rule to classify the complexity.

It could be influenced by - formulas, lot of restrictions in structure elements, nested formulas, calculation before aggregation, read allv alues, lot of partproviders, many variables with exits, currency translation, hierarchies.. multiple hierarchies etc,

Former Member
0 Kudos

Hi Srinivas & Raghav,

Thanks for your time. Points have been assigned.

Chandu

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi All,

I got the answer from you.

Thanks,

Chandu