Skip to main content
Question

Business Reporter APPS 10-Mixed Data Sources Required

  • Feb 10, 2022 4:03 PM UTC
  • 2 replies
  • 164 views
Do Gooder
Forum|alt.badge.img+2

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 replies.

      2 replies

      Do Gooder
      Forum|alt.badge.img+2
      • LOL
      • Author
      • Do Gooder
      • Feb 10, 2022 4:05 PM UTC

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

       

      Superhero (Employee)
      Forum|alt.badge.img+20

      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 & ConditionsAccessibility statement