Visualization of NOT input-ready cells in AO

[thomas_quaebicker]

Dear SCN-Community,

we are using Analysis for Office 2.3 in combination with BW-IP based on BW 7.4 to run a cost planning.

We defined one Bex Query with a structure in the columns that displays actual and planned data for different periods. Therefore parts of the AO-workbook are based on input-ready cells and parts are just readable cells. The structure contains 12 to be planned periods, but due to the selection only for certain periods planning records are available. But in the Excel-grid these unselected periods are formatted as input-ready cells. Now the user might step into the trap to enter figures in these cells and will get an error message from the backend.

In WebApplicationDesigner it is possible to activate a module called com. sap.ip.bi.rig.NonInputableEmptyCells. You can find this in SAP help under the following link: Example: Empty Cells as Non Input-Enabled Module - Business Intelligence - SAP Library

Additionally I created already an idea at the idea place but unfortunately only two votes:Display of input ready cells : View Idea

I'm looking for the same solution in AO, that non input-ready cells can be detected and accordingly be formatted.

Does anybody of you made the same experience and have a solution for me?

Kind regards,

Thomas

[reyemsaibot]

Hi,

did you tried to change the styles for input ready cells/non input ready cells?

[thomas_quaebicker]

Hi Tobias,

I'm not able to change the styles. As I have written I'm using a fixed structure with elements for each period. The time characteristic is not dynamic. The selection in the planning function determines which of the structure elements for planning figures are input-ready or not, but in AO all cells have the SAP-style SAPEditableDataCell. In WAD the mentioned module will turn the cells that are not editable into a read-only cell. I can't use the functionality "Suppress culomns with value zero" because then I would suppress even those columns where I expect that user will enter figures.

Kind regards,

Thomas

[Former Member]

Hi Thomas,

I think Tobias thought about the cell styles you can define... see the AO Help under "creating Workbooks", "Defining style sets for crosstabs" ... there you find:

SAPEditableDataCell             Format for input-ready data cells in planning change mode.  SAPEditableDataTotalCell     Format for input-ready total cells in planning change mode. SAPReadonlyDataCell           Format for read-only data cells in planning change mode. SAPReadonlyDataTotalCell   Format for read-only total cells in planning change mode.  SAPLockedDataCell               Format for locked data cells in planning change mode. SAPLockedDataTotalCell       Format for locked total cells in planning change mode.

Best regards,

Martin

[reyemsaibot]

Hi Martin,

thanks that is what I thought.

Best regards,

Tobias

[thomas_quaebicker]

Hello Martin,

thanks for your help, but my problem is that the definition which cell is input-ready and which is just read-only is dynamic. In this case I'm not able to define the cells in Analysis, the definition has to be delivered from the backend. And exactly that is what the mentioned module in WAD is doing.

So for me it looks like that other users will face the same issue in Analysis for office but in Design-Studio in combination with either crosstab or spreadsheet item as well.

Kind regards,

Thomas