A custom query (its structure) used in a WebI report needs to match the universe objects (their data types, their order) used in the query panel when a query is created. So there is a need to have universe objects.
Hi, yes that is what I’m trying to understand if it is necessary to create the universe or you can just write queries against relational database (in my case, it is Azure SQL DB)
I was reading about the Freehand SQL but not very sure about its limitations.
are there any limitation on using freehand SQL?
Say, I have some reports that are already built locally against SQL database.
(so SQL queries are already available)
we are migrating local SQL database to Azure, and will use Webi to generate same reports from Azure SQL database.
In that case, I was assessing the various options and which option would allow to re-use maximum what we already have.
If I re-write all the presentation and business logic in Webi Report
and use Freehand SQL to re-use existing queries to get the data from Azure SQL DB to Webi.
Is it feasible? are there any considerations for that approach (like performance or limitations)
the SQL that is generated in WebI when using Universe as a source is the same as you will enter in the Freehand SQL
and is the same as you will execute directly on your source DB.
Maybe this does not work with Multi-Source-Universes, because this statement has to be split up into separate parts in BO
before sending it with different syntax to the sources.
Idk about AzureSQL but with our Universe based on HANA-CalculationViews I can copy the generated statement from the WebI/Universe-source
and can run it without editing in HANA-Studio.
I also created some WebI-reports with a complex FHSQL-statement that was constructed/tested in HANA-Studio and there is no Universe involved.