Skip to main content

Our Business Intelligence team want to access data for reporting purposes, however some tables have default prefilters defined at the subjects highest level. So I’ve made BI variants of these tables and gave the BI role read-rights on the corresponding tables. 

I’ve checked the documentation about API’s but can’t find a endpoint that calls for a specific variant of a subject/ table. I vaguely remember that I saw this functionality somewhere but can’t find it. 

Questions:

  1. Is it possible to call for variants inside a endpoint? (domain.com/indicium/iam/alias/agreement?$variant=power_bi)
  2. Is it possible to turn off all prefilters in the endpoint? This would be an alternative solution.(domain.com/indicium/iam/alias/agreement?$prefilter=off)
  3. If 1 and 2 are negative, is there an alternative solution?

Hi Dennis,

You can call the variant like this:

domain.com/indicium/iam/alias/agreement.power_bi

You can find this in the documentation here:

OData API | Thinkwise Documentation

(Search for “Request url to retrieve all records from the overview variant of the project entity”)

Reply


Terms & ConditionsCookie settings