BEx query syntax

brunopaulo — Fri, 02 Apr 2021 08:37:21 GMT

Hello Community,

I installed the SAP Connector in order to use BEx query and it's all ok with this.

For script purposes i would like to know how can i select all fields at once without wrote all of them.

At the moment i have the following:

Teste:

Select [Table]

Dimensions (Field1,Field2,)

Measures (Field3, Field4,)
Units(Field5,Field6,)

From [Table];

And what i wanted is something like

Teste:

Select *

From [Table];

Hope anyone can help me.

Thank you

Bruno Paulo

Re: BEx query syntax

mats_olin — Mon, 05 Aug 2019 09:15:25 GMT

Hi Bruno, there is no SELECT * functionality in the BEx connector. There is an 'All Query dimensions' checkbox in the Sense select dialog that will include all dimensions but they will be listed individually in the script.

/ Mats

topic BEx query syntax in Connectivity & Data Prep

BEx query syntax

Re: BEx query syntax