Skip to main content

Hi All, I have 2 questions:

1.Do I have to create an IAL and import it as a quick information data source, if I need to join two different sets of data together to form a BR report? 

  1. Is it possible to use SQL in BR to just join two data sources? Can a ‘SQL Burst’ be added into BR if it does not already exist?

ok, sorry. That was actually 3 questions. Please don’t judge!

 


Hi, 

 

I can answer 1.  No you “may” not need a custom IAL.  You can use multiple data sources in BR.  But what if the selected data sources do not reasonably connect in terms of the meta data. Then yes, you may need to find a creative way to link the data and display that as an IAL. 

So, generally not, but maybe.    

For 2, I have seen no evidence that you can write SQL in BR, but I’m not an expert, I was, but it’s been improved and I have not kept up.