Bex: Restrictions

[Former Member]

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

[Former Member]

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]

hi basava,

see the help docs:

http://help.sap.com/saphelp_nw04/helpdata/en/9d/76563cc368b60fe10000000a114084/content.htm

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

http://help.sap.com/saphelp_nw04/helpdata/en/83/096d399bd2046fe10000000a114084/content.htm

cheers

sham'm

[former_member188325]

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