Skip to main content
Question

Business Reporter APPS 10-Mixed Data Sources Required

  • February 10, 2022
  • 2 replies
  • 111 views
L
Do Gooder
Forum|alt.badge.img+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 replies.

    2 replies

    L
    Do Gooder
    Forum|alt.badge.img+2
    • LOL
    • Author
    • Do Gooder
    • 4 replies
    • February 10, 2022

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

     

    T
    Superhero (Employee)
    Forum|alt.badge.img+19
    • Thomas Peterson
    • Superhero (Employee)
    • 1111 replies
    • February 10, 2022

    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 settingsAccessibility statement