BEx query syntax

[brunopaulo]

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

[mats_olin · Accepted solution]

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