Skip to Content
avatar image
Former Member

Bex Query: Too many table names in the query The maximum allowable is 256

Hi Experts,

I need your help, Im working on a Query using a multiprovider of 2 datastores, I need to work with cells to assign specific acconts values to specific rows and columns, so I was creating a Structure with elements from a Hierarchy, but I get this error when I'm half way of the structure:

"Too many table names in the query. The maximum allowable is 256.Incorrect syntax near ')'.Incorrect syntax near 'O1'."

Any idea what is happening? is ti possible to fix it? do I need to ask for a modification of my Infoproviders? Some one told me is possible to combine 2 querys, is it true?

Thanks a lot for your time and pacience.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 16, 2008 at 02:06 AM


    The maximum allowable limit is 256 holds true. It is the max no. of characteristics and key figures that can be used in the column side. While creating a structure, you create key figures (restricted or calculated) and formulas etc.. The objects that you use to create these should not be more than 256.

    Not sure if combination of 2 query's is possible. You can use RRI. Or have a woorkbook with 2 queries.

    Hope it helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Subhashini

      You dont actually join them, you create a workbook with the Bex Analyzer and insert the 2 or more queries with analisis grids, then you can use a macro for calculations between queries.

      Hope it helps.