Create a VC Model for BEx queries with Cell Editor

[Former Member]

Hello All,

I am trying to create a VC Model for BEx queries with Cell Editor.

BW Development Team has created a BEX query with complex restrictions and calculations using Cell Editor feature of BI-BEX.

The query output in BEx analyzer is correct where all values are being calculated at each Cell level and being displayed.

But, while creating VC model, system is not displaying the Cells.Thus, no VC Model can be created.

I have executed below steps:

1. Created a VC Model for BEx Query - ZQRY_XYZ

2. Create Iview -> Create a dataService -> Provide a Table from the Output

In the Column field system is not showing any of the Cells (present in Cell Editor)

Please help me to solve this issue.

Thanks,

Siva

[Former Member · Accepted solution]

Hi

If 'Cell Editor' is been used then that query must have the structure in it. You have to select that 'structure' object in your 'VC Table'.

If you select that then you will get the required result in the output. This structure will be the structure where 'cell reference' is used in BI query, You have to select that structures name.

Regards

Sandeep