cancel
Showing results for 
Search instead for 
Did you mean: 

Bex: Restrictions

Former Member
0 Kudos

Hi

Can some tell me some general restrictions we have in Bex query designer? (Eg: Maximum number of Free chars/Chars in a query)

Thanks

Basava

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi

For BW queries running in BEx, the excel limitation applies, like 65536 rows

thats the reason the web template comes into picture. if you have any case like the number rows might be more than 65k rows. you can use the web templates..

There is no limitation of rows when we are reporting using the web templates as they are output in the browser.

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a563fe09411d2acb90000e829fbfe/content.htm

Former Member
former_member188325
Active Contributor
0 Kudos

MAx no of structures :2.

2structures can either be in rows or columns.

You cant have 2 KF structures or 2 Characteristc Structures. A Keyfigure can't be included in a characteristic structure and a Char can't be in a KF structure.

Exactly speaking there is no restriction on haveing Chars/Free chars in Query designer.In some caeses it allows you to use all chars from respective infoProvider....but again it depends on many factors..You to keep in mind performance issue also....Try to use all Chars and KFs of Your InfoProvider in Your Query then you will ger better idea.

Don't forget to assign points if it helps.

Thanks