Multiple SQL stmt for each measure/context

[system]

Hello,

You can refer to this older topic :

120×120 10.4 KB

Greetings my B.O. friends. I am trying to understand the meaning of the (multiple SQL statements for each context) option in the SQL tab of the parameter window. What does it mean and when should it be used? In my universe I have two contexts, should I use tick this check box or not? Sorry if my questions sounds basic but I am trying to get a good understanding of this option. Thanks for your help in advance. dreameR.78 (BOB member since 2005-08-22)

And a good explanation from Dagira website :
“The setting Multiple SQL Statements for each Context allows you to split a single query into two or more passes based on the contexts in your universe.”
Source : Dave's Adventures in Business Intelligence » What Is a Context Anyway?

---

v01dv01d (BOB member since 2017-04-06)