What must be in place before you are able to define ‘Exception Cells’ in the query definition?
-
1 Structure
-
2 Structures, both in the rows
-
2 Structures, one in rows and one in columns
-
No Structures are required
Exception Cells in SAP BW queries require two structures: one in the rows and one in the columns. Exception cells are defined at the intersection of these structures. A single structure or no structures are insufficient - the intersection point is necessary for exception cell definition.
Exception cells let you define a value that applies only at the intersection of one specific row and one specific column in a query. That intersection only exists once you have at least two structures in the query — one placed in the rows and one placed in the columns — because a single structure gives you only a list of rows (or columns), not a grid of intersections to target. With just one structure, or two structures both in rows, there's no row/column crossing point to define an exception for.