Query as InfoProvider - Percentage Function

[Former Member]

Hi guys,

I am facing a problem when using a query as an Infoprovider. I flagged the query as InfoProvider in RSRT and connected it to a DSO via a transformation. Within the Query I have a formula column that is calculating the percentage Share of another key figure by using the function "%GT Percentage Share of Total". Somehow this seems to cause problems, as the DTP I am using to load the query data into the DSO always provides the following errors:

When removing the calculated column including the percentage function the DTP works just fine and gets a green result.

Any ideas on that issue? Are percentage functions a known restriction when it comes to using queries as InfoProviders? I wasn't able to find anything in the documentation on that topic.

Many thanks in advance,

Tobias

[nora_roch]

Hi Tobias,

use the 'constant selection' as described in KBA:

1951436

Cheers,

Nora

[former_member197660]

Hello Tobias

Please try to realize the calculation of Formula in Calculated Key figure and try to load the data.

Probably local formula is not supported although I have never tried this type extraction.

Ashish