How to display advanced query/datasource detailed information in Design Studio APP?
Today we are already able to retrieve and display query name, info provider, system, change date/change by, data change date, static filters, variables and dynamic filters.
However, we would like the end user also to see which restrictions/filters might exist in the query restricted key figures used, the selections made in the columns and/or rows of the query and also if possible in each cell.
Is there a way to get this information to display it in the Design Studio APP?
Kind regards Kristin
Mustafa Bensan replied
Unfortunately, as far as I am aware, with the standard functionality, it is not possible to obtain information about restrictions and selections built into the query itself. Perhaps there is a way to do this on the backend via a BEx Query that can provide metadata about a query but there are no BIAL API script functions that provide this additional information on the Design Studio side.