Question

Business Reporter APPS 10-Mixed Data Sources Required

  • 10 February 2022
  • 2 replies
  • 84 views
L
Rank
Userlevel 2
Badge +2
  • LOL
  • Do Gooder
  • 4 replies

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?
This topic has been closed for comments

2 replies

L
Rank
Userlevel 2
Badge +2

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

 

T
Rank
Userlevel 7
Badge +18

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. 

Terms & ConditionsCookie settings