Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 04, 2016 at 07:04 AM

    Hi Kristin,

    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.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2016 at 02:07 PM

    Hi,

    When you export a crosstab to excel we do get some metadata of the associated query in a separate sheet, like the variables and filters. But, I don't think that we have any API that we can use to display it in the design studio application directly.

    Thank you.

    Regards,

    Swapnil Koti

    Add comment
    10|10000 characters needed characters exceeded