cancel
Showing results for 
Search instead for 
Did you mean: 

Query: how to use structure and selection and what's the difference between

Former Member
0 Kudos

Query: how to use structure and selection and what's the difference between these two?

Would be appreciated if some experts here give examples to demenstrate on how to use structure and selection in query and what's the difference between these two?

Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Kevin,

You can create selections and formulas within a structure. A structure you can say is a grouping of different customized query elements. Selections would be where you are restricting the values of KF (and also chars) with different char selections. Formula is creating a calculation in the query definition.

You can save a structure as a global structure and reuse it in multiple queries on the same InfoProvider. You can use only 2 structure in any query.

Hope this helps...

Former Member
0 Kudos

hi Bhanu,

Two questions related to your reply:

1. In what case we would have to consider to use a structure? Could you give an example?

2. You say "Selections would be where you are restricting the values of KF (and also chars) with different char selections", sounds like Selections is kind of Restricted KF, then what's the difference between Selection and Restricted KF?

Thanks!

former_member188975
Active Contributor
0 Kudos

Hi Kevin,

1. Well by default all the KF that you include in your query go into a Key Figure Structure. You can additionally have another structure for defining how your chars are laid out. A common example is a Calmonth structure where you have selections for 12 months, quarers and YTD values. This would be a char structure with different selections (for each month, qtr etc)

2. Yes, a selection with a KF is the same as restricting a KF. You can use am RKF is you have one on the left hand side, or if you need to do this locally in the query, right click the structure and choose New Selection, then proceed to choose your KF and reqd char values.

Hope this helps...

Former Member
0 Kudos

hi Bhanu,

Regarding to your answer to question 1. Could you let us know whether it's necessary to create another structure or what's the purpose to create another structure?

Thanks

former_member188975
Active Contributor
0 Kudos

Okay, so one would be the default structure. The other maybe required when you need fixed format reports, like the example with 12 months, qtrs and YTD values in columns. Another place where it is very useful is in financial reporting where Account number ranges or groups indicate particular financial lines. Like in a P & L statement report you need lines for revenue, COGS, EBITDA etc...these are nothing but different accounts, cost elements etc that you need to group onto a row. For this we need to create different selections in a structure.

Hope this helps...

Answers (0)