In my universe “Multiple SQL statments for each measure” is enable.
what happen if i disable the “Multiple SQL statments for each measure” this option in universes.It will effect the data.Can any one tll what is main use of this option.
Multiple SQL Statements for Each Measure is applicable only to the measures.If this option is clicked it will force the sql engine to generate SQL queries for each measure that appears in the Query panel.
And basically it is used to solve fan trap and chasm trap problems. For that you need to read manual or search in Universe thread.
As far as I am aware, checking this option does not force separate SQL queries for each measure. It just means that you can have separate SQL queries if you wish.
I have universes with this option checked and have still had to create aliases in order to force a separate SQL query where required.
when u enable “Multiple SQL statments for each measure” option in the universe, it will create 2 seperate SQL statements in the query if your query has 2 measure objects that are coming from 2 different fact tables.