Monday, September 10, 2012

How to create cell definitions in BEx report?


Cell definition is functionality available in BEx Query Designer tool which allows you to address every cell of your Bex report in particular. By this you can uniquely define content of each cell. 

You may face a situation when you want to create cell definition in your BEx report but icon of cell definition is not appearing. First of all there is a prerequisite for cell definitions. It is that you must have a two structure in your report. One structure would be in row and other in columns. By intersection of those two structures you address every each cell.

While you have two structures ready in your report then icon of cell definitions on BE’x toolbar is available:




If you click on that icon you get into new tab strip in BEx Query Designer where you can design your cells:

 
Useful links:

PS: I recently had to use query with cell definition as a source of data for BusinessObjects WebI report. I was curious either this feature is even supported by WebI. My version of WebI was based in BOE 4.0 edition. According WebI user guide there are a lot of limitation on BEx queries while being used in WebI. E.g. Number of objects allowed in a query = Do not use more than 50 objects in a BEx query, otherwise an error occurs. Anyway my quite huge and heavy query with approximately 250 defined cells worked in WebI.

No comments: