BEx Pre-Queries and Allow External Access

[Former Member]

Hi

We have a BEx query which has a pre-query included to restrict a list of users for a particular group. This runs fine in BEx but when Allow External Access to this Query is ticked the query falls over in BEx with this errors:

The initial exception that caused the request to fail was:

Termination message sent
ERROR Brain (137): The query cannot be released for OLE DB for OLAP
  MSGV1: MAMCTMP100_EU_PQ
  MSGV2: MAOCTMCUS_PRE_QUERY
ABEND BRAIN (635): QueryMAMCTMP100_BOBJ_PUB_500 could not be opened.
  MSGV1:MAMCTMP100_BOBJ_PUB_500

Are BEx queries with pre queries supported in universes, should the Pre-Query also be released for external access?

Thanks

Charles

[Former Member]

Hi,

If you are using calculated key figures that use functions such as total report then the option "released for external access" is not allowed.

Are you using special functions in key figures that prevent to use external access option?

Diier

[Former Member]

Hi, yes the Pre-Query contains input variables. Changing this to a hard coded value helped a little but we need the pre-query to restrict the end user results.

Are there any workarounds for this?

[Former Member]

Hi Charles,

I'm interested to hear if you have any best practices or answers for this. We are running into many of the same issues.

Thanks!

[IngoH]

HI,

does the pre-query contain variables ?

Ingo